Results 1 to 1 of 1
  1. 03-31-2011, 02:43 PM #1
    MikeDBMan
    MikeDBMan is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Feb 2011
    Location
    Stillwater, Oklahoma
    Posts
    23

    Access Tables Open in Excel

    I have an Access 2010 database and I open several of the tables in an excel spreadsheet. All the tables are set to "read-only" in Excel. If I open a custom form, I always get a warning, "You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later." And indeed I cannot save changes. Does anyone have any suggestions to solve this as it is quite annoying. I can open the "straight" table without problems and modify data but not a form. Suggestions?
    Last edited by MikeDBMan; 04-01-2011 at 06:21 AM.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Open a specific Excel application in Access
    By Hobbes29 in forum Programming
    Replies: 1
    Last Post: 02-14-2011, 06:48 PM
  2. Pivot tables and charts - Access or Excel
    By kkrishna in forum Access
    Replies: 1
    Last Post: 06-06-2010, 04:52 AM
  3. VBA to open excel, import on close of excel
    By bdaniel in forum Programming
    Replies: 0
    Last Post: 03-20-2010, 02:45 PM
  4. Automate Excel Import to Access Related Tables
    By KramerJ in forum Programming
    Replies: 6
    Last Post: 04-04-2009, 04:24 PM
  5. Open Excel from within Access?
    By kjw in forum Access
    Replies: 2
    Last Post: 04-08-2008, 07:12 AM

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
  •  

Forum Rules

Other Forums: Microsoft Office Forums