I got the tables to link, renamed the links, and was able to get some of the forms working.
Should I use views? All my queries are done in Access - some are created queries, some are done with SQL in VBA.
Sometimes I get an ODBC call failed error - not sure why - I am using a file DSN.
Sometimes my search queries (VBA/SQL) don’t work right - should I convert the VBA SQL to a different standard?
For example, a text box that searches multiple fields as you type - calls a module function, passes the form object byref, so the text box text can be used in the SQL query.
Should I be using stored procedures, triggers?
I would also like to keep track of who logs in, and store datetime, username, ip address - is there an easy/built in way to do this?
Thanks for your help.