Microsoft Access error when trying to make reference to linked table

Asked By Juan M Flora 90 points N/A Posted on - 09/19/2013

Hi,

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.

Microsoft Access

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.

• Status: Open
• Question Views: 547
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Tyler Mullings 0 points N/A #188877

Microsoft Access error when trying to make reference to linked table

Resolution 1:

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.

Resolution 2:

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.

Regards,

Tyler

 

About Tyler Mullings

Questions
1

Answers
75

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 09/21/2013
• Question Category: MS Access