I have the ODBC connection set up and created all the relationships for the tables I need, but when I try to build the report I get the error below.
"The wizard is unable to open your query in Datasheet view, possibly because another user has a source table open in exclusive mode. Your query will be opened in design view"
Subsequent attempts to run the report generate this error:
"Cannot join on Memo, OLE, or Hyperlink object ([Computers].[ComputerID]=[Displays].[ComputerID])"
If I make the tables local and convert the data type for the fields to Text everything works fine. It only seems to be when fields have Memo data types that I get the error. I am still of a novice when it comes to Access so hopefully someone can point out my oversight of the obvious.
EDIT: It wouldn't let me post in-line image of the errors.
Please sign in to leave a comment.