Search : in
By :

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 GMT 
 Report this message to moderators

Hello,
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!!!!

Best answers for « Cannot Open MS Access database Workgoup PC » in :
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
[Office] The feature you are trying to use (Error 1706) Show[Office] The feature you are trying to use (Error 1706) When opening a program in the Microsoft Office suite (Excel, Word, Access, PowerPoint), a window tells you one of the following messages: Microsoft Excel has not been installed...
Command prompts for Windows ShowCommand prompts for Windows Some of these command below can cause harmful an undesirable functions, leading to the formatting of your hard disk and data loss, while others will not run under Windows XP. As for Windows Vista the Run Tab is not...
Download Advanced Database Recovery Show
Download The Worldwide Deduplicator ShowThe Worldwide Deduplicator is a record duplicator meant for MS Access databases. Advantages: 1. Its main advantages are that it provides you with easy ways to browse and find documents that have not been entered in the database correctly....
Download Database Editor ShowThe database management is a complex task, for the experimented users in general. For a specific task, specific tools are needed. Database editor is a tool allowing fast and easy access to any sorts of database. It will help database developers and...
Introduction - Databases ShowWhat is a database? A database (abbreviated DB) is an entity in which data can be stored in a structured manner, with as little redundancy as possible. Different programs and different users must be able to use this data. Therefore, the concept of...
ODBC ShowWhat is ODBC? ODBC stands for Open Database Connectivity. This is a Microsoft-defined format for communicating between Windows database clients and consumer DBMSs. The ODBC managier can be found in Windows 3.1 and 9x. In Windows 95 and 98, it is...
Memory Stick (MS Card) ShowMemory Stick The Memory Stick (written as MS or MS Card) is a type of memory card created jointly by Sony and SanDisk in January 2000. The architecture of Memory Stick cards is based on NAND flash memory circuits (EEPROM). Memory stick...
Ask your question Reply

1

xpcman, on Feb 17, 2009 2:31:46 am GMT
  • +3

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

   
Reply to xpcman

2

BeckyMc, on May 4, 2009 1:37:30 pm BST

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.

Does anyone have any solutions or ideas- please any will help. I must have a backup that I can open.
Thank you.

   
Reply to BeckyMc

3

vain, on May 13, 2009 6:18:48 am BST
  • +1

Uh., i have a similar problem i guess, accessing files in the local network,..

i have saved the Database (.mdb) file into the server's Disks and am using the "\\server\folder\database.mdb" as my connectionstring data source and it works, i can now add, edit, and delete the files in the said Access file using the package i have installed in another computer in the network.

but before i could access the database from the remote computer, i have to log off from the default user of the Computer and log in as an Administrator with the administrator account that i have.

i have noticed in one system that we are using here in our workplace that whenever the other computers are going to use their online file management system, they are prompted to log in as an administrator for that particular program on that session

there is a window that pops up which looks a little bit like this image in this link,
http://techsalsa.com/wp-content/uplo...gin-screen.gif

, and so they call me to log in the Administrator's account using the same Administrator account that i have.

how do i apply this in my system so that i could access the database from our server?
any help would be much appreciated, thx

   
Reply to vain

4

 ISD, on Jul 4, 2009 2:07:55 pm BST
  • +1

How To Save & Search Image To access database using vb6.

   
Reply to ISD
Ask your question Reply
They need your help