ms access courses in london - multiple user conflicts

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

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

resolvedResolved · Low Priority · Version 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:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.



View all Access hints and tips


Server loaded in 0.08 secs.