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 ...

In Microsoft Access, you can rename or delete a database table or other objects such as forms, reports, and queries. We show you how to do it.

Learn how to create a Comments Table, add database objects, etc, using the Application Parts feature in Microsoft Access.

Use this guide to learn how to easily create and manage a MySQL 8 user with remote access to all databases.