I have 88 MDBs which CAN access SQL Server 2005 data, using ODBC data sources for the tables. This works when the network userid is a network Administrator. However, when others log on to the network as non-adminitrators (as themselves) I get an error from SQL server about not being able to connect.
I'd like to use 'trusted_connection =yes", but can't figure out how to "open" a connection with these DAO mdbs. Do I have to use ADO? Can I use both? Must I rewrite all 88 programs?
If there is a DAO connection string, are there examples available?