Cannot Open MS Access database Workgoup PC
Last answer on Jul 4, 2009 2:07:55 pm BST razinfrat, on Feb 17, 2009 12:43:38 am GMTHello,
We have a workgroup network of 3 PC's in our small office. One PC is set as the workgroup server and the other 2 PC's connect to it using a mapped drive to access folder and files to share between us. All three computers are on XP-Pro; Office PC-1 is using MS Office 2002; Office PC-2 is using MS Office 2007.
Problem: Office PC-1 (OPC-1) cannot open any of the MS Access databases. We receive error message that OPC-1 cannot open database. We can copy the database to the desktop on OPC-1; open it; add data; save it; then copy back to the mapped drive on workgroup server. All other MS office files (Word and Excel) can be opened from the mapped drive with no problem.
Office PC-2 (OPC-2) has no problem connecting to, opening and saving any of the MS Access databases, Word or Excel files on the mapped drive.
Anyone have a clue as to the possible problem? Have checked several of the settings on both PC's to see if they match but cannot seem to find the problem. WE NEED HELP!!!!
Office 2007 changed file formats. You may need to change the defaults on OPC-2 to save in the 2002-2003 format. Then open and save each and every file on the server. There is a compatibility pack that you must have downloaded to allow Office to read the 2007 file format. It may be that while the Office 2002 computer (OPC-1) can open and convert the 2007 access files it can not share the file from the server if it is in 2007 format. Good Luck |
We have a external backup. I cannot open backup or a copied version on a flash drive. Wants password. When entered it denies access. I was told to open security to everyone- I tried did not help.
|
Uh., i have a similar problem i guess, accessing files in the local network,..
|

