file « MS Access « Java Database Q&A

1. Is there any file-based db with concurrent per-file user access similar to MS Access but Open Source?    stackoverflow.com

Most time I build simple applications that share data through an MS Access DB through a network drive. However, MS Access in damn slow, does not support common features of SQL, is ...

2. HOw to Access Field & MS Access File    coderanch.com

3. Using MS ACCESS in a jar file    coderanch.com

4. retrieve link to a file from MS Access DB    coderanch.com

So are you saying you need to retrieve the OLE object from the DB in order to get the path to it? 1.) Is it possible to store the paths separately? It would be a performance gain to avoid pulling back a full OLE object and getting the path out of that. 2.) I'm not sure how you get info out ...

5. connect to MS Access database file without making a dsn?    coderanch.com

6. how can I open Ms access file in my java program    forums.oracle.com

stm=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); //rs=stm.executeQuery(query); setQuery(query); // setDatabaseTable(query); } catch (SQLException ex) { ex.printStackTrace(); GlobalData.displayDataBaseError("User Creation"); } finally { if(qryStmt!= null ) { try { qryStmt.close() ; qryStmt=null; } catch (SQLException ex) { ex.printStackTrace(); } } if(con!= null ) { try { con.close() ; con=null; } catch (SQLException ex) { ex.printStackTrace(); } } } }

7. Opening MS Access file (not JDBC)    forums.oracle.com

MS Access if running perfectly but the particular file requsted for is not opening. That block is being ignored (no errors or something). I have to open the file manually from MS Access (which I dont want). Can anyone help me. And another thing, here i have specified the absolute path for MSACCESS.exe, is their any way to find out the ...