No, Still prompts for re-establishment of links, yes wants to know where to
link it and no says database will now close.
I can send it to you if you want me to.
Sure... my consulting fees are available upon request. They're not
particularly cheap and I have an eight hour minimum; I'd be able to
look at it early next month.
I think you have a split database, and that the backend database has
been moved or renamed. This is not an Access error message; it's
coming from your application, which I presume has code to find the
backend. If you don't know where the backend is, then sending me the
frontend won't do you any good anyway, since if neither you nor the
frontend have that information, I *certainly* don't!
Try searching your hard disk (or your backups) for a .mdb file with
the same name as your database but with _BE appended to the name (e.g.
MyData_BE.mdb). However, the developer might have named the backend
anything.
Another suggestion is to open the database using the Shift key
(bypassing the code); on the menu select Tools... Database
Utilities... Linked Table Manager. This should show you where Access
thinks the tables should be, and at least give you a start toward
finding the backend.
John W. Vinson[MVP]
