2 users

[TOPSie]

I am trying to support a highly bespoke Access system. The system has only two users with their own PCs running the same accdb and the data mdb on a server all in the same room.


Some of the table are getting quite large (One at issue is 176000 records)
Today (maybe earlier) the system is crashing (just disappears) when a complex query/update is performed on this table.

I have tried it on my separate dev system without issue using the same mdb. And after rebooting the users PC and doing a bit of debugging it is now working.

I suspect that the issue only occurs when the two users are in the same area of the database.

The area of "database sharing" is a bit of mystery, can anyone give me any pointers?

Many thanks

[Welshgasman]

Each user should have their own FE and be linked to the BE.?

Is that the case with your setup?

[TOPSie]

Yes sorry - I said each PC has the same accdb - I should have said each PC has a copy of the same accdb - they share access to a single mdb on a server.

Is thi something to do with record locking? The mdb currently has Default record locking = No locks, but then a set of values in the "Open database by using record level locking ???

[Welshgasman]

TBH, I have always left my DB's as Shared and No locks, which appears to be the default.
Then again, i could not say for certain that anyone would work on the same record as another user.?

[Micron]

You compact/repair this db regularly and have done so to see if that remedies this issue? 176K records isn't really all that many and is usually the cause of slowing down, not crashing. I suspect Access doesn't like something about what seems to be the one query that causes this. Perhaps the debugging you did will solve that problem. If your post is about db sharing then you've got the right setup and it seems you're not using wifi or a wan for this, so all good there. Methinks your main issue was/is that "complex" query.

[mike60smart]

Is the Db split into a FE and BE ?

[Emmanuel]

Do check if your database has attachments. Because tables with attachments like pictures or documents do make the data grow so fast