By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,082 Members | 2,135 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,082 IT Pros & Developers. It's quick & easy.

Ms access sql server connection bypass

P: 3
I want to run a routine update of a few tables via sql. Every time I run the saved import, it asks me to verify sql server login with either a trusted connection or user id and password. The db I am trying to access has no password, so essentially I just click enter every time. Is there some way I can bypass this screen, or possibly write code to press the ok button when running the import?
Aug 12 '08 #1
Share this Question
Share on Google+
3 Replies


P: 3
I want to run a routine update of a few tables via sql. Every time I run the saved import, it asks me to verify sql server login with either a trusted connection or user id and password. The db I am trying to access has no password, so essentially I just click enter every time. Is there some way I can bypass this screen, or possibly write code to press the ok button when running the import?
http://www.connectionstrings.com/default.aspx?carrier=sqlserver

Per a recent post, I've found this internet site may help, but i need a boost on how to get this information into vba sintax.
Driver={SQL Server};Server=myServerAddress;Database=myDataBase ;Uid=myUsername;Pwd=myPassword;
Aug 12 '08 #2

Dököll
Expert 100+
P: 2,364
http://www.connectionstrings.com/default.aspx?carrier=sqlserver

Per a recent post, I've found this internet site may help, but i need a boost on how to get this information into vba sintax.
Driver={SQL Server};Server=myServerAddress;Database=myDataBase ;Uid=myUsername;Pwd=myPassword;
Hello popoyan78!

I think you'll find whether through VB or VBA, it is pretty much the same thing. If it's working in VB, you;re straight, don't quote me on that though, not sure of the scope of you project, hee hee:-)

But I am going to add it to the Access forum anyway, you can more questions there if you like.

Also, thanks for letting us know you found an answer, it's nice.

In a bit!
Aug 13 '08 #3

P: 50
Post the code that you are currently using to connect to the database. That way I can show you how to get the connection string into the code.

Very likely, once you have a proper conenction string set up, your login problems will go away.
Aug 13 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.