ms access courses in london - Multiple User Conflicts

Resolved · Low Priority · Version Standard

Tue 14 Nov 2006, 16:17 Delegate Nick said...

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?

Thu 16 Nov 2006, 09:57 Trainer Richard said...

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.

Training courses

	98.7 % recommend us
	More live stats...

Training 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