Solved

ODBC Save password in Access query

Posted on 2008-10-14
13
2,233 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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

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…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

895 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

15 Experts available now in Live!

Get 1:1 Help Now