Microsoft Office Access can’t find the object

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

Hello guys,

Please read my post here that is about my problem working with Microsoft Office Access. The full screen shot of the error is pasted below for you to analyze.

 

Microsoft Office Access can’t find the object “SELECT”, sql_ variant _property(value, ‘base type’) AS type FROM ::fn_Ilstextendproperty(N’MS_DisplayViewsOnesharePoinSite’,N’THP_Consltant’,NULL,NULL)’,

* You misspelled the object name. Check for missing underscores ( _ ) or other punctuation, and make sure you didn’t enter leading spaces.
* You tried to open a linked table, but the file containing the table isn’t on the path you specified. Use the Linked Table manager to update the link point and point the correct path.

As I am not yet an expert in using Microsoft Office Access, that is why I am having a hard time in analyzing this error message. I ask some help from my colleagues, but they cannot  help me with this problem, since they haven't tried this error message. Please help me find ways to solve this problem.

All your comments will be greatly appreciated. Thanks a lot for reading my post.

SHARE
Answered By 0 points N/A #97903

Microsoft Office Access can’t find the object

qa-featured

Hello Jean Great,

Microsoft Office Access can’t find the object “SELECT”, sql_ variant _property(value, ‘base type’) AS type FROM ::fn_Ilstextendproperty(N’MS_DisplayViewsOnesharePoinSite’,N’THP_Consltant’,NULL,NULL)’,

  • You misspelled the object name. Check for missing underscores ( _ ) or other punctuation, and make sure you didn’t enter leading spaces.
  • You tried to open a linked table, but the file containing the table isn’t on the path you specified. Use the Linked Table manager to update the link point and point the correct path.

This is your original text posted here at TechyV.com.

I have no direct answer to this question because I find it really hard to answer which I am not sure if it will work or not. The  questions which triggered my mind when I read this post are:

  • First, how did you add the field in that form? Is it by dragging them and or manually creating a field in the form listed?
  • Second, I can’t even think what my next question to this because I have no background and idea on how you create your software and its format.

I will post some helpful links in here that might give you idea what error message means if this apply to the program you’re creating.

Here is the link.

In your next post, give me additional information about this error.

Related Questions