Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

ODBC Password

 
   Windows Help (Home) -> Microsoft Access RSS
Next:  Remote Desktop Connection  
Author Message
Gerry

External


Since: Jan 26, 2009
Posts: 2



(Msg. 1) Posted: Thu Mar 26, 2009 7:25 pm
Post subject: ODBC Password
Archived from groups: microsoft>public>access (more info?)

I have an application that accesses an ODBC database. The database is
readonly and the application works great. I want to enable the application to
run on it's own but I have to be there to enter the password each time.
I am prompted for a company code, user id and password.
How can I work around this?

Gerry

 >> Stay informed about: ODBC Password 
Back to top
Login to vote
Albert D. Kallal

External


Since: Dec 4, 2008
Posts: 22



(Msg. 2) Posted: Thu Mar 26, 2009 8:53 pm
Post subject: Re: ODBC Password
Archived from groups: per prev. post (more info?)

Delete that linked table, and re-create it.

When you're re-linking the table make sure you check the box to remember the
person's password that occurs during that process. If you check that box,
then you not need to enter a password.

 >> Stay informed about: ODBC Password 
Back to top
Login to vote
Tom Wickerath

External


Since: Nov 26, 2008
Posts: 30



(Msg. 3) Posted: Thu Mar 26, 2009 10:40 pm
Post subject: Re: ODBC Password
Archived from groups: per prev. post (more info?)

Albert,

Your advice *may* be okay if the connection requires only a generic readonly
account, but even that may be questionable. If the credentials required are
those of a particular individual, then checking the option to remember the
password is likely to attract unwanted attention from the company's security
department. Checking the option to remember a password could easily be an
offense that would send a person home for several days without pay at my
place of work.


Tom Wickerath
Microsoft Access MVP
[URL="http://www.accessmvp.com/TWickerath/"]http://www.accessmvp.com/TWickerath/[/URL]
__________________________________________

"Albert D. Kallal" wrote:

> Delete that linked table, and re-create it.
>
> When you're re-linking the table make sure you check the box to remember the
> person's password that occurs during that process. If you check that box,
> then you not need to enter a password.
>
>
> --
> Albert D. Kallal (Access MVP)
> Edmonton, Alberta Canada
> pleaseNOOSpamKallal.cut.RemoveThis@msn.com
 >> Stay informed about: ODBC Password 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
turn off password - Access 2003 When I try to access the Back end of my database it prompts for a password. I no longer need this security. How can I turn it off?

Password security for all Access files - I have some users who also use Access apps developed by a former employee. This developer used Access security options so that every user of his application has to enter a password to start his application. However, this accounts for every Access file...

Password prompt on Exit of database - I have a password protected database that is set to Compact & Repair on Close, and when we upgraded from Access 2003 to Access 2007 it started asking for a password when we close. It will not take the password for the database, but if you choose....

Access 2007 "compact and repair" asking password - Hi all, I have a database in Access 2007 format, with a password. Usually after I open and modify the database, I do "compact and repair" to reduce database size without any problem. But last time when I did compacting, database asked me fo...

Microsoft Office - Can you update Microsoft office version 2003 to 2007 or do you have to buy the newer version
   Windows Help (Home) -> Microsoft Access All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]