I connected from file, get external data, Linked tables, and selected Linked server option in the wizard.
The recordsource for the form is a query w/ 3 tables m to m.
Instead, I am going to return to just using the single table as recordsource and bring in the information to fill the one...
Microsoft Access ADP 2003
linked to SQL server
Problem: When in a form, user trys to create a new record but receives the following error:
"Microsoft Office Access can't find the object 'SELECT (0) as Column1, (0) AS Column2, (0) AS Column3 etc..'
*You misspelled the object name. Checck for...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.