开发者

Java MS Access Database Connection without Admin rights

开发者 https://www.devze.com 2022-12-13 09:36 出处:网络
For a JAVA project I am workin开发者_如何学编程g on there is a requirement that I use a Microsoft Access Database running on a computer where I do not have administrative priveleges.

For a JAVA project I am workin开发者_如何学编程g on there is a requirement that I use a Microsoft Access Database running on a computer where I do not have administrative priveleges.

So, I have the Access DB file all ready, and I started doing some research - but everywhere I look mentions the need to use the Admin Tools (or Control Panel) to "setup an ODBC connection", sadly it looks like I don't have access to any of these OS level configurations.

Is there any alternative I could use to access the database without the need to start configuring the Operating System (running Windows XP).

Any help would be appreciated. Thanks,


Jackcess is a pure Java library for reading from and writing to MS Access databases.


The connction URL may contain the full ODBC information:

Connection con = DriverManager.getConnection(
     "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=c:/bd1.mdb"
      );

No access to the control panel is necessary.

0

精彩评论

暂无评论...
验证码 换一张
取 消