Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linked Tables not Storing Password

Status
Not open for further replies.

scriggs

IS-IT--Management
Jun 1, 2004
286
GB
I am linking Paradox tables into MS Access and it prompts me for a password on the first tabled linked. But then it doesn't and just uses the password given.

My problem is that when you restart the app, it only stores the password against the one entry and they don't work until I reopen that table first.

How can I get the password stored in each table def?

I though I might be able to edit msysObject as I can see where I want it but it is readonly. For your info, here if msysObject extract:

Connect Database DateCreate DateUpdate Flags ForeignName
Paradox 3.X;PWD=9P6LQ34C2T6P5XE;HDR=NO;IMEX=2; \\hal\e$\WASP\Database\UKTax\Dataset1 06/10/05 16:13:14 06/10/05 16:13:18 7340032 AD05#DB
Paradox 3.X;HDR=NO;IMEX=2; \\hal\e$\WASP\Database\UKTax\Dataset1 06/10/05 16:23:30 06/10/05 16:23:31 7340032 Bt01#DB
Paradox 3.X;HDR=NO;IMEX=2; \\hal\e$\WASP\Database\UKTax\Dataset1 06/10/05 16:23:32 06/10/05 16:23:33 7340032 Ct01#DB
Paradox 3.X;PWD=9P6LQ34C2T6P5XE;HDR=NO;IMEX=2; \\hal\e$\WASP\Database\UKTax\Dataset1 06/10/05 16:25:58 06/10/05 16:25:59 7340032 IB01#DB
Paradox 3.X;HDR=NO;IMEX=2; \\hal\e$\WASP\Database\UKTax\Dataset1 06/10/05 16:23:34 06/10/05 16:23:34 7340032 Ib03#DB
Paradox 3.X;HDR=NO;IMEX=2; \\hal\e$\WASP\Database\UKTax\Dataset1 06/10/05 16:23:35 06/10/05 16:23:36 7340032 Ib04#DB
Paradox 3.X;PWD=1RBRB71LLPBS42H;HDR=NO;IMEX=2; \\hal\e$\WASP\Database\UKTax\Master 06/10/05 16:24:34 06/10/05 16:24:47 7340032 IB21#DB
Paradox 3.X;HDR=NO;IMEX=2; \\hal\e$\WASP\Database\UKTax\Master 06/10/05 16:24:40 06/10/05 16:24:41 7340032 IB27#DB
Paradox 3.X;HDR=NO;IMEX=2; \\hal\e$\WASP\Database\UKTax\Master 06/10/05 16:24:43 06/10/05 16:24:43 7340032 IB36#DB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top