I have a database using Access 2003 as a front end and SQL as a backend. I set up all permissions in SQL and linked all tables to the Access frontend. After putting the front end on the network for other users, they receive the following error: ODBC — connection to <name> failed. (Error 3151) What do I need to do please
You probably need to either set up a DSN on each PC (which can be done via script), or use a "DSN-less" connection within your MDB file. I'm inclined to recommend the DSN on each PC because it gives you more flexibility, although the DSN-less connection gives your app more control of its environment. You need to find the right balance of flexibility and convenience for your own situation.