Owner and right problem on access database

[Sam]

Hello,

I have problem with an Access database.
Here, I have a relatively important Access database (about 80Mo) shared on
a server where all users can connect themselves. This database is used with
a VB program with admin right.
Sometimes (I don't know when exactly), some tables lose their owner. The new
owner attributed is "engine" with the associated rights. Consequently, these
tables are not accessible anymore and are seen like tables systems.

For the moment, we manage this problem by overriding the database by a
backup but we lose data each time.

Would somebody have already had a similar problem and could help me to
manage this situation?

Thank you

Sam

 

[Guest]

Could be something not written correctly in the VB program.

It could also be corruption. Tony Toews has an excellent web page on
database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp