Solved

ODBC Save password in Access query

Posted on 2008-10-14
13
2,231 Views
Last Modified: 2010-04-21
How do i get access to save the password for an odbc query

thanks

dave
0
Comment
Question by:david_88
  • 7
  • 6
13 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 22710586
An ODBC query includes a Connect string ... when you build the connection, you're prompted to save the password ... did you choose yes?

Either way, you can directly edit the Connect string - open the query in Design view, click View - Properties and alter the Connect property as needed.
0
 

Author Comment

by:david_88
ID: 22710781
i put the following in the connectstr, it works fine in an cross-through query but not in a normal query.  I can right click and add tables but when they are added they instantly dissappear

ODBC;DSN=net;UID=sys;PWD=sys;DATABASE=sitesys;Network=DBMSSOCN;Address=32.144.138.42,1433
0
 
LVL 84
ID: 22710900
What do you mean by "normal" query?
0
 

Author Comment

by:david_88
ID: 22711012
sorry as in not a pass-through query.   just an new sql query in access 07, do i have to split out the database or something
0
 
LVL 84
ID: 22711042
Are you trying to link local (i.e. Access) tables in the same query as ODBC tables? YOu can't do that, unless you link the ODBC tables to the database.
0
 

Author Comment

by:david_88
ID: 22711065
no they are all from the odbc tables. just want to save the password to them
0
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 
LVL 84
ID: 22711163
You can't use a "normal" query with a connect string ... you'd have to make this into a pass-through as well, or link your ODBC database and then use the linked tables.
0
 

Author Comment

by:david_88
ID: 22711206
i have added them as linked tables but it requires me to enter the password each time
0
 
LVL 84
ID: 22715749
As I said earlier - you can tell Access to save the password in your connect string but apparently you don't want to explore that route ... but if you want to delete this please go ahead ... just one more person to add to my list.
0
 

Author Comment

by:david_88
ID: 22715896
i have been trying to explore that route but i cant get it to work.  

if i leave the connectstring out, then the query runs but needs the password if i put in a connect string it only works as a pass through query but i want to filter based on criteia inputed by the user

ODBC;DSN=net;UID=sys;PWD=sys;DATABASE=sitesys;Network=DBMSSOCN;Address=32.144.138.42,1433
0
 
LVL 84
ID: 22717272
I see you've opened another question for this ... that's not the way EE works, if you need further assistance then use the Request Attention button and ask the mods to put out a call for additional assistance. All the Experts here are volunteers ... we get absolutely nothing out of this except points and a few teeshirts occasionally, and when someone wastes our time like this ... well, memories can be very long.
0
 

Author Comment

by:david_88
ID: 22718786
but i do i appreciate everones help i get on here, but i didn't know that i could request attention and since i was stuck i was trying to get the question back in the pool for people to look at.
0
 

Author Closing Comment

by:david_88
ID: 31505835
This works but can only get it to work using a pass through query.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now