I have a project in which I only need read access to a Microsoft Access database (.mdb file) via JDBC and unfortunately, the file is frequently
locked by another application when I need access to it. I figured that
I could bypass the lock file by creating a symlink (my os is Fedora
Core 3 Linux) and just putting the url to the Symlink into the
connection. Obviously I am having problems. Has anyone else done
this, and if so, how? Or better yet, is there a way to read the
database even though it is locked?
(Note: I know, access databases suck, I wish I didn't have to use it,
but I have no choice in the matter, they sold it, I have to make thier
lies come true).
Re: QRe: Legacy Access 2 VB 4 app, Word 11 merge on XP Pro SP2 client ... selecting "blank database" or some such. ... possible to set a simple password on a whole mdb file,... case, make sure you have a backup of the .mdw file, then launch Access ... >I could not get the app to accept the changes to Notepad within the ... (microsoft.public.access.conversion)
Re: Mixing P/R philosophy with OO (within J2EE). ... I have observed the work of literally hundreds of Java developers.... Treating a database like a mere "persistence storage mechanisms" is on ...JDBC - Never before in history were so many database API's ... Topmind, if you're reading this, isn't this a good example of OOP?... (comp.object)
Re: Basic security questions ... Your ASP page would "connect" to the file on the Unix box via ADO or ADO.NET ...Password protected databases are different from database protected by ULS ... ULS protected databases require the use of the .mdw workgroup file... >> If you double-click an mdb file, the sequence of actions is as follows. ... (microsoft.public.access.security)
Re: Creating a new Access database file (.mdb) in .NET/C# ... create an empty shell MDB file and you can then run ... copy the MDB file to a folder and run the DDL against it ... I'm making changes to a small, portable, single-user database...Frank McKenney, McKenney Associates ... (microsoft.public.dotnet.framework.adonet)
