Creating a table into another Access database

G

Guest

Is there a VBA command or SQL statement for me to run a Make Table Query to
create a table in another Access database? I would like to distribute
several access databases to different groups with tables populated with data
specific to the group. I don't want to create the tables in the main
database and transfer the table, because there's many tables and it would
probalby exceed the 2gb limit of MS Access.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to export table from outlook into ms access table? 0
Open Matching Record in a Form in Another Database 0
Replacing a Table with a Table from another database - reference issues 1
Can't create table 4
Access Database 3
Drop a table before creation in SQL? 8
Accessing SQL Table through Access 3
Is it possible to split access database with runtime or by vba code ? 1

Top