General discussion

Locked

Access97 Corruption

By CLT-IT_Tech ·
When my users leave work, they leave their connection to our Access97 database open. If I have NT auto-logout these users, will their forced-closed connection subject the database to corruptions?

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access97 Corruption

by lyallaust In reply to Access97 Corruption

Not exactly sure about access, but i know MSWord creates a temp file of anything it opens, so if the system does crash MSWord tries to recover the temp file rather than the original. Check the directory that the Access file is located in for hiddenfiles when you have Access running and a file open. (usually named with a tilde (~) in front of it's usual name)

Collapse -

Access97 Corruption

by CLT-IT_Tech In reply to Access97 Corruption
Collapse -

Access97 Corruption

by MelodyJ In reply to Access97 Corruption

It may do that. I've had users shut down their NT box without the usual shutdown procedure (they just hit the power switch), and it corrupted the database. But this hasn't happened every time they've done this. To be on the safe side, i wouldn't do a forced connection close without shutting down the database first.

Regards,
Melody

Collapse -

Access97 Corruption

by CLT-IT_Tech In reply to Access97 Corruption
Collapse -

Access97 Corruption

by acwiz In reply to Access97 Corruption

Create a seperate Shutdown database. Attach a Shutdown status table to the PC app. have the PC database check status (On timer event)of a hidden form. If the status is Shutdown have the database do an Application.quit. Use this all the time it works great to lock the system and do nightly backups and compressions.

Collapse -

Access97 Corruption

by CLT-IT_Tech In reply to Access97 Corruption

Sounds terrific... Hope my developer understands the technique!

Back to Web Development Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums