473,378 Members | 1,417 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,378 software developers and data experts.

Reguarding Data Base opened in Exclusive mode

The problem is that i had a database opened in exclusive mode and i created a User DSN to allow external application to access my DataBase.....

Now this process works fine if i open my database in eclusive mode..... the DSN work perfectly and i get my data through other application

but the problem occured i run my application in single user mode i.e. in exclusive mode the the DSN retuns an error the data base is opened by some other user...


so i want to know that is there any way to access a database opened in exclusive mode through User DSN....
Aug 11 '10 #1
1 2154
Stewart Ross
2,545 Expert Mod 2GB
Exclusive Access is not an appropriate mode in which to open an Access database. It is not possible to share access with any other user to a database opened exclusively.

The database really should be set to shared and not exclusive if the likelihood is that more than one user is to access it on occasion. It is the only way you can resolve the lock-out which is occurring.

-Stewart
Aug 11 '10 #2

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

Similar topics

2
by: Dave Reid | last post by:
Hi everyone... I'm trying to open a text file in exclusive mode (meaning I want to lock out any other processes from accessing the file while I'm working with it). Here's my code: ifstream...
4
by: Greg M. Silverman | last post by:
We just converted several of our major front-ends from Access 97 to Access 2002. However there is an undesirable feature that we hadn't anticipated in testing: the fact that changes to...
4
by: Paul Copeland | last post by:
Hi, I am using Access2000 and have developed a data base which successfully uses DAO code in some of the forms to update tables. Recently I converted the data base to a split MDE data base and now...
1
by: Chuck Van Den Corput | last post by:
I have encountered a problem that I am hoping someone can shed some light on. I have a multi-user A97 app. All users have a personal front-end MDE accessing a shared back-end. There is no...
2
by: Javier Gomez | last post by:
How to open a linked table in exclusive mode from a FORM in DAO ??? (but,...... please I need it in DAO.) Thank you ! Javier Gomez
7
by: Lian | last post by:
Hi every body I have a problem with accesses and visual studio. I've just installed XP and I can't get a connection with the Data base. I have this error and I don't know how to fix it The...
1
by: Frank Rizzo | last post by:
I am trying to open a file in exclusive mode for writing. Is the code below correct? FileStream oStream = File.Open(FileName, FileMode.Open, FileAccess.Write, FileShare.None); The purpose is...
2
by: Mat | last post by:
Or how to check if it's open in exclusive mode...? Thx
1
by: buclas | last post by:
Hi, I need to link a mdb file and make sure it opens in a non-exclusive mode. I looked for a similar post but none was answered. I know there is a specific param to add to the command line to...
1
by: gerryis2000 | last post by:
Hi, kindly guide me on how to solve this security problem. i set a passord to the data base and seems to work well. but since several people use the data base and know the passord, i think its risky....
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
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: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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.