Who is corrupting my database?

[GordonR]

I have a database running on a Citrix server to serve multiple users. It was in Access97 but I recently converted it to Access2002. Since then the database seems to report that it is corrupted quite frequently. I suspect that a user is causing it by powering off without closing down. The problem is how to prove it! I found a good article on MS Knowledgebase (285822) which will display logged on user details but when the database gets reported as corrupt I cant log in to run the code!

Any thoughts would be appreciated.

 

[Ron_dK]

Gordon,

Do a search for audit trail on this forum.
You'll find lots of good examples.

Ron

 

[GordonR]

Thanks RAK!

Gordon

 

[ghudson]

You need to create a table that will store the users info when they open the db and remove their info or mark them as logged out if they exit your db the correct way [meaning that they use your exit button]. There are a lot of ways to do this but that is the short version on what you need to start with.

Then you can check the table and see who has not logged out the correct way.

 

[ilkka]

File size?

Access may start corrupting files when the size grows to 80Mb+.

 

[neileg]

You can't power off under Citrix, unless you mean someone is shutting off the server.

 

[GordonR]

Auto session termination

Thanks all for taking the time to reply,

I intend to post the value of Environ("username") on Form open and remove it on close to prove the point, but I now think it is because the users citrix session is being automatically terminated after a period of inactivity (sorry users - damn the administrators!!)

Regards,

Gordon