1) First get a new MS ACCESS database
2) make the database password protected by using the Tools/Security/User-Level Security Wizard.
By doing this a file secured.mdw for example is created
3) Create a User Data Source which points to the mdb file and choose the system database option and select the mdw file there. Enter no user and password in the user data source definition (under advanced options)
4) Connect to the database via JDBCODBC Bridge as usual and enter user and password during getConnection
The important hint for this doing was found at
dBforums - JDBC Microsoft Access
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment