Access Backup Created

[curtyrut]

Hello, can anyone explain why access creates a backup file when end users are attempting to access the database? For example, the end user is from Germany and trying to access a shared folder that contains the database and each time she attempt to access the database a serious of errors appear. In addition, access creates a lock key record that remains when the end user exits. Thanks for you help.

FYI, the access database contains many macros, and VBA used to manage the database.

 

[RuralGuy]

When was the last time you did a Compact and Repair of that database? It sounds like it may have some corruption.

 

[gemma-the-husky]

probably because it thinks there is a problem (corruption), and it is trying to repair the database.

get everyone out of the database. take a copy. then open it, open a code module, and try to compile the code.

access may well report that the dbs is in a inconsistent state anyway.

Important points:

Is the database split
Do all users access (ie use) a distinct copy of the front end database.
How does the German user connect to the database

If you are all sharing the same copy, and you have a foreign user sharing the same copy, then this is likely to be the cause.

 

[curtyrut]

Important points:

Is the database split
Do all users access (ie use) a distinct copy of the front end database.
How does the German user connect to the database

If you are all sharing the same copy, and you have a foreign user sharing the same copy, then this is likely to be the cause.[/QUOTE]

Hello gemma-the-husky, the database is not split and all user are accessing the same copy. The German user connect to the database using a shared driver specific for the database. I guess this will hold true for China users? What can I do mitigate these problems? Unfortunately, this database must be shared in order to capture accurate statistics. Thanks.

 

[curtyrut]

When was the last time you did a Compact and Repair of that database? It sounds like it may have some corruption.

Hello RuralGuy, yes the compact and repair was executed and unfortunately that did not resolve the problem. I watched one user attempt to access the database and the first thing I noticed was how long the database took to respond. I've since then engaged IT to trouble shoot the timing issue and I also think that is causing some of the problems. Thanks.

 

[Minty]

Hello gemma-the-husky, the database is not split and all user are accessing the same copy. The German user connect to the database using a shared driver specific for the database. I guess this will hold true for China users? What can I do mitigate these problems? Unfortunately, this database must be shared in order to capture accurate statistics. Thanks.

You need to investigate splitting the database and giving each user their own front end.
With users sharing a front end you will get corruption and endless problems. http://www.fmsinc.com/microsoftaccess/DatabaseSplitter/

 

[RuralGuy]

Hello RuralGuy, yes the compact and repair was executed and unfortunately that did not resolve the problem. I watched one user attempt to access the database and the first thing I noticed was how long the database took to respond. I've since then engaged IT to trouble shoot the timing issue and I also think that is causing some of the problems. Thanks.

Here's three links that may help:
http://allenbrowne.com/ser-25.html
http://allenbrowne.com/recover.html
http://allenbrowne.com/ser-47.html
It is vital you split this database and have each user using their own FrontEnd.

 

[curtyrut]

Hello and thank you all for the recommendations. I was able to split the database and moved the front end to the shared folder. However, my next step/question, how can I send each user a copy of the front end without breaking the links and maintaining the security permissions in addition to the reporting, coding, and the like?

Thanks.

 

[RuralGuy]

Are your users using some form of Remote Desktop software like Citrix?

 

[curtyrut]

Are your users using some form of Remote Desktop software like Citrix?

Hello RuralGuy, all end users were granted read/write permissions to a shared network folder.

 

[RuralGuy]

I wanted to know how the users in another country were accessing the database. GoToMyPC, LogMeIn, Remote desktop?

 

[curtyrut]

All users/countries were provided a network path to access the database.

 

[RuralGuy]

Wow, each country is using a T2..Tn line to the db? I'm surprised they get acceptable performance. Getting each user their own copy of the Front End after you split the db can easily be accomplished several ways. Here's a couple of links to those methods.
http://btabdevelopment.com/free-access-tools/
http://www.autofeupdater.com/

 

[curtyrut]

Hello, unfortunately I am unable to get my split database to work on end users' local drive. The error message received is a run time error 3044 stating the path the back end is stowed is not a valid path. I need help ASAP. Thank you in advance.

 

[RuralGuy]

What is the path to the BackEnd? When you split the db did you use the Linked Table Manager to hook them back up again?