+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 Loader to Access. Error running on shared network drive

  1. #1
    Registered User
    Join Date
    11-07-2012
    Location
    NY
    MS-Off Ver
    Excel 2007
    Posts
    46

    Excel 2007 Loader to Access. Error running on shared network drive

    I constructed a loader from Excel 2007 into Access 2007. Working in VBA for Excel, the macros finds the database in the same folder as the Loader. Everything works fine on my desktop, but when I am working from a shared network drive I get an error on line:
    "rst(Cells(1, j).Value) = Cells(lngRow, j).Value" for whichever line is being loaded.

    Please see image below for error message: "Current Recordset does not support updating............."

    I am pretty familiar with VBA in Excel, but I am relatively new to coding for Access. Please help!

    Please Login or Register  to view this content.

    error.JPG
    Last edited by jvbeats; 01-24-2013 at 11:09 AM.

  2. #2
    Registered User
    Join Date
    11-07-2012
    Location
    NY
    MS-Off Ver
    Excel 2007
    Posts
    46

    Re: Excel 2007 Loader to Access. Error running on shared network drive

    This also does not work in any folder on my C drive besides Desktop. Path of target is verified correct.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1