×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Access Security - how do I gret rid of it - Locked out by Access 2000

Access Security - how do I gret rid of it - Locked out by Access 2000

Access Security - how do I gret rid of it - Locked out by Access 2000

(OP)
I have a number of access97 databases on a network server. I enabled Access Security for one of the databases because it has some sensitive data, but other data that all users need. I have a system.mdw file that I have to have the users (runtime access) join in order to give them access to the secured database.  How can I tell a database NOT to use any security?  This hasnt been a big problem up to now. I could just use a pc on the network that doesnt join the system.mdw file and logon, that pc can access the unsecured databases and import/export data.  Unfortunately, I am experimenting with Access 2000 and when I try to access my unsecured mdw files with 2000, I get an error saying I have to have a security account and it wont let me in, even read only.

thanks for any help

RE: Access Security - how do I gret rid of it - Locked out by Access 2000

In my opinion Access security is more of a hindrance than a help.  In order to bypass security you are going to have to go to the workgroup security wizard.  You can find it at C:\Program Files\Microsoft Office\Office\1033\WRKGADM file. When you click on the file you'll see a wizard that shows the current system.mdw file that you are using.  You then have the option of creating new system.mdw file or joining an existing system.mdw.  I'd suggest you create a new system.mdw with no security and then join it afterwards. Then you should be ok.

RE: Access Security - how do I gret rid of it - Locked out by Access 2000

(OP)
that was about the only thing I could come up with, but i had hoped to avoid having to join and re-join and all that stuff.  I wonder if there's any vb code to automatically join an access user to an mdw file?

thanks

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close