about odbc connection

[Jhedzkie Skies]

hi there.. i'm quite new to database programming with java.. and i wonder... about this connection code...

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

i see here the part DBQ=c:/SalesInventory.mdb

what if i am to redistribute my software package? it will probably change place...
and for example, i would put the .mdb file within the resources of my .jar application, how can i access it?
i mean, how can i access the resources of my app through code? i already tried the getClass().getResource() its no error but it cant get the database. please help..
all i want to know is how to access the database on the resources... like in VB of the code

  Data Source= " & (App.Path & "/SalesInventory.mdb")  

thanks. :)

[Leonardo Carreira]

Hi..

As far as i know, the only way to connect the access database is through ODBC..
the code is shown as you've already mentioned...
Java is really different with VB, you should configure URL database correctly..

Thanks..

[Jhedzkie Skies]

so it wont work..

it must be pre-configured on the program itself to make it work.. too bad...
thanks anyways for the help...
i would still like to figure out how to make this one work.

[Jhedzkie Skies]

  jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=MyCustomers.mdb   

i see here again another code... and it has no path... what does this mean? :O