hi I'm using access as database.when we use SQL as database we write import java.sql.*; but when we use access what are the library functions which we have to import?Can anyone provide me with the code to access Access database.
posted 16 years ago
The code is the same, you just may need another driver. Like the JDBC/ODBC bridge driver. Hope this helps.
I'm assuming you're running on a windows machine, first you have to set up your access file to use the odbc drivers (cos access is a file, not an RDBMS) Go to the control panel, odbc data sources, user dsn tab, add, select *.mdb, finish. Give the file a name, in the database section browse and select your database. Once you've done this you should be able to go...