This error is happening when only one user clicks the shortcut to the database. While trying to open the database he receives this error when someone else is in the database.
If no one is in the database he can open just fine without an error message.
It is happening with all databases stored on server if someone else has opened it first.
Checked file associations. Verified all settings are the same. I have reinstalled Office Professional and it worked correctly for about two weeks and then started to repeat the initial problem as stated above.
He can open the database while someone is in it if he launches Access first then uses File, Open but not from the shortcut or database on server.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening. This article shows how to create and use them.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things into separate tables:
Make sure that all record…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …