Split Database not linking

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zanstemic - 26 Feb 2007 00:22 GMT

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?

Reply to this Message

Tom Wickerath - 26 Feb 2007 01:21 GMT

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
__________________________________________

> I have a split database that has been working perfectly. Recently I started
> to codevelop the FE and just ran into a problem.
[quoted text clipped - 7 lines]
>
> Any suggestions are greatly appreciated?

Reply to this Message