Logon box does not appear!!

[Jack_Maloney]

Hi,

I have an access database which i've converted to a 2003 version so that I can use Access User names and permissions. I have setup a number of logons with various levels of permissions and am now ready to release the database to the users.

The login works fine on my local machine. However, I have placed the database on our network to allow other users to use the database and it automatically logs the users in without displaying the username and password login box!! Obviously this is not acceptable as it logs all users in as the 'admin' user.

I have set a password for the admin user so not sure why the box does not appear. Is there something else I need to do? Like do I have to set up a file on each users local machine?

Any help on this is much appreciated!!

Thanks,
Jack

 

[Galaxiom]

Each machine should have a separate copy of the Front End.

 

[Jack_Maloney]

Ok, so how do you go about actually doing this?

 

[DCrake]

Have you written a custom security login screen or is it part of the Access Security module/workgroup?

 

[Jack_Maloney]

Hi David,

It is part of the Access security workgroup. It works fine on my PC just not on other users!!

Thanks,

 

[boblarson]

You haven't secured it properly. You didn't do at least one important thing. You didn't remove the admin user from the admins group. However BEFORE YOU DO, you need to ADD a user to the admins group (probably yourself and at least one other person) so that you don't lock yourself out completely. If you haven't removed the admin user from the admins group then anyone with a normal system.mdw file is allowed in because they are admins. And, you don't join the workgroup, you start Access from a SHORTCUT which includes the mdw file (which you should put on the server with the database backend, so that each user has access to it).

Read the Microsoft Access Security FAQ for more info.

 

[Jack_Maloney]

Hi,

I did actually remove the admin user from the admins group so that cant be the problem.

Please could you explain how I setup a shortcut with the MDW file? And how do I split the backend from the front?

Do I need to place the workgroup file on the network?
Thank,

 

[boblarson]

Hi,

I did actually remove the admin user from the admins group so that cant be the problem.

If other users can get in then you did not secure it properly. If you do, anyone trying to open it should get a log in prompt and not be able to get in without a username and password.

Please could you explain how I setup a shortcut with the MDW file?

Read the FAQ that I posted the link to.

And how do I split the backend from the front?

Read this:
http://members.shaw.ca/AlbertKallal/Articles/split/index.htm

Do I need to place the workgroup file on the network?

Yes, you do. And you need to provide a shortcut for users. I like to use the free Headway Shortcut Builder to do it because it makes it extremely easy to do.