I use this statement to realize access multi-user edit at the same time, but failed, is someone who knows how to return a responsibility?
CNN. Open the Provider="Microsoft. Jet. The OLEDB. 4.0; Data Source="& amp; "C: \ Database " & amp; ChooseYear & amp; "The data. The MDB;" & "; The Jet OLEDB: Database Password=123
".
Rs. Open the "Select top 1 ID from [Data] order by ID desc", CNN, adOpenKeyset, adLockOptimistic
.

CodePudding user response:

Imperfect Access support for multiple users, is only suitable for single user use,
Please change to use SQL Server among multiple users

CodePudding user response:

Change the SQL SERVER.
The simplest approach is directly in the SQL SERVER manager import access
Then code change the links in the string, the other don't have to move.

CodePudding user response:

Company limited, can only use the access

CodePudding user response:

People looking for a solution of multi-user operating sample!
Who is in charge who clappers

CodePudding user response:

With too many users to edit, I need to ACCESS the Shared,
But overall, trouble trouble, the key is that slow,,

CodePudding user response:

Can be achieved,

Solution a: customer service mode

User Settings for the customer, a server is responsible for the Access database to read and write,

Scheme 2: token mode

Add a table, the only field is the only record the token, set to pessimistic mode,

Before each to write any data table, token value updates from 1 to 0, if update is successful, received the token, namely access,

Written after the data table, to be given to token update 1,

Any reading token to 0 or update user token failure, must be random time delay, try to read and update again,

There are, of course, can be set for each application data table a token table, write different tables of the user do not conflict each other,

CodePudding user response:

Just want to the solution at the time,
Put the program and ACCESS a folder, and then share the folder,
And then assign the client a program shortcut,
There is no more of this method is more simple and efficient, and don't slow, as for concurrent, five operation not too big problem at that time, the ACCESS as if haven't collapse,

CodePudding user response:

Many operations collapse is not terrible, terrible is a sharing violation operation result in invalid data was used as a valid data!
Like many people at the same time on an account to access 100 yuan when sharing conflict...
The original poster can lose money on it,

CodePudding user response:

refer to the eighth floor zhao4zhong1 response:

people collapse operation is not terrible, terrible is a sharing violation operation result in invalid data were used as effective data!
Like many people at the same time on an account to access 100 yuan when sharing conflict...
The original poster can lose money on it,

Logic says won't appear! As to this level of concurrency, who also will use the ACCESS.