How do I get a user log in prompt when I log into my Access databa

A

AlanK

How do I get a user log in prompt when I log into my Access database?

I have an Access database on my company network.
Two of us are using the database however we are encountering problems when
two of us are working on the same table (via a query or form).
I think this may be due to the fact that the both of us are Administrators.

How can I get the Database to prompt for a password? I've set up User and
group accounts via the tool menu however I'm still not beings asked for login
details when I open the database.
I would appreciate any guidance.
 
K

Keith Wilby

AlanK said:
I have an Access database on my company network.
Two of us are using the database however we are encountering problems when
two of us are working on the same table (via a query or form).
I think this may be due to the fact that the both of us are
Administrators.

Setting up user level security will do nothing to solve this problem, you
need to split your database. More info here:

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

Keith.
www.keithwilby.com
 
A

AlanK

Thanks Keith.

I've split databases in the past and have always encountered problems.

For now I would like just to get a prompt for each user when they attempt to
log in to my database (User name & Password). Any ideas?
 
K

Keith Wilby

AlanK said:
Thanks Keith.

I've split databases in the past and have always encountered problems.

If that's the case then you need to look at your design and maybe check
(assuming you're using A2003) that things like Name AutoCorrect are switched
off. More info here:

http://allenbrowne.com/bug-03.html
For now I would like just to get a prompt for each user when they attempt
to
log in to my database (User name & Password). Any ideas?

If you really want to tread this path then be ready for a long haul because
user-level security has a steep learning curve and can be frustrating to
learn and implement properly. Your first port of call should be the FAQ
(link on my web site) - for a flavour of what's involved you could take a
look at my set-by-set guide (also on my web site).

Regards,
Keith.
www.keithwilby.com
 

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

Top