I have an Access mdb that contains 10 linked tables to my works SQL server. Each time I start my mdb is brings up the login to SQL dialog box, (user name/ password) so it can access the tables. Could someone kindly advise me if I can use some VBA code to perform an auto login when accessing the link tables, say when I first open the mdb. Please advise thanks
Access linked SQL tables. How can I auto-login with VBA? (1 Viewer)
- Thread starter hardrock
- Start date
