How to link A2K tables using UDL or DNS-less (what code and where)
Posted on 2004-03-29
I have an A2K front end database that I want to link to SQL Server 7 backend. I would like to distribute the Access database to multiple users. Each user would open the Access database and have ability to update data through the front end. I have created user ("tester") on SQL database, but would like all Access users to be connected to SQL as "tester" without seeing login screen. This is NOT a web based implementation.
I have seen a UDL file with login and password data that would appear to eliminate the login screen, but don't know how to implement.
; Everything after this line is an OLE DB initstring
Provider=SQLOLEDB.1;Password=password;Persist Security Info=True;User ID=tester;Initial Catalog=Datafile;Data Source=sqlservertest
Is this the correct method, or is there a better way ? I would like NOT to have to include a special file along with the Access database to the user. (but it may be required)
User OS will be Windows2000
If the method involves adding code - where should the code be placed, and how does it get executed ?