Data Corruption With Linking

[Eric Heinold]

I have a shared data folder with multiple users accesses
data. Each user has a program file (another Access
database) installed on their desktop and connect to the
shared data.

Due to extreme slowness linking tables, a decision was
made to use queries to link. Our queries basically
say "SELECT * FROM tblTest In 'S:\data\test.mdb';"

This caused a problem with open forms because the test.ldb
is not created until a form is opened. Because of the
fact that Access tries to create a new .ldb before using
the existing one, the form opens very slowly each time.

I fixed this problem by opening a hidden form that
connects the test.mdb. However, now when users do
processing (we have a lot of code - it's a payroll
application), the test.mdb file will get corrupt. This
did not happen before I started using the hidden form.

Is there anything I can do to fix this problem?

Thanks,

Eric Heinold
AdaptaSoft, Inc.

 

[Eric Heinold]

-----Original Message-----

says...

Hi Eric,

I have to ask an underlying question - why are you relinking tables so
often? Once an Access table is linked to the application, it should
open and run quickly. Is the back-end location changing that often that
you have to actually relink the tables?

It might be that your network is extremely slow or intermittently
failing. In that case, the hidden form is losing contact with the
database, which could cause corruption. Evidence of this would be "Disk
or network error" messages - are you seeing these?

--
Armen Stein
J Street Technology, Inc.
Armen _@ _ JStreetTech _._ com
.

Armen,

Thanks for the response.

We relink so often because the we have different database
sets. The application can have up to 250 different
databases with the same tables, just different data.

No, the problem is not the network connection. We see
this problem on several different networks, and are not
getting the "Disk or Network Error" error.

Thanks,

Eric Heinold
AdaptaSoft, Inc.