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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database Splitting Problem

Status
Not open for further replies.

Garridon

Programmer
Mar 2, 2000
718
US
I recently used the Database wizard to split the database.&nbsp;&nbsp;dbMgtBackEnd has the tables, and dbManagement2000 has the forms, reports, and macros.&nbsp;&nbsp;I'd like to be able to put it into a shared directory so that somone else has access to it.<br><br>But ... I tried a test by moving the database into a different directory.&nbsp;&nbsp;When I tried to open one of the forms (from a button that uses a macro), I got a macro error message saying that it couldn't find the database in the old directory.<br><br>I tried relinking the tables, but it still does the same thing.&nbsp;&nbsp;How do I correct this?<br><br>Thanks!<br><br> <p>Linda Adams<br><a href=mailto:Garridon@aol.com>Garridon@aol.com</a><br><a href= Adams Online</a><br>I'm a professional writer, published internationally.
 
When you relinked the tables are you sure it didn't add the table into the database window with a &quot;1&quot; after it?&nbsp;&nbsp;It's possible you created a link to the correct database and table but it just added the table in a second time with a different name.&nbsp;&nbsp;If that happened just rename the relinked tables to the original table name.&nbsp;&nbsp;If that is not the case we will go from there.
 
Yes, it did create a second table with a one after it.&nbsp;&nbsp;Thanks!<br><br> <p>Linda Adams<br><a href=mailto:Garridon@aol.com>Garridon@aol.com</a><br><a href= Adams Online</a><br>I'm a professional writer, published internationally.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top