Solved

ODBC Save password in Access query

Posted on 2008-10-14
13
2,244 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
13 Comments
 
LVL 85

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 85
ID: 22710900
What do you mean by "normal" query?
0
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 

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 85
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
 
LVL 85
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 85
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 85
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

717 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