Losing DB Connection

S

Susan

I have an Access DB that links several tables through
ODBC Connection and 1 table stored in Access. This DB is
used weekly by more or less 35 users. Every week around
the same time 1:00 to 1:40pm the DB loses network
connection creating a backup file and locking the DB
until every one exits so the DB can open exclusively to
repair.

I can not control the network but can I change some
settings within the DB like making the ODBC refresh
interval 3 minutes instead of 25. Will that just
increase traffic on the network and cause more problems.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Corrupt Database 4
Vista prevents multi-users from logging into linked db 0
network users can't connect to backend tables 1
Linked tables to SQL 1
ODBC to Access Dumping Question 7
1 SQL Server/3 Db's to connect to 2
Linked Tables and SQLServer and Remote Users 1
Using Access to create reports of a FileMaker Pro DB 1

Top