Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Split up db

Status
Not open for further replies.

MrMajik

IS-IT--Management
Apr 2, 2002
267
I am developing a mdb locally on my hard drive. When it is done I want to be able to export the tables to a file server and keep the forms, reports, queries, etc local for easy updating purposes. Several people will access these tables.

When this is done how do I move the tables out of the mdb and on a directory on a file server?

The tables are simple in design. Here is the table relationship:
tblParent <- one to many -> tblChild

Thank you.
 
Just make another database on the server and import the tables into that db. Then go to the front end(original db) and delete them from there. Then link the tables from the server to the front end.
 
cainemart; I have that done except I can't see how to link the tables to the form.

 
Duhh...HELLO!~!! If the answer to this was any closer to my face it would jump up and tear my blind head off.

This issue is closed.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top