Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Contributor
bryan
Posts: 23
Registered: 08-02-2010
0
Accepted Solution

Error when accessing IM_90_UDF_IMMasterfile through MS Access linked table ODBC

Hello all,


I've added some UDFs to the I/M Masterfile through Custom Office, created a form to access those fields and input some data. However, when I try to open that table in datasheet view via a linked ODBC table through MS Access, I receive an error saying "Query must have at least one destination field." If I attempt to query that table, the table appears to be blank (no fields register).

 

I've input data into these fields, closed MAS, gone back in and found my data to be retained.

 

I've had zero luck searching the internet or these forums but I hope that if anyone can help me, I'll find that person here.

 

I'm using MAS ver 4.0.

 

Thank you.

Contributor
bryan
Posts: 23
Registered: 08-02-2010
0

Re: Error when accessing IM_90_UDF_IMMasterfile through MS Access linked table ODBC

After deleting the linked table that produced the error and relinking it after data was input, I was able to open the table and view records.