Multi user passwords oppening a secured database


M

mark

Hi,

I have used the security wizard to create users and group
accounts. A short cut has come up on my desktop and
everythings works fine. I can input all the login name and
passwords.

My secured database is on a shared drive that can be used
by everyone in my department. As the shortcut is not on
the other users desktop they cannot open the database. If
they click on the file in the shared drive the usual
message of you do not have permission etc. No login box
appears to enable them to enter their logon name and
password.

How can I get the other users to open the database, either
by giving them a shortcut or by them openning the file?

Thanks
 
Ad

Advertisements

A

Albert D. Kallal

Hum, the only way to solve this problem is to distribute a short cut to each
user.

As a side note, each user should in fact have a front end (and it should be
a mde) of the program, or application side.

The so called back end with the data should reside on the server.

however, you STILL need to put the workgroup file that your shortcut uses on
the server along with the back end data file.

Your start-up shortcut that each user has will run the local mde file (with
the program code) on EACH workstation, but the path name used for the
security workgroup file will point to the server. (as will all linked
tables).

For info on this, check out:

http://www.granite.ab.ca/access/splitapp.htm

http://www.microsoft.com/accessdev/articles/bapp97/chapters/ba15_3.htm

I want to stress that a split database is NOT the solution to your
problem...but is only the recommend way to run ms-access in multi-user
situation. However, the solution to your problem is a shortcut for each
user....
 
T

TC

The general answer to your question is, to give each user a shortcut with
the following target:

all on one line:

"path to MSACCESS.EXE"
"path to MDB"
/wrkgrp "path to MDW"

Then, the path for each file, gives the location of that file.

HTH,
TC
 
Ad

Advertisements

P

Pieter

To solve this put a password on the 'basic' user Admin.
Basicly Access starts with the user being Admin.
Now every user wil be prompted for a password.

It can also be possible that you mus allow the basic Admin to start the database, but remove all the
rest of the security settings on forms, querys etc.

Because you secured the database, this Admin should not be a part of the Admins group.

Hi,

I have used the security wizard to create users and group
accounts. A short cut has come up on my desktop and
everythings works fine. I can input all the login name and
passwords.

My secured database is on a shared drive that can be used
by everyone in my department. As the shortcut is not on
the other users desktop they cannot open the database. If
they click on the file in the shared drive the usual
message of you do not have permission etc. No login box
appears to enable them to enter their logon name and
password.

How can I get the other users to open the database, either
by giving them a shortcut or by them openning the file?

Thanks
Microsoft never, repeat NEVER, sends updates, fixes, patches, etc., as
attachments to emails.

Free Server Software:
www.MySql.com

Newsgroups: mailing.database.mysql

Pieter (NL).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top