General Network Question

[Lisa]

Hello,

I have a database and I split it into a
frontend/backend. Id like the backend on the network,
and the users to have access to edit information via
forms (in the frontend). Any tips on this type of setup,
recently it will say when i open the front end that the
back end is already in use by another person. How can i
get it so multiusers are on at the same time and able to
edit data etc. Thanks

Lisa

 

[Cameron Sutherland]

By default Access is a multiuser product. It only locks
the individual records in a table not the whole mdb file.
if you get a message that someone else has the file locked
then it most likely is a network permissions problem. Each
user that opens the data file must have Change permissions
to the folder it is in. They must be able to add and
delete files otherwise the temporary .ldb file cannot
correctly be created or delted locking every one else out.

-Cameron Sutherland

 

[LIsa]

Is this true even if there are no edits allowed? and just
viewing and searching of the db, thanks.

Lisa

 

[Tony Toews]

I have a database and I split it into a
frontend/backend. Id like the backend on the network,
and the users to have access to edit information via
forms (in the frontend). Any tips on this type of setup,

Visit my website and follow the performance link if required.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Cameron]

Sorry for the delay with the response.
If you want to set permissions for some to edit data and other full
you still have to have everyone with capability to create and delete
the .ldb file or locking occurs but you can set file permissions on
the main mdb file to only allow certain user/groups to have read-only.
The down side is they get an annoying message when hey open the file
that says it is only read-only. This may be a good thing if you want
to let them knowbut if they are using it a lot it gets annoying to see
it everytime.

 

[Cameron]

Yup. If they can't create and delete the .ldb file it locks it for everyone else.
-Cameron Sutherland