I get a message when opening A access 97 database

J

John Vinson

On Thu, 24 Mar 2005 12:45:05 -0800, "Rod W" <Rod
Error: 0 - Do you wish to re-establish a link to the database now?

Evidently the program is executing some code to relink the database
you're opening to its "backend", a second database containing your
data tables.

Try holding down the Shift key while opening the database, if
answering Yes or No to the error prompt doesn't solve the problem.

John W. Vinson[MVP]
 
R

RodW

Should include this DB has worked fine for years and has had no problems,
it's about 5 MB
 
R

Rod W

Thanks, Trying

John Vinson said:
On Thu, 24 Mar 2005 12:45:05 -0800, "Rod W" <Rod


Evidently the program is executing some code to relink the database
you're opening to its "backend", a second database containing your
data tables.

Try holding down the Shift key while opening the database, if
answering Yes or No to the error prompt doesn't solve the problem.

John W. Vinson[MVP]
 
R

Rod W

No luck, will try again though

John Vinson said:
On Thu, 24 Mar 2005 12:45:05 -0800, "Rod W" <Rod


Evidently the program is executing some code to relink the database
you're opening to its "backend", a second database containing your
data tables.

Try holding down the Shift key while opening the database, if
answering Yes or No to the error prompt doesn't solve the problem.

John W. Vinson[MVP]
 
R

Rod W

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.
 
R

Rod W

Even after restoring an old copy, from last week and 5 years ago, still no
luck, the program looks like it gets messes up too.

Any Ideas?
 
J

John Vinson

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]
 
Top