Solved

ODBC Save password in Access query

Posted on 2008-10-14
13
2,234 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

816 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

9 Experts available now in Live!

Get 1:1 Help Now