Results 1 to 2 of 2
  1. #1
    djb1011 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2013
    Posts
    1

    Wrong path

    Hello,
    I have a database that runs a query to import items from a spreadsheet. The database was recently moved to the server drive instead of the desktop. When I run the query from the switchboard or in design view I get the following error
    Click image for larger version. 

Name:	access error message.gif 
Views:	10 
Size:	13.4 KB 
ID:	11214 which is a 3044 error. i know this means that the path is wrong but I don't know where to change the path. It is querying off a table.

    Any help would be appreciated.
    Thank you
    D

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,622
    If this is importing from Excel then it is not querying off a table. This is possibly an INSERT sql action that pulls records from linked spreadsheet. If this is a linked spreadsheet, then the link path is probably no longer valid since the db was moved.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 3
    Last Post: 11-24-2012, 08:56 AM
  2. Path change
    By dref in forum Access
    Replies: 5
    Last Post: 09-03-2012, 08:41 AM
  3. DLookup on the right path?
    By GenericHbomb in forum Programming
    Replies: 2
    Last Post: 07-14-2011, 08:10 AM
  4. back end path
    By Mclaren in forum Programming
    Replies: 1
    Last Post: 06-08-2011, 01:13 PM
  5. not a valid path
    By JJJ in forum Access
    Replies: 0
    Last Post: 03-28-2011, 10:50 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
  •  
Other Forums: Microsoft Office Forums