debug or Advanced user help

[joseph]

I need your help..........

Problem1 ____Can Access be use by Multiple user?
#5 client uses db1 and #2 client also want's to use db1
but gets an error message because the db1 is in use. Why
can't Access allow #2 to use the db1 in (read-only).

To get around problem1 is to make duplicates in different
locations(Backups). So #5 client can look at db1 and also
#2 can look at db1.(both are read-only)___please tell me
if there is a better way.

Problem2____I linked db1 and db2 in a relationship. I'm
back to problem1 !!!! #2 client gets an error because
#5 client is using the db2. How can I get Access to look
for the db2 relationship in the folder that db1 is in?

IN ACCESS: tools\Database Utilities\Linked table Manager
I can see the location of db2, that means no matter where
db1 is, it will alway look for db2 in one location causing
and error for other clients.
please help..

 

[Douglas J. Steele]

All of your users need to have at least Change access (RWXD) on the folder
where the MDB file exists. This is because the first user to open the
database creates a locking file (.LDB) in that folder, subsequent users
update the locking file, and the last user out deletes the locking file.
Also, make sure no-one is opening the database in Exclusive mode. Rereading
your question, though, it looks as though you want each user to only have
read-only access. You should be able to do that by creating short-cuts for
each user, so that they're opening the database Exclusive and Read-only.
With that combination, no locking file is created. Note that I don't believe
this works if you want some users to have Read-Write access, and others to
have Read-only access.

I'm not quite sure I understand your second problem. The Linked Table
Manager is one way of changing the database(s) to which you're linked. If
you're in the Linked Table Manager, simply relink your tables! Check the
"Always Prompt for New Location" checkbox, select all of the tables, then
click on OK and navigate to the correct location. If you want to be able to
relink through VBA code, take a look at
http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web"

 

[Tim Ferguson]

I need your help..........

Problem1 ____Can Access be use by Multiple user?
Yes

#5 client uses db1 and #2 client also want's to use db1
but gets an error message because the db1 is in use. Why
can't Access allow #2 to use the db1 in (read-only).

Get them to check their default options for opening databases in Exclusive
mode: it should be Shared. If you are going to be sharing a database on a
regular basis, though, you would be well advised to split it into the Front
End/ Rear End model.

Problem2____I linked db1 and db2 in a relationship. I'm
back to problem1 !!!! #2 client gets an error because
#5 client is using the db2. How can I get Access to look
for the db2 relationship in the folder that db1 is in?

If db1 and db2 mean databases, then you did not link them with a
relationship: by definition ref integrity can only operate within one mdb
file.

IN ACCESS: tools\Database Utilities\Linked table Manager
I can see the location of db2, that means no matter where
db1 is, it will alway look for db2 in one location causing
and error for other clients.

I do not understand how this question relates to the other ones, but you
can use the Linked Table manager to change or update the links to linked
tables. It's on the Add-Ins menu.

HTH


Tim F

 

[joseph]

Thank you, Mr. Steele

joseph

 

[Joseph]

Thank you, Tim F.

joseph