Access 2003

frankiedi · 05-24-2008, 05:51 PM

We have two networked computers, both running Windows XP Pro, and Access 2003. We have a database (MDB) file on computer 1. If the file is open on the computer housing the database, clicking on the file from computer 2 will not open the application. However, the file can be accessed by starting Access on computer 2 first. If the file is not open on computer 1, clicking on the file from computer 2 will open the application, but shows an error message warning about unknown publisher. Everything else on computer 1 can be opened from computer 2 with no problem. This database issue showed up after working fine for several months.

**djaburg** · 05-27-2008, 09:25 AM

What happens when you do double click on it from computer 2, does a different program open up? On computer 2 I'd make sure that Access is the default application for .mdb files. To check, open the My Computer icon (or use windows explorer), click on TOOLS>FOLDER OPTIONS>FILE TYPES and the scroll down to MDB and it should show something like Microsoft Access Application. If it doesn't, then you need to change it by clicking on CHANGE and select it from the list. If it's not on the list, then perhaps the installation of the program is bad. You can still set it up by clicking on BROWSE and finding the MSACCESS.EXE file.

frankiedi · 05-29-2008, 12:10 AM

The file opened the application properly for several months. I don't have any reason to believe the file association changed on computer 2, but I will go to where these computers are and check to be sure it is correct.

Thanks

frankiedi · 05-29-2008, 12:17 AM

I'm sorry. I wasn't thinking clearly when I posted my last reply. Clicking on the file on computer 1 (where the database resides) from computer 2 does open Access on computer 2 providing the file isn't already open. However, if the file is already open on computer 1, clicking on it doesn't open the application on computer 2. Nothing appears to happen when we click on the file.

05-24-2008, 05:51 PM	#1 (permalink)
frankiedi Registered User Join Date: Apr 2008 Posts: 8 OS: XP Pro, SP2	Access 2003 We have two networked computers, both running Windows XP Pro, and Access 2003. We have a database (MDB) file on computer 1. If the file is open on the computer housing the database, clicking on the file from computer 2 will not open the application. However, the file can be accessed by starting Access on computer 2 first. If the file is not open on computer 1, clicking on the file from computer 2 will open the application, but shows an error message warning about unknown publisher. Everything else on computer 1 can be opened from computer 2 with no problem. This database issue showed up after working fine for several months.

05-27-2008, 09:25 AM	#2 (permalink)
djaburg TSF Enthusiast Join Date: May 2008 Posts: 1,316 OS: XP SP3/Vista/7 Server 2K/2K3/2K8	Re: Access 2003 What happens when you do double click on it from computer 2, does a different program open up? On computer 2 I'd make sure that Access is the default application for .mdb files. To check, open the My Computer icon (or use windows explorer), click on TOOLS>FOLDER OPTIONS>FILE TYPES and the scroll down to MDB and it should show something like Microsoft Access Application. If it doesn't, then you need to change it by clicking on CHANGE and select it from the list. If it's not on the list, then perhaps the installation of the program is bad. You can still set it up by clicking on BROWSE and finding the MSACCESS.EXE file. __________________ Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done. The inherent vice of capitalism is the uneven division of blessings, while the inherent virtue of socialism is the equal division of misery.

05-29-2008, 12:10 AM	#3 (permalink)
frankiedi Registered User Join Date: Apr 2008 Posts: 8 OS: XP Pro, SP2	Re: Access 2003 The file opened the application properly for several months. I don't have any reason to believe the file association changed on computer 2, but I will go to where these computers are and check to be sure it is correct. Thanks

05-29-2008, 12:17 AM	#4 (permalink)
frankiedi Registered User Join Date: Apr 2008 Posts: 8 OS: XP Pro, SP2	Re: Access 2003 I'm sorry. I wasn't thinking clearly when I posted my last reply. Clicking on the file on computer 1 (where the database resides) from computer 2 does open Access on computer 2 providing the file isn't already open. However, if the file is already open on computer 1, clicking on it doesn't open the application on computer 2. Nothing appears to happen when we click on the file.