Microsoft Access error when trying to make reference to linked table

Asked By 90 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #188877

Microsoft Access error when trying to make reference to linked table

qa-featured

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

 

Related Questions