- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Error when accessing IM_90_UDF_ IMMasterfi le through MS Access linked table ODBC
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
08-02-2010 05:37 PM
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.
Solved! Go to Solution.
Re: Error when accessing IM_90_UDF_ IMMasterfi le through MS Access linked table ODBC
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
08-02-2010 06:09 PM
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.


