By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,701 Members | 1,970 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,701 IT Pros & Developers. It's quick & easy.

Access Exclusively opened by another user

P: n/a
Hello!

We are developing and selling an application which uses Access DB over network.
It works fine.
However, we encountered a strange case.

Computer A(DB Server): Windows 98, Access 97 (mdb), App
Computer B(DB Client): Windows XP, App

[1]
When I start App from Computer A first, it starts fine.
And then when I try to start App from Computer B, it gives the following error.

Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC
Microsoft Access 97 Driver] The Microsoft Jet database engine cannot open
the file '(unknown)'. It is already opened exclusively by another user, or
you need permission to view its data.

[2]
When I start App from Computer B first, it starts fine.
And then I start App from Computer A, it starts fine, too.
But sometimes, I can't save data on Computer A.

We are using ODBC to connect to the DB.
We developed the App with PowerBuilder 7.0.

What is wrong with that?

TIA.

Sam
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Why are you "starting the app" on Computer A?

Do you not have the app split into front end and back end, with the back end
(tables/relationships/data) on Computer A and a separate copy of the back
end on each user's machine?

Have you checked to see if Computer A's machine is opening in "Exclusive
Use" mode?

In any case, I suggest you separate the data (back end) from the user
interface (front end) and give each user a copy of the front end. An
overview presentation on Access in a Multiuser Environment can be downloaded
from http://appdevissues.tripod.com/downloads.htm, and the best detail
collection of information and links on the subject that I know about is at
MVP Tony Toews' site http://www.granite.ab.ca/accsmstr.htm.

Larry Linson
Microsoft Access MVP

"Sam Kong" <ss*@chol.net> wrote in message
news:f0**************************@posting.google.c om...
Hello!

We are developing and selling an application which uses Access DB over network. It works fine.
However, we encountered a strange case.

Computer A(DB Server): Windows 98, Access 97 (mdb), App
Computer B(DB Client): Windows XP, App

[1]
When I start App from Computer A first, it starts fine.
And then when I try to start App from Computer B, it gives the following error.
Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access 97 Driver] The Microsoft Jet database engine cannot open
the file '(unknown)'. It is already opened exclusively by another user, or
you need permission to view its data.

[2]
When I start App from Computer B first, it starts fine.
And then I start App from Computer A, it starts fine, too.
But sometimes, I can't save data on Computer A.

We are using ODBC to connect to the DB.
We developed the App with PowerBuilder 7.0.

What is wrong with that?

TIA.

Sam

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.