Cant Open Password Protected Paradox table in VB6 
Author Message
 Cant Open Password Protected Paradox table in VB6

I am trying to access a password protected paradox table via VB6 (I
know what the password is).
I have tried the following versions of code but each comes up with the
error:
"Unexpected Error from external database driver"

Attempt1:
CTRLic.Open "Provider=Microsoft.Jet.OLEDB.4.0;data Source=" &
strfolder & ";Password=1111;Extended Properties=Paradox 5.x;Persist
Security Info=True;Jet OLEDB:Engine Type=53;"
Set rst = CTRLic.Execute("select * From [employee.db]")

Attempt2:
Set db = DBEngine(0).OpenDatabase(strfolder, 0, 0, "Paradox
5.x;Password=1111")
Set rs = db.OpenRecordset("employee#DB")

I have the DBE installed (have to to run other progrmas) and he table
with password has no index

I've looked on the HOWTO: Open a Password-Protected Paradox Table
Using DAO (Q217213) and this code (attempt2) does not do the trick

If anyone knows how to connect then it would be much appreciated
Cheers
Mark



Tue, 28 Dec 2004 11:55:11 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Opening Password Protected Database from VB6

2. opening password protected vb/paradox file

3. password, opening database that is password protected

4. Password protected Paradox tables

5. ReportSmith / password protected Paradox table

6. Making Paradox table password protected

7. odbc32.dll and password-protected paradox tables

8. Importing Password Protected Paradox 5.0 Tables Into MS Access 2000

9. Password protected Paradox 3.5 table

10. Password protecting Paradox tables???

11. using a paradox table protected by a password in reportsmith

12. How to create password protected paradox tables


 
Powered by phpBB® Forum Software