473,320 Members | 2,071 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Ms access sql server connection bypass

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
3 2133
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
2,364 Expert 2GB
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
Krandor
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

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

Similar topics

32
by: Mike MacSween | last post by:
Further to 'Security - more complex than I thought' Has anybody ever seen any studies? Or anecdotal evidence? Done any studies themselves? Done any lab testing - you know - 10 users asked to get...
13
by: Zlatko Matić | last post by:
Is it possible to use Access as front-end for POstgreSQL and how ? What about Access Projects (.adp) and PostgreSQL ?
7
by: Simon Jefferies | last post by:
Hello, I'm trying to create a new ASP. NET Web Application project, when I enter a name and press OK i get the following: Web Access Failed. The default web access mode for this project is...
12
by: RKay | last post by:
I have a Win2k server running SQL Server 2000. On that box I built a working web service that pulls data from the database. One of the services available simply accepts an ado.net connection string...
6
by: jonefer | last post by:
I have two versions of a 'Downtime Application that will run in the event that the mainframe goes down 1) SQL Server ASP.NET app (accessed outside the mainframe network) 2) MS Access Version of...
15
by: Cheryl Langdon | last post by:
Hello everyone, This is my first attempt at getting help in this manner. Please forgive me if this is an inappropriate request. I suddenly find myself in urgent need of instruction on how to...
8
by: Greg Strong | last post by:
Hello All, The short questions are 1 Do you know how to make DSN connection close in Access to Oracle 10g Express Edition? &/or 2 Do you know how to make a DSN-less pass-through query...
0
by: Godzilla | last post by:
Hi all, My problem is when I open a ASP.NET Project in VS.NET 2003, it shows up "A connection with server could not be established". Both new projects and existing project are not working! I...
1
by: hepsi | last post by:
Can u please tell me How to ByPass the Secure Shell Connection from one server to other server...that is from Mysql to postgreSQL Mysql is local ... whereas PostgreSql is client one...remote host...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shćllîpôpď 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.