Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Drop Connection to SQL Server
The post by vickvickvi was helpful and does work. But What I would like to know is how do I send the connect string to a SQL Server when the tables are already linked in the front-end. This method would require that I connect and delete every table when the user uses the system but if I have...- BayouTech
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Moving frrom Access 2000 to SQL Server 2000
I have an Access 97 database that I upsized the back-end to SQL 7.0 What I need to know now is once I make the links to the back-end, how do I program in Access VBA to connect to the back-end so the username and password gets sent to SQL without user input every time a user opens the front-end...- BayouTech
- Post #9
- Forum: Microsoft: Access Queries and JET SQL
