Access Security

I have converted my Access 2007 back end to a SQLServer and am trying to return the current user back to the application.  Unfortunately if I use the built in function CurrentUser is only returns Admin which is from Access and ...

hi, I have my database i want to share to some of my colleagues for updating. i dont want to convert it to MDE because it is not finalize yet but is usable now. i want to share my database  to some of this users and i want to create ...

I am trying to install an accda add-in file. I get an error that i do not have sufficient permissions to install. The security tab of the file says I have complete control. How do I get sufficient permissions? This is on an ...

If a coworker opens our database (on a network) exclusively on her machine, I can still get in.  Why is that?  If a different coworker opens the database exclusively on her machine, I can not get in. What is the difference between the set-ups?  I don't want anyone to be able ...

I am in the processing of building a database and I needed to assign permissions.  I have never used permissions before, so I created a backup in case something went wrong.  Unfortunately, something has gone wrong.  I have ...

I and the other IT person has admin rights to all databases.  When we open one of the databases we have to click ok on the exclusive lock warning dialog about 30 times before we can open.  We are not trying to open in design view ...

Is it possible to secure database access at the switchboard level. Meaning that the different or multiple options on the main switchboard can be accessed only after being prompted and supplying a specific password? For example on my main swithboard I have created the option buttons of: ...

In an effort to solve a different problem, I created a skinned-down version of an existing database that will just run a couple of queries & reports from the data on the first database using linked tables and queries. ...

I want an expert's advice to take data backup through VBA code in one of ny forms. Please help. ...