Access 7.0 Error Messages

K

KDawes

I am getting the following 2 error messages. And would like assistance with
them both. I think they are related.

While logging in to the program (Kruse Contol) that uses the Access 7
database, I get and error "3197 error has occured n the db.bas-updatetables"
If I hit okay it allows me to get in to the database and continue working.

When I attempt to compact the db I get an error message that reads "Data has
changed; operation stopped" and does not allow me to compact. I did repaire
the db sucessfully prior to attempting the compact.

ANY and ALL help would be greatly appreciated.

K. Dawes
Fluid Components Intl.
 
T

Tony Toews

KDawes said:
I am getting the following 2 error messages. And would like assistance with
them both. I think they are related.

While logging in to the program (Kruse Contol) that uses the Access 7
database, I get and error "3197 error has occured n the db.bas-updatetables"
If I hit okay it allows me to get in to the database and continue working.

When I attempt to compact the db I get an error message that reads "Data has
changed; operation stopped" and does not allow me to compact. I did repaire
the db sucessfully prior to attempting the compact.
Click to expand...

Try importing the MDB into a new MDB.

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

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
 
Top