Access in a multi-user environment not functioning

[dowlingm815]

i have an application that has set up as a multi-user environment, through the options, Tools, Advanced, settings as follows:

DDE operations: Enable
OLE/DDE timeout (sec): 30
Refresh interval (sec): 60
# of update retries: 2
ODBC refresh interval (sec): 1500
update retry interval (msec): 250
 
 
Default File Format: 2002 - 2003
Default open mode: Shared
Default record locking: no locks
 
Selected: Open databases using record-level locking
 
 
 

Occasionally, users have issues access the database.

[MMcCarthy]

The recommended setup for a multi user environment is to split out the backend data into its own file on the server and then give each user their own executable frontend.

Otherwise you will often have problems with the database lock file.

[Jesse Jones]

MMcCarthy,

That sounds very similar to a problem I'm having. I have a split access database with up to fifty simultaneous users. The back end is on a server. I put the front end on the server as well in a different location, but it is still locking often. If I distribute a front end to all of the users for them to store locally on their machines, will that stop it from locking? That seems to be what you are saying, but I wanted to check.

[dowlingm815]

My error occurs during the creation of a table via a SQL statement. Therefore, it will be replaced by create table code to avoid mis-naming a fields' properties. I would guess there is a more efficient way, but I don't have time to research.