Security, User, Admin in Access

[DummyForAccess]

I am automating some stuff from Access. I am using a module to kick off an Excel spreadsheet that has macros. This works great until I get a message that says the database has been locked by Admin (Uh, I'm the Creator, I'm the one in there, and it shows me locked out of my own db, can you say frustration??) Any advice how I can fix this? Also, I started looking around in the user groups and security stuff, any quick and dirty advice about the security? I don't need to do anything too extravagant, and if I remember correctly I remember hearing co-workers moan about security being a slippery slope in Access....

 

[dannyocean]

Try this answer I gave. It is a simple explination of Access Security.


thread181-240629

 

[DummyForAccess]

Whew, I've never touched security in Access, so much of that was pretty foreign to me. The first question I have is, why, when I open my database and look around in security, does it say current user is Admin? How does it assume that? How do I set it up so that users can log in?

 

[dannyocean]

Unless you have security in place Access cannot tell who is in. So the default is Admin. Once admin is in place it can tell who is in. Also having security fixes any overwrite problems from having multiple users working on the same record at the same time

 

[DummyForAccess]

Thanks for the help. I think it boiled down to one of those "somebody has this open, you can't modify it" things. I solved it by having the (Access) macro move the tables to a temp directory first, then opening Excel and running the (Excel) macro that populates the spreadsheet with data from a MS Query. This is working beautifully, but with one hitch. I have code that I got to paste into a module to open excel and call the (excel) query. Problem is if I use "open Module" cmd in an Access Macro, it just opens the module in a vb development window. I know I'm missing a step or something??? Thanks so much for your help, I'm going to put this as a separate thread in case you're done for the day. Again, thanks...