database splitter

[yessir]

i just went to use the database splitter and it says that i do not have that option installed, and i do not have the disk anymore as i got it as part of the MSDNAA.

WHERE can i get it quickly!

 

[scottfarcus]

To split a database...

Go to Explorer, and find your database.
Copy and Paste it in the same folder.
Change the name of one of the identical files to identify it as the back end or data file...

So you would have:
Employees.mdb and Employees_Back.mdb

Open Employees.mdb and delete all tables (it's OK they're still intact in the data file).

Open Employees_Back.mdb and delete all queries, forms, macros, reports and modules.

Go to Employees.mdb and right-click in the database window. Select Link Tables.

Find the newly created Employees_Back.mdb file and select all tables. Click OK or LINK.

You have successfully split your database.

 

[yessir]

thanks

thanks again!

 

[jennilewis]

Is that all the wizard does?!