Network problem

[Tomas]

Hi all,
I hope someone can help me with a following problem: I
created a back end db located at a shared disc in our
company network, users connect to the database using their
front end db client, each user has read/write access to
the shared disc and everything works fine. But when users
who only have read access to the shared network disc try
to connect to the back end db via their front end db
client (especially designed to perform read operations
only) with users with read/write access connected, they
get Microsoft Jet error 3045, if other users disconnect
then everything works fine for the users with read only
access. Any idea what causes this problem? What should I
do to fix it?

Thank you in advance

Tomas

 

[Tony Toews]

I hope someone can help me with a following problem: I
created a back end db located at a shared disc in our
company network, users connect to the database using their
front end db client, each user has read/write access to
the shared disc and everything works fine. But when users
who only have read access to the shared network disc try
to connect to the back end db via their front end db
client (especially designed to perform read operations
only) with users with read/write access connected, they
get Microsoft Jet error 3045, if other users disconnect
then everything works fine for the users with read only
access. Any idea what causes this problem? What should I
do to fix it?

Trouble is you gotta give those users read/write permissions to the
folder.

Although you could try the /ro startup command line option on a
shortcut. But the important thing when setting up any command line
arguments is that you must add the msaccess.exe path and file name to
the command line as well.

For example "C:\Program Files\Microsoft Office 97\Office\msaccess.exe"
Including the double quotes if you have any spaces in the path name
which is very likely. Thus you'll end up with something like

"C:\Program Files\Microsoft Office 97\Office\msaccess.exe"
/ro "C:\Directory\FE.mdb"

On three lines for readabililty but will really be one line in your
shortcut or Citrix command.

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