UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Run Time Error 3011 - Could Not Find Object, Access 2010    
 
   
slc1axj
post Feb 16 2017, 10:19 AM
Post#1



Posts: 363
Joined: 3-October 06
From: Gulf Shores, AL


I have to update my back-end on a daily basis. I have someone that backs me up and I'll need her to run the backup too.

I have some codes that imports a spreadsheet from an Excel file as follows:
---------------------------------------------------------------------------------------

Public Function importdata()


DoCmd.DeleteObject acTable, "T_ImportTrainingDetails"
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "T_ImportTrainingDetails", "\\docshare.nfcu.net\org\dc\cc\TOCC\CCOWM\Shared Documents\Training, Shifts, and Billet Information\Current Month - Training Plan Summary.xlsm", True, "Training Details!"

End Function
------------------------------------------------------------------------------------------

This code works fine for me - never any issues.
However, when my backup runs the same code, she intermittently has the attached error: Run-time error '3011' - The Microsoft Access database engine c ould not find the object '\\docshare.nfcu.net\org\cd\cc\TOCC\CCOWM\Shared Documents\Training, Shifts, and Billet Information\Current Month - Training Plan Summary.xlsm'. Make sure the object exists and that you spell its name and the path name correctly.

I can't figure out why I never have this error when I update it and why she only seems to have the error intermittently (about every other time she tries to update it)




Attached File(s)
Attached File  IMAGE_2CAD207A39A96B09.jpg ( 24.98K )Number of downloads: 0
 
Go to the top of the page
 
GroverParkGeorge
post Feb 16 2017, 10:36 AM
Post#2


UA Admin
Posts: 29,445
Joined: 20-June 02
From: Newcastle, WA


It sounds like a network problem. Are you both in the same location, on the same LAN?

--------------------
Go to the top of the page
 
gemmathehusky
post Feb 16 2017, 10:38 AM
Post#3


UtterAccess VIP
Posts: 4,401
Joined: 5-June 07
From: UK


maybe another user has the spreadsheet open.
maybe the file does not exist.


as long as you error-trap the process, the user should be able to recover, and resolve the issue.

--------------------
Dave (Male)

(Gemma was my dog)
Go to the top of the page
 
slc1axj
post Feb 16 2017, 10:40 AM
Post#4



Posts: 363
Joined: 3-October 06
From: Gulf Shores, AL


We are not in the same location; however, it works sometimes for her which is confusing me. - No one else has the file open at the time of updating.
Go to the top of the page
 
GroverParkGeorge
post Feb 16 2017, 10:46 AM
Post#5


UA Admin
Posts: 29,445
Joined: 20-June 02
From: Newcastle, WA


"...We are not in the same location..." "...it works sometimes ..."

That confirms my suspicion that this is network related. Ask the backup if she ever has problems connecting from her location to other folders and files.

Access seems to be particularly sensitive to network interruptions.

--------------------
Go to the top of the page
 
slc1axj
post Feb 16 2017, 10:47 AM
Post#6



Posts: 363
Joined: 3-October 06
From: Gulf Shores, AL


She has not had problems connecting to other folders/files. Sounds like she may have to manually import this specific file instead of having Access code bring it in for her?
This post has been edited by slc1axj: Feb 16 2017, 10:50 AM
Go to the top of the page
 
gemmathehusky
post Feb 16 2017, 06:12 PM
Post#7


UtterAccess VIP
Posts: 4,401
Joined: 5-June 07
From: UK


she could copy it from the network location to a local disc, and then import it. That would avoid access network errors.

--------------------
Dave (Male)

(Gemma was my dog)
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    23rd May 2017 - 09:12 PM