'Access' a protected Access 97 database with Access 2003 Installed
-
Background: I have Access 2003 installedand the database I'm trying to connect to via C# was probably created using Access 97. I don't have the option to upgrade the database and must remain in Access 97 format. The database is protected by a workgroup ID. The command line option for spawning the database is: MSACCESS.EXE c:\master.mdb /wrkgrp c:\master.mdw /user foo /pwd bar This brings up the database, but I get an error stating: You can't make changes to the database objects in the database 'master.' This database was created in an eariler version of Microsoft Office Access.... Problem 1: Read-only connection If I try and connect to this database from c#, I get the following error. :(( System.Data.OleDb.OleDBException: Cannot start your application. The workgroup information file is missing or opened exclusively by another user. Since I can open the database using the command line above, I suspect in order to read the database, I need to somehow specify read-only access within the connection string. Here's my connection string: String conStr = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\master.mdb;SystemDB=C:\\master.mdw;User Id=foo;Password=bar;"; Problem 2: Actually altering the data Is there a way to modify this database without either upgrading the database or downgrading my access application? :confused: Code Cowboy