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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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
 
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?
 
AlanK said:
Thanks Keith.

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

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?
Click to expand...

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
 
Back
Top