Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

ODBC Sybase connection in access keeps requesting password!

Posted on 2010-01-06
1
Medium Priority
?
540 Views
Last Modified: 2013-11-29
Hi,

I have a database tables linked to my access through ODBC.  Everything's working fine, but whenever I close and open my access database, and try to access the linked table, it asks me for the linked database's password to re-connect.  Is there any way around this?  I would prefer to save the password so that access can access the database whenever it opens.

One thing I tried was to add a new string value for the password in the ODBC regedit.  This seems to work when testing connecting in control panel as it doesn't prompt me for the password, but access still does! Any help would be great.  Thanks.
0
Comment
Question by:iamnamja
1 Comment
 
LVL 29

Accepted Solution

by:
leonstryker earned 2000 total points
ID: 26191557
This is how to do it from code: http://www.mvps.org/access/tables/tbl0010.htm

Supposably you can also do this using a .map file containing your connection settings, but I have never done this.

Leon
0

Featured Post

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.

Question has a verified solution.

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

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Exchange database can often fail to mount thereby halting the work of all users connected to it. Finding out why database isn’t mounting is crucial and getting the server back online. Stellar Phoenix Mailbox Exchange Recovery is a champion product t…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

577 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