N/APosted on - 09/19/2013
The following error occurred when I try to open or make a reference to a linked table in Access. Now I am looking for an expert’s suggestion so that I may resolve this issue ASAP. Please provide a solution to fix it ASAP. Thanks in advance.
The Microsoft Jet database could not find the object ‘dbo.????’. Make sure the object exists and that you spell its name and the path name correctly.
Microsoft Access error when trying to make reference to linked table
You will need to check to make sure that the table or query exists. In case it does not not exist, you will need to remove all references to it, or reimport or relink the table or query. The RecordSource property of a form or a report usually has a reference to a table or a query whose name has changed or which has been deleted.
It seems like you are doing a DoCmd.TransferText, so MS Access is expecting that the object 'dbo' exists in that location. You will need to try creating the object first, and then do a transfer of the text.