Results 1 to 3 of 3
  1. #1
    knightjp is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2008
    Posts
    11

    Setting up User names and passwords

    hey guys,



    I've just finished updating an access database which I uploaded onto a shared folder in a server.
    Since there are going to be other people who will be accessing the database, I need to give them "Read-Only" rights, saving the editing features for myself alone.
    I've tried to do it using the Security Wizard and it gave me a shorcut on my desktop. I copied the shortcut onto another persons PC and it worked. That person had the correct rights and everything. But a problem arose when a person with Office 2007 tried to copy the shortcut and use it. The shortcut seemed to be linked to my PC. Is that true? Since then, I've reverted to the backup and removed all security options altogether.

    How do I create user accounts and passwords for the database while the file is on the shared folder?

    Julz

  2. #2
    islo is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2009
    Posts
    7
    I have been in this kind of situation before. I solved mine by saving the main database in the shared drive. Then I made another copy of this DB. This copy has all the tables linked to the original copy.
    Now all you need to do is distribute the DB with the linked tables to all users.

  3. #3
    knightjp is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2008
    Posts
    11
    I solved the problem.

    I split the database. Then loaded both ends onto a shared folder. Then I ran the security wizard and had the wizard set up a shortcut onto my machine. I copied the shortcut to the shared folder. Then I had all the users copy the shortcut and now all of them can access the DB at the same time.

    Some say that this might cause problems, so far it hasn't.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Setting a field to be dependent on another
    By CushingMT in forum Forms
    Replies: 0
    Last Post: 11-19-2008, 11:51 AM
  2. Setting criteria in a calculated date field
    By SteveReberger in forum Access
    Replies: 0
    Last Post: 10-29-2008, 06:58 AM
  3. Quick way to stuff field names into text field
    By kfinpgh in forum Programming
    Replies: 0
    Last Post: 01-04-2007, 01:13 PM
  4. How to extract names from 1 large field
    By Tepin in forum Access
    Replies: 1
    Last Post: 12-04-2006, 01:14 PM
  5. Setting combo box properties
    By rathfam4 in forum Programming
    Replies: 1
    Last Post: 12-28-2005, 02:27 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums