going crazy with error messages

[eleanor b]

Please help me - I am working on a database - at the moment just doing very simple things with queries, entering data etc. I keep getting error messages almost everytime I try to save something - most of the time it saves the changes anyway, but I can't even make new queries at the moment, it just refuses to save them.

The database is shared between five computers and is on Access 2002 (ver 10)

This is driving me mad, especially as I am planning some bigger development but of course I can't if it is behaving like this.

thank you for any advice.

eleanor

 

[ecniv]

I guess its record locking and I am guessing again that the front end and backend are all in one (all tables, queries, reports, forms amacros and vba code altogether).

When a person edits a record (bound form) it holds that record open until they save (and move on). It holds around 2kb on either side as a page locking, this of course happens to lock not only the record being editted, but those on either side, depends on whats in the record depends on how many are locked.

If you are thinking of redoing this, first get all the tables done right, then hold them in one mdb (shared area). The forms, local tables, vba, and queries should then go into another mdb (front end) which can be copied to the users C drive for less network activity and a slight improvement on speed.


Also I personally like the unbound forms as the only time it locks the record is during the code to save which is a tiny amount of time, so shouldn't affect other users.


Vince