User Level Security

[Fi64]

I have successfully set up security on a database that is held on a network and access it throught the shortcut that was created at the same time as I set security. However, when I try to get into the original database neither of my admin passwords work.. I have a general admin password set and a database specific admin password set. I also have an personal login.

There is not an issue as all users can access the database but I have obviously misunderstood something when I set the security.

I have looked through the forum for answers and haven't managed to find anything similar. I can access the mdw file and have a copy of the security wizard report.

Thanks for any help in advance.

 

[odin1701]

Since you're on a network, I would really not use the workgroup security stuff...actually I'd never use it.

I would use a table for access lists and VBA to authenticate someone based on username. It's rather involved, but I believe much better.

I've not worked with mdw's so I couldn't tell you if you could pull the proper password out or something.

 

[Fi64]

Thanks for your reply.

At the moment it isn't causing any problems but the potential is there and if I can somehow sort it out I would appreciate any advice. I am not a programmer by any means and have only dabbled a little with VBA.

Having read lots of posts here about the security I realise I should have looked into other methods of securing the database but now it's done I am hoping to somehow access the original database if possible.

Thanks again

 

[Darth Vodka]

can you link into the tables if you build a new database?

is this 97/2000/2003 ?

 

[Fi64]

I just tried to do that - and I can't. I can access all the tables through an admin log-in when using the shortcut that was created when I set the security and I could duplicate it all in a new database but I assume then that the existing security wouldn't work?

Thanks

 

[Darth Vodka]

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

 

[Fi64]

Thanks for the link - much appreciated

 

[Fi64]

Sorry - I meant to say I was working with Access 2003.

 

[Darth Vodka]

if in doubt, recreate the db and redo the security

make a test version and keep an unsecured copy

 

[Fi64]

I have made an unsecured copy by exporting each item in the database to a new one and will now do more research before setting the security.

Many thanks for your help.