Duplicate databases being saved

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good afternoon,

We have a database that about 8 users access on a regular basis. Somehow,
we are getting the BE database to replicate - about 30 times since May 07 -
named as: db1, db2, db3... db30

We do have users access via VPN.

Each user has FE loaded on individual computers linked to BE db on server.
The FE compacts on closing, Record Locks are off, Using Access 2000.

Any help would be appreciated.
 
Turn off Compact on Close on both the FE and BE databases. That's probably
what's causing the duplicate database files.

As an Access database file can be as large as 2 GB, if your database needs
to be compacted that often, there's bigger problems.
 
You probably have multiple users on a single front-end, making it impossible
to rename the open database after the compact. Make sure each user using
terminal services through a VPN is logging into their own copy of the
front-end. I accomplish that on a Terminal Server by creating a folder that
only 1 user can log into. If 2 users can log into the same front-end you
have a recipe for corruption. Compact on close is unnecessary on the
front-end. I did like fresh copies of the front-end and so I used a login
script to replace the user's front-end. That way we accomplished 2 things: a
freshly compacted front-end with each login, and an easy way to upgrade
every one.
 
Back
Top