Results 1 to 2 of 2
  1. #1
    Wrangler is offline Wrangler
    Windows 7 Access 2007
    Join Date
    Dec 2005
    Location
    Alabama
    Posts
    17

    Can not open File already in use.

    I have a database that is used for invoicing, recently I split the DB so it would run quicker and multiple users could work at the same time. Now I have the tables located my shared folderand everyone is linked to them. Each of use has the mdb file on our machine.



    I can use the file just fine but when the other people try to use it, it only opens as a read only file. Everyone has read/write premissions to my shared folder and the db is set for multiple users. I am at a loss to what could be causing this.

    The other item is now when the other user trys to open a new invoice the form opens completely blank with on fields just all gray; I think this is due to the read only status.

    Can some one please give me some ideas to what could be causing this. :cry:

  2. #2
    thhui is offline Competent Performer
    Windows XP Access 2002 (version 10.0)
    Join Date
    Feb 2009
    Posts
    235
    You should check:

    Tools
    Options
    Advanced
    Default Open Mode?

    It should be set to Shared and Record Level locks checked as well.

    Remember to close the database file and open it in the file menu instead
    to activate the changes you already make.

    This may help too.
    http://office.microsoft.com/en-us/ac...CH062526671033

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

Similar Threads

  1. Upload file inside .mdb database file
    By havish in forum Access
    Replies: 0
    Last Post: 07-30-2008, 07:35 AM
  2. Possible to export *.mdb file to *.exe file?
    By slpuiwan in forum Import/Export Data
    Replies: 1
    Last Post: 12-16-2007, 06:52 PM
  3. How do you export a file with a unique file name
    By Budman42 in forum Import/Export Data
    Replies: 1
    Last Post: 10-15-2006, 06:10 PM
  4. Replies: 3
    Last Post: 02-02-2006, 07:39 PM
  5. 'On Open' Property
    By emilylu3 in forum Forms
    Replies: 1
    Last Post: 12-08-2005, 02:28 PM

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