Results 1 to 4 of 4
  1. #1
    rubenidas is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2016
    Location
    Texas
    Posts
    2

    Post Access opens up as Read-Only

    Hi, I created a simple database to manage contacts. I then wanted it to display in excel, so i used the option in excel to "Get External Data" and selected "From Access". I pointed it to my database and pulled the data from a query i have.



    The problem now is that the excel file is the master data, not access. If i have the excel file and then open access, my database only opens as read only. I found out i have to close excel , then open access to allow access to be able to edit the data, but i do not want it to work like this. I want access to always be the master data handler and excel to only view the data, never actually be able to edit it from there.

    How can i accomplish this?

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Then enter data in access and export to excel.

  3. #3
    rubenidas is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2016
    Location
    Texas
    Posts
    2
    Quote Originally Posted by ranman256 View Post
    Then enter data in access and export to excel.
    But if I update access, it won't update excel automatically will it? That's what i want. I want for one person to manage it in access, and every excel file that has this query linked in it from access to be updated whenever a change is made to the database.

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    It is not something I do or even recommend, but you should be able to connect to Access from Excel. In other words, you might want to try and connect to access from multiple workbook files. However, I am not sure how locking of records will be managed by Excel. You may discover issues editing records in you Access table(s).

    Why not just have the users view information via Access or, as recommended, export to Excel when new information is available.

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

Similar Threads

  1. Replies: 1
    Last Post: 07-14-2015, 02:42 AM
  2. Replies: 11
    Last Post: 10-15-2014, 12:28 PM
  3. DB opens as READ ONLY
    By khughes46 in forum Access
    Replies: 6
    Last Post: 10-14-2014, 02:26 PM
  4. Opens as Read Only
    By bouschie in forum Access
    Replies: 2
    Last Post: 12-05-2011, 01:08 PM
  5. Replies: 2
    Last Post: 10-19-2006, 04:37 PM

Tags for this Thread

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