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