If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Application Errors
If I double click on the database file to open the Access application I get
2 errors. 1) Sometimes the application can't find the files of data I want to import into the application. 2) Sometimes when I exit Access I get the following error Cannot open database 'c:\db1.mdb'. It may not be a database that you application recognizes, or the file may be corrupt but it is fine. If I just open Access and click FILE, OPEN and browse to the database file, no errors happen. How can I let the user double click on the database file to open the application without getting application errors? I do not want to hard code any directories when doing file imports etc. Thanks |
#2
|
|||
|
|||
If I just open Access and click FILE, OPEN and browse to the database
file, no errors happen. How can I let the user double click on the database file to open the application without getting application errors? I do not want to hard code any directories when doing file imports etc. The only time I have ever seen this behavior is on a machine with more than one different version of Access installed on it, and the problem is the file association. For Example: 1. Install Access 2003 2. Setup registers the .mdb file extension and associates it with Access 2003. 3. A user can double-click an mdb file and Access 2003 opens it. 4. Install Access 97 in a different directory. 5. Setup registers the .mdb file extension and associates it with Access 97 6. A user double-clicks an mdb file and Access 97 *tries* to open it, but fails, because Access 97 cannot read the Access 2003 mdb file. All Access 97 knows is that it can't read the database, so it complains that it is missing or corrupted or not a database. 7. The user launches Access 2003 and uses File-Open and can open it fine. -- Peace & happy computing, Mike Labosh, MCSD Feed the children! Save the whales! Free the mallocs! |
#3
|
|||
|
|||
Thanks but let me clarify
I have and have had only 1 version of Access installed. I can always open the application either way. The errors occur when running a macro and it is looking for a specific file name to import. The other error, Cannot open database 'c:\db1.mdb'. It may not be a database that you application recognizes, or the file may be corrupt., occurs when I quit Access. Any ideas? "Mike Labosh" wrote in message ... If I just open Access and click FILE, OPEN and browse to the database file, no errors happen. How can I let the user double click on the database file to open the application without getting application errors? I do not want to hard code any directories when doing file imports etc. The only time I have ever seen this behavior is on a machine with more than one different version of Access installed on it, and the problem is the file association. For Example: 1. Install Access 2003 2. Setup registers the .mdb file extension and associates it with Access 2003. 3. A user can double-click an mdb file and Access 2003 opens it. 4. Install Access 97 in a different directory. 5. Setup registers the .mdb file extension and associates it with Access 97 6. A user double-clicks an mdb file and Access 97 *tries* to open it, but fails, because Access 97 cannot read the Access 2003 mdb file. All Access 97 knows is that it can't read the database, so it complains that it is missing or corrupted or not a database. 7. The user launches Access 2003 and uses File-Open and can open it fine. -- Peace & happy computing, Mike Labosh, MCSD Feed the children! Save the whales! Free the mallocs! |
#4
|
|||
|
|||
Hi,
There's no error handling in macros so I don't think there's much you can do about (other than do the same thing in code and then trap the error). For the second error, do you have the db set to compact on close? -- HTH Dan Artuso, Access MVP "Craig" wrote in message ... Thanks but let me clarify I have and have had only 1 version of Access installed. I can always open the application either way. The errors occur when running a macro and it is looking for a specific file name to import. The other error, Cannot open database 'c:\db1.mdb'. It may not be a database that you application recognizes, or the file may be corrupt., occurs when I quit Access. Any ideas? "Mike Labosh" wrote in message ... If I just open Access and click FILE, OPEN and browse to the database file, no errors happen. How can I let the user double click on the database file to open the application without getting application errors? I do not want to hard code any directories when doing file imports etc. The only time I have ever seen this behavior is on a machine with more than one different version of Access installed on it, and the problem is the file association. For Example: 1. Install Access 2003 2. Setup registers the .mdb file extension and associates it with Access 2003. 3. A user can double-click an mdb file and Access 2003 opens it. 4. Install Access 97 in a different directory. 5. Setup registers the .mdb file extension and associates it with Access 97 6. A user double-clicks an mdb file and Access 97 *tries* to open it, but fails, because Access 97 cannot read the Access 2003 mdb file. All Access 97 knows is that it can't read the database, so it complains that it is missing or corrupted or not a database. 7. The user launches Access 2003 and uses File-Open and can open it fine. -- Peace & happy computing, Mike Labosh, MCSD Feed the children! Save the whales! Free the mallocs! |
#5
|
|||
|
|||
I do have the db set to compact on close, can that cause a problem?
"Dan Artuso" wrote in message ... Hi, There's no error handling in macros so I don't think there's much you can do about (other than do the same thing in code and then trap the error). For the second error, do you have the db set to compact on close? -- HTH Dan Artuso, Access MVP "Craig" wrote in message ... Thanks but let me clarify I have and have had only 1 version of Access installed. I can always open the application either way. The errors occur when running a macro and it is looking for a specific file name to import. The other error, Cannot open database 'c:\db1.mdb'. It may not be a database that you application recognizes, or the file may be corrupt., occurs when I quit Access. Any ideas? "Mike Labosh" wrote in message ... If I just open Access and click FILE, OPEN and browse to the database file, no errors happen. How can I let the user double click on the database file to open the application without getting application errors? I do not want to hard code any directories when doing file imports etc. The only time I have ever seen this behavior is on a machine with more than one different version of Access installed on it, and the problem is the file association. For Example: 1. Install Access 2003 2. Setup registers the .mdb file extension and associates it with Access 2003. 3. A user can double-click an mdb file and Access 2003 opens it. 4. Install Access 97 in a different directory. 5. Setup registers the .mdb file extension and associates it with Access 97 6. A user double-clicks an mdb file and Access 97 *tries* to open it, but fails, because Access 97 cannot read the Access 2003 mdb file. All Access 97 knows is that it can't read the database, so it complains that it is missing or corrupted or not a database. 7. The user launches Access 2003 and uses File-Open and can open it fine. -- Peace & happy computing, Mike Labosh, MCSD Feed the children! Save the whales! Free the mallocs! |
#6
|
|||
|
|||
Hi,
Try turning that off and see if the error goes away. In order to compact, Access closes your db and makes a copy and if I'm not mistaken, it calls it db1. Although I've never seen an error occur before. -- HTH Dan Artuso, Access MVP "Craig" wrote in message ... I do have the db set to compact on close, can that cause a problem? "Dan Artuso" wrote in message ... Hi, There's no error handling in macros so I don't think there's much you can do about (other than do the same thing in code and then trap the error). For the second error, do you have the db set to compact on close? -- HTH Dan Artuso, Access MVP "Craig" wrote in message ... Thanks but let me clarify I have and have had only 1 version of Access installed. I can always open the application either way. The errors occur when running a macro and it is looking for a specific file name to import. The other error, Cannot open database 'c:\db1.mdb'. It may not be a database that you application recognizes, or the file may be corrupt., occurs when I quit Access. Any ideas? "Mike Labosh" wrote in message ... If I just open Access and click FILE, OPEN and browse to the database file, no errors happen. How can I let the user double click on the database file to open the application without getting application errors? I do not want to hard code any directories when doing file imports etc. The only time I have ever seen this behavior is on a machine with more than one different version of Access installed on it, and the problem is the file association. For Example: 1. Install Access 2003 2. Setup registers the .mdb file extension and associates it with Access 2003. 3. A user can double-click an mdb file and Access 2003 opens it. 4. Install Access 97 in a different directory. 5. Setup registers the .mdb file extension and associates it with Access 97 6. A user double-clicks an mdb file and Access 97 *tries* to open it, but fails, because Access 97 cannot read the Access 2003 mdb file. All Access 97 knows is that it can't read the database, so it complains that it is missing or corrupted or not a database. 7. The user launches Access 2003 and uses File-Open and can open it fine. -- Peace & happy computing, Mike Labosh, MCSD Feed the children! Save the whales! Free the mallocs! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Application Errors | Craig | General Discussion | 5 | September 23rd, 2004 12:22 PM |
outlook opens and flashes closed | General Discussion | 5 | July 24th, 2004 11:00 AM | |
Outputting files from a custom application in MS Word Binary Format | Rod Colen | General Discussion | 1 | July 14th, 2004 11:52 PM |
Msohelp.exe - Application Error | Armando Alvarez | Setting up and Configuration | 0 | October 9th, 2003 08:29 PM |