• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2267
  • Last Modified:

ODBC Save password in Access query

How do i get access to save the password for an odbc query

thanks

dave
0
david_88
Asked:
david_88
  • 7
  • 6
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
david_88Author Commented:
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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
What do you mean by "normal" query?
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
david_88Author Commented:
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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
david_88Author Commented:
no they are all from the odbc tables. just want to save the password to them
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
david_88Author Commented:
i have added them as linked tables but it requires me to enter the password each time
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
david_88Author Commented:
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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
david_88Author Commented:
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
 
david_88Author Commented:
This works but can only get it to work using a pass through query.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now