Split Database not linking

Z

Zanstemic

I have a split database that has been working perfectly. Recently I started
to codevelop the FE and just ran into a problem.

The frontend now when linking wants to link to each table and creates new
tables adding a number after the name. (ie. table1, table2, nexttable1,
naxttable2, etc)

No new tables or changes to any fields were done by either developer to the
best of our knowledge.

Any suggestions are greatly appreciated?
 
T

Tom Wickerath

Hi Zanstemic,

I have run into the situation periodically where the Linked Table Wizard, or
even the re-linking code that I use, will only re-link one table at a time.
To fix this, I delete all linked tables from the FE database, compact the
database, and then re-create the linked tables from scratch, using File > Get
External Data > Linked Tables.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 

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

Top