473,382 Members | 1,424 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

Unable to open MS Access file(.mdb) while it is opened by any other user.

Hi All,
I am getting very strange problem regarding MS Access.
I am using Access 97.I have one mdb file.
What happens is that when a user double clicks the shortcut to this file, it doesn't respond at all when there's already someone using the file. But if no one is using the file, it responds immediately.
I dont know whether its a MS Access problem or not.
Your quick response will be highly appreciated...
Sep 10 '07 #1
3 3436
damonreid
114 Expert 100+
Ensure your form does not edit the connection file.

Search the code for this:
Expand|Select|Wrap|Line Numbers
  1. CurrentProject.Connection.Properties("Jet OLEDB:Connection Control")
if the database was developed by another person.
Sep 10 '07 #2
Ensure your form does not edit the connection file.

Search the code for this:
Expand|Select|Wrap|Line Numbers
  1. CurrentProject.Connection.Properties("Jet OLEDB:Connection Control")
if the database was developed by another person.

Hi,
Thanks for your quick response.
I serached in my code for the line you gave..But it is not in my project and unfortunately i havent developed database.Can you suggest anything else
Sep 10 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
Hi All,
I am getting very strange problem regarding MS Access.
I am using Access 97.I have one mdb file.
What happens is that when a user double clicks the shortcut to this file, it doesn't respond at all when there's already someone using the file. But if no one is using the file, it responds immediately.
I dont know whether its a MS Access problem or not.
Your quick response will be highly appreciated...
Open the database and go to Tools - Options. Under the Advanced tab check that the Default Open Mode is set to Shared.
Sep 13 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

9
by: Nick | last post by:
Hi, We're are about to develop an app in C# that will use a MS Access database file for data storage. The db structure will not be modified. The user will use the C# developed app to view and...
3
by: Jon S via DotNetMonster.com | last post by:
Hi all, Is there a way to convert an Access.mdb from one format (say Access '97 or Access 2000) to Access 2002 format using ADO.NET and C#??? I know how to do it manually using the Access DBMS...
4
by: Byron Hopp | last post by:
We have the need to extract data from an ADO dataset to an Access MDB. We have this working be having an empty MDB that we copy and utilize for the extract. We get errors on an irregular basis. ...
1
by: D Kanagh | last post by:
Hello Does anyone know where I can obtain a function to test whetber my front-end is open via the provided icon vs. the Access 2000/2002 file menu? I want to test the open.mdb and if opened...
2
by: rlntemp-gng | last post by:
I have a system that uses two .mdb files that are open at the same time, App1.mdb and App2.mdb. At the time that App2 is launched by App1, App1 remains open with a form (and table) already loaded...
9
by: rlntemp-gng | last post by:
I have an application where App1.mdb calls App2.mdb when a button is clicked on a form. App1 has three values of interest: 1. gblPgmPath 2. frmMain1.txtSubTotalVariance 3....
0
by: dreamer247 | last post by:
hii all i am working with mssql 2000 and after restoring a databas from device the warning is .. Warning: mssql_connect() : message: Cannot open user default database. Using master database...
1
by: ATSPSoft | last post by:
Hi, I'm newest in c#.. i need to create an Access MDB file... Supose that my MDB file is "mymdb" and my table is "mytableA" with 2 fields like "field1" as integer and "field2" as string How...
9
by: Martin | last post by:
Using ODBC in a PHP script, I'm trying to read an MS Access MDB file that resides on another computer on my LAN. I'm getting the error: Warning: odbc_connect() : SQL error: The Microsoft Jet...
2
by: Martin | last post by:
From a PHP script, is there any way to retrieve data from an MS Access database that's located on another computer (on a LAN) other than by using ODBC? I posted a question here a couple of weeks...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.