I have an Old Access Database that is going "Flaky"

[Guest]

I have an old MS Access database I wrote a few years ago that has worked fine
for years. In the last few weeks, however, I am starting to get Visual Basic
Errors about defining my variables that I never got before. Also, a data
update routine that use to work without fail every day ( by bringing in
system data via ODBC) is now not always working.

Does anyone have any ideas on where I would look for corrections?

 

[John Vinson]

I have an old MS Access database I wrote a few years ago that has worked fine
for years. In the last few weeks, however, I am starting to get Visual Basic
Errors about defining my variables that I never got before. Also, a data
update routine that use to work without fail every day ( by bringing in
system data via ODBC) is now not always working.

Does anyone have any ideas on where I would look for corrections?

Try the suggestions at

http://www.granite.ab.ca/access/corruptmdbs.htm

You should CERTAINLY have backups - if you can solve the problem by
restoring a backup from some time ago, do so; if not, try the
suggestions in Tony's site. Decompiling, compacting & repairing,
creating a new database and importing - all can help.

John W. Vinson[MVP]

 

[Tony Toews]

I have an old MS Access database I wrote a few years ago that has worked fine
for years. In the last few weeks, however, I am starting to get Visual Basic
Errors about defining my variables that I never got before.

What is the exact error message? Could an Options Explicit statement
somehow sneak into your code that wasn't there before?

Also, a data
update routine that use to work without fail every day ( by bringing in
system data via ODBC) is now not always working.

Does it fail with an error message? Not even start up? Partially
update? Any more symptoms?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm