Creating a Database

  • Thread starter Thread starter Shell
  • Start date Start date
S

Shell

In Access 2000, In code how do I

1. Create an access database
2. copy some tables from the original mdb to the new mdb.

Thanks
 
In Access 2000, In code how do I

1. Create an access database
2. copy some tables from the original mdb to the new mdb.

Thanks
Click to expand...

Open Access.
Click on File + New
select Blank Database.
Name the database and the folder you wish to place it in.
Then click on File + Get External data.
Click on Import
Navigate to the database you wish to import data from.
Select the tables.
Click on Options.
Select Definitions and Data.
Click OK
 
NO, no

I have to do this all in code.
--
Shell


fredg said:
Open Access.
Click on File + New
select Blank Database.
Name the database and the folder you wish to place it in.
Then click on File + Get External data.
Click on Import
Navigate to the database you wish to import data from.
Select the tables.
Click on Options.
Select Definitions and Data.
Click OK
Click to expand...
 
Go into the VB Editor and make sure you've got a reference set to the
Microsoft DAO 3.6 Object Library.

Use the CreateDatabase method to create the new database, and the
TransferDatabase method to copy the tables.
 
You've described a "how" (i.e., by creating a new database).

Why? I assume you are trying to solve a business need, but the folks here
won't be able to offer much in the way of specific suggestions if we don't
have an idea what is to be solved...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top