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

How to open DBase a III table non-exclusively

I have a Dbase III table (we'll call it "table Z") that is used by several applications. These applications do not open the table in exclusive mode -- they use record-locking when adding, deleting or modifying table "Z'.

I am trying to create an Access 2003 database that has to link to table "Z". This table only needs read-only access to the table, but will use it's data in the Access database. It will not add, delete or modify table "Z".

Each time I try to link, I get the following Microsoft Office Access error message: "The Microsoft Jet database engine cannot open the file [path and name of table]. It is already opened exclusively by another user, or you need permission to view its data."

Now I know I have full access to table "Z", so permissions are not a problem. I also know the other applications that use table "Z" do not open it exclusively -- they use record level locking when they add, delete or modify a record in table "Z".

I know I can set up a .bat file that will copy table "Z" to the customer's computer, open the Access database and programatically link to the table, but would like to find a better way.

Anyone know of a way I can get around the "...it is already opened exclusively" problem?
Dec 16 '13 #1
1 1251
zmbd
5,501 Expert Mod 4TB
More than likely either:
1) someone has the file open in exclusive mode
2) your connect string has a goof in it.

Please post the code you are using to establish the connection.

PLEASE format the posted script using the [CODE/] button in the tool bar and inserting the script between the code tags.
Dec 17 '13 #2

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

Similar topics

2
by: Goldfisch1980 | last post by:
Hi! I read an dBase table under Win XP by the common dBase functions of PHP 4.3.5. But all records are displayd with a wrong charset. All umlauts of the databasefile like "öäüéô"... and so on...
1
by: SharkFOA | last post by:
Hi, Hoping someone can help. I have created a pivot table and launch it via a command button. Unfortunately, it opens in form view and not in pivot table view. I have opened the form in design...
1
by: argniw | last post by:
I want to open to the pivot table view automatically (by default) when I open a query. I don't want to have to go to the menu first. I am in Access 2003. I think I did this once but can't...
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
2
by: trint | last post by:
Anyone aware of c#, ado.Net dbase IV code sample? I would like to just open and view a .dbf table. Thanks, Trint
3
by: Dave | last post by:
I'm writing a c# Windows program that needs to be able to insert records into a dbase table. I can read it using a dataset but can't insert records. I receive the following error, ERROR ...
0
by: simon.kravis | last post by:
I've been struggling with getting this message when I tried to change the design of one of about 50 tables in Access 2000 database, with no forms open which might be bound to the table, no queries...
1
ashsa
by: ashsa | last post by:
Hi all, How could i open a new window whose content is a html table or a div from the current document ? The actual prob is that i try to generate an excel table from the html table. Tried...
0
by: Moor | last post by:
I'm unable to to open a linked table T that is stored in an Access 2.0 MDB database file (shared/back-end,) using both Access 2.0 and Access 2003, in the same time. Here is the scenario: 1-...
3
by: mark007 | last post by:
I want to open a table from switchboard in datasheet view to enter data, can anyone please guide me how it can be done, i created a form for the table and tried to open it from switchboard but it...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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...

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.