Fuzzy Orange
New Member
I have code that works on a hosted site. But I can not get it to work on our development server at work. Exact same code except for the the location of the database. The latest error is:<BR><BR>Cannot start your application. The workgroup information file is missing or opened exclusively by another user.<BR><BR>I am not sure what "workgroup information file" is. Do they mean the database?<BR><BR>Thank you<BR>AaronTake a look:<BR>http://p2p.wrox.com/archive/asp_database_setup/2001-02/29.aspDo we need MS Access installed on our server?<BR>If not how do I get to the workgroup information?I don't think you need Access installed per se, but you do need the Jet 4.0 drivers installed, and some version of MDAC (the latest is like 2.7), You can get all of these at<BR>http://www.microsoft.com/data/download.htm<BR>We have the driver Jet 4.0 and MDAC 2.7 installed.<BR><BR>I created a DSN and put in the user id and password.<BR><BR>When I set up the connection like this:<BR>oConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; DSN=mydsn;")<BR><BR>It gives the following error:<BR>OleDbException (0x80004005): Could not find installble ISAM.<BR><BR>If I use this code:<BR>oConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; DSN=mydsn; user id=Admin; password=mypassword;")<BR><BR>It gives me the error:<BR>Cannot start your application. The workgroup information file is missing or opened exclusively by another user. <BR><BR>I created a workgroup information file, joined it and it is in the same folder as the MS Access database.<BR><BR>Thank you<BR>AaronI got it to work with a MS Access database that does not have a password. But not with a database that has a password.<BR><BR>