Urgent - Access 2000 - multi-access on runtime

[yan]

Hello,

Is anyone familiar with runtime? I installed a database on a computer with
Microsoft Access. I installed a copy on a computer with a runtime version of
Access; both computers are on a network (Novell). The backend is located on
the network drive. The 2 front-end are on the user's hard drive. The users
can't access the database at the same time. The copy on the runtime is a
read-only database with only a few forms (no reports)... the only use is to
find information. When the main user (with Microsoft access) tried to open
the main form, when it is in use by the other user, he received a debug
windows (... record not updatable).

When the main user is in the database, the 2nd user can't open any of the
forms.

The 2 databases are perfectly working on my own computers (peer-to-peer)
with one of the computer running the runtime version of access.

I verified the locking level in the 3 databases and the user rights on the
network drive.

Any idea how to fix this issue?

Thank you in advance for your time.

Annick Fransen
(e-mail address removed)

 

[Albert D. Kallal]

I verified the locking level in the 3 databases and the user rights on the

network drive.

You need to give the users full permissions to that shared folder. When I
say full permissions, I mean full permissions!

That means users need rights to create files in that folder
That means user needs rights to delete files in that folder.
That means user needs read/write rights to files in that folder.


Since ms-access is not a server based system, then to handle record locking,
it creates temp locking files (in the same folder as where the data file
is...in your case the shared folder). Then, when more then one user opens
the data file, then ms-access has to have some means to communicate the
locking issues between each workstation. Since the network server can't do
this, then each running copy of ms-access has to read, and use that locking
file that was created. So, if users don't have create and delete rights to
the folder where the BE resides, then ms-access has to switch to single user
mode.

So, when I said users need full permissions to that folder, that means that
users need to be able to do ALL types of file operations...including
creating and deleting files.

Also, for reasons of performance, I assume you keep a persistent connection
from the FE to the BE..right?

 

['69 Camaro]

Hi, Annick.

I verified the locking level in the 3 databases and the user rights on the
network drive.

Any idea how to fix this issue?

Make sure that the default open mode is set to shared, default record
locking set to "No locks," give every user of this database "Full Control"
Windows security permissions on the directory where the database file is
located, and if the database uses Jet 4.0, then check the "Open databases
using record-level locking" check box. Also, make sure that opening the
form doesn't dirty the current record, either with VBA code or by form
properties, unless the user is actually editing the record or adding a new
one.

For information on several methods of allowing read-only access to Access
databases in a multiuser environment, please see the following Web page for
a link to the article, "Multiuser Databases":

http://www.Access.QBuilt.com/html/articles.html

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)