Take that recordset and use it to create a new table (a temporary one) in the local Access database.<BR>3. Close the recordset.<BR>4. Run my report off the new temporary table<BR>5.

I'm connected to and manipulating a Access Database using a VB frontend. But I'd like to add a simple table with 2 fields and populate it and I'm not sure how to go about doing this, google ...

Learn how to build tables with the Table Designer in Access. The process will help you analyze large amounts of information, and manage data efficiently.

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.

You must first create a new database, then create the tables that store the website information. Access is beneficial for small websites and webmasters who are unfamiliar with database structures.