Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

ms access courses in london - multiple user conflicts

Forum home » Delegate support and help forum » Microsoft Access Training and help » ms access courses in london - Multiple User Conflicts

ms access courses in london - Multiple User Conflicts

ResolvedVersion Standard

Nick has attended:
Access Intermediate course
Access Advanced course
Excel Advanced course

Multiple User Conflicts

When using the database (standard client handling database, around 500 records) we often get an error message stating someone else has accessed the record and changed it while in use. This isn't true a lot of the time, but if you attempt to overwrite these (imaginary) changes the database record corrupts in to a load of Chinese looking symbols and then cannot be deleted.

Any ideas?

RE: Multiple User Conflicts

Would suggest that your database is corrupt at some level. One thought would be to find a backup of your database at a stage when the corruption was not happening.

How long has this error been occuring? Were any changes made to the database on a structural level. I would also do a thorough check of the hardware it is hosted on.

Serveral causes of this could be:
Hardware error, access code error, virus.

If you could paste the specific error as a reply here in inverted commas, perhaps we could find out more specific information.

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.