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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 498
  • Last Modified:

Remove Saved Password for Linked Table

I just used the SQL Server Migration Assistant for Access to upsize my Access database back end to SQL Server.  The password to the linked tables was saved in Access, so that when you open the database, no password is required.  However, I would like a password to be required (a SQL Server user-based password, not an Access database password).  How do I remove the saved password from the database so that it asks for a user and password when the database is opened?

I know I could disconnect and reconnect the tables, opting to not save the password, but that would require me to create a DSN, and I prefer to  have this be DSN-less.

Thanks!
0
Chris
Asked:
Chris
  • 2
1 Solution
 
jmoss111Commented:
Hello Orcadian,

What type of authentication is on the database, trusted, sql or mixed mode?


Regards,

Jim
0
 
ChrisIT ManagerAuthor Commented:
SQL Authentication
0
 
jmoss111Commented:
I'm not 100% sure about this but I think that the password is stored in the registry, not the database, in ODBC.INI
0
 
Gustav BrockCIOCommented:
You will have to delete and recreate the links.

Use DAO code like this:

Set dbs = CurrentDb
Set tblTable = dbs.CreateTableDef(NameForTableInAccess)
tblTable.Connect = YourConnectionString
tblTable.SourceTableName = TableNameAsNamedInBackEnd
dbs.TableDefs.Append tblTable

For connectionstring:

http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForSQLServer

/gustav

0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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