Code to enter Jet Security?

[Karl K]

How to log in from an outside application (such as Java) to enter a Jet Secured database? It tells us we don't have permission, even though we are (trying) to provide it with userID and password. Any idea how to do this?
In desperation, I just exported the tables to a new unsecured database to export to Oracle to export to the Website. But we need to fix this soon.

Thanks for any suggestions, or even where to look for such info.

 

[bobjames]

I'm no Java Expert but in VB you would
need to make sure pointing to the correct WorkGroup File which I assume copied with your database to your web server. See Below:


With DBEngine
.SystemDB = txtMDAFile
.DefaultPassword = txtpswd
.DefaultUser = txtID
End With