Access Database

[Bill]

I have a database that is used by 150 different people. It resides on a
server and the tables are linked to each different database. Recently it has
become unreliable. When appending to the main table from any one of the
different databases it will loose some of the records that are being
appended. It has worked now for over a year and started giving trouble a
month ago. Does anyone have any idea of what is happening? We are using both
Access 2007 and 2003 between the different databases. Would this cause it?

 

[Douglas J. Steele]

Are you saying that each of the 150 different people are using a single
database that exists on the network?

Your application should be split into a front-end (containing the queries,
forms, reports, macros and modules), linked to a back-end (containing the
tables and relations). Only the back-end should exist on the server: each
user should have his/her own copy of the front-end, ideally on his/her hard
drive.

Having multiple users share the same copy of the application can lead to all
sorts of problems, including issues such as you're describing.

 

[Jackie L]

I take it that you are not using SQL as your data platform. I think any
suggestions I could give, short of switching to a SQL backend will be futile
but here is a link to Allen Browne's document on preventing corruption. Take
special note on points 2, 4, 12 and 13.

http://allenbrowne.com/ser-25.html

Hope this helps,
Jackie

 

[a a r o n _ k e m p f]

Bill;

Jet can't reliably hold 10mb of data for two users.

SQL Server is free.

you're a fucking idiot for trying to use an obsolete database