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 :
Coding to link Visual basic to MS Access ShowCoding to link Visual basic to MS Access Issue Solution Note Issue Hello, Please I need to know the coding, how to link visual basic to MS Access! Solution You can try this: Option Explicit Dim conn As ADODB.Connection, rec...
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...
How to open Registry ShowHow to open Registry The registry is a directory path that stores option and settings for windows operating system. The registry allows you to access difficult file to track in the background. All changes that are made in the control panel are...
Download MYSQL to Access Database File Converter ShowTo handle Access database is more flexible than to handle MYSQL that is why it would be better to use this latter. To convert your database, Sanmaxi has edited a powerful tool to meet your needs. MYSQL to Access Database File Converter is a...
Download MYSQL to Access Database File Converter Show
Download Advanced Database Recovery Show
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...
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...
Databases - Using forms ShowUsing forms In order to use databases, the user must be provided with an interface that allows him or her to view data based on certain criteria. There is a tool for this: forms. A form is an interface with components for displaying, entering, or...
Ask your question Reply

1

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

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