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

Problems with a shared Access 97 DB

Hi all,

I'm having a few problems with a shared access 97 db. I have the
database split with the tables on the server and everything else in
"client" front ends with links to the tables, e.g.
\\10.31.42.10\db\mydb.mdb but the whoever opens their front end first
appears to have exclusive access to the database. Anyone else who
tries to open the database can open it to a certain extent (as long as
the form in question has no data on it, e.g. the switchboard, splash
screen, etc.) but then gets the error 'Run Time error '3045' the file
is already in use' whenever someone tries to open any data bearing form
or query (or anything with data for that matter).

I've created several access applications that in some cases were
considerably more complex and in some cases less so similar to this in
the past with no problems and have followed the same procedures I
always have but to no avail. Everyone has the correct permissions to
the server as anyone can use the db but only one at a time.

I know this would always be more beneficial to create an application
like this in SQL Server but unfortunately, the company I'm creating
this for only has access 97 and that's it. So if anyone knows why this
may be occurring (sic) then I'd appreciate a little help.

Many thanks, D...

Feb 16 '06 #1
5 3369
"DeanL" <de*************@yahoo.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
Hi all,

I'm having a few problems with a shared access 97 db. I have the
database split with the tables on the server and everything else in
"client" front ends with links to the tables, e.g.
\\10.31.42.10\db\mydb.mdb but the whoever opens their front end first
appears to have exclusive access to the database. Anyone else who
tries to open the database can open it to a certain extent (as long as
the form in question has no data on it, e.g. the switchboard, splash
screen, etc.) but then gets the error 'Run Time error '3045' the file
is already in use' whenever someone tries to open any data bearing form
or query (or anything with data for that matter).

I've created several access applications that in some cases were
considerably more complex and in some cases less so similar to this in
the past with no problems and have followed the same procedures I
always have but to no avail. Everyone has the correct permissions to
the server as anyone can use the db but only one at a time.


And just what are those permissions? What you're describing sounds like they
don't have file create permission on the folder. Is an LDB file being created
when the first person opens the file?
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Feb 17 '06 #2
Hi Rick,

Whoever opens the file seems to create a .LDB file (opening this in
notepad or the like shows the user name logged onto the database) but
no one else seems to be able to log in. There is another tables
database in the same location and there appears to be no problems
accessing this for the same people so it would appear to be my db only
that's having/causing the problem.

Thanks, Dean...

Feb 17 '06 #3
DeanL wrote:
Hi Rick,

Whoever opens the file seems to create a .LDB file (opening this in
notepad or the like shows the user name logged onto the database) but
no one else seems to be able to log in. There is another tables
database in the same location and there appears to be no problems
accessing this for the same people so it would appear to be my db only
that's having/causing the problem.

Thanks, Dean...

Any possibility the shortcut has a /excl in it?
Feb 17 '06 #4
It doesn't BUT, I seem to have got it working. It seems the clients
server is a UNIX box that they've been running Access DB's off for
years but they way it's set up is to stop direct access to the file and
only allow access through a link so once that link was created and the
Linked tables pointed to the link rather than the files directly it
seems to work fine (breath in deeply after such a long sentence). Many
thanks for your help guys and sorry to have bothered you with something
so trivial that I should have picked up myself.

All the best, Dean...

Feb 17 '06 #5
"DeanL" <de*************@yahoo.com> wrote in
news:11**********************@f14g2000cwb.googlegr oups.com:
It doesn't BUT, I seem to have got it working. It seems the
clients server is a UNIX box that they've been running Access DB's
off for years but they way it's set up is to stop direct access to
the file and only allow access through a link so once that link
was created and the Linked tables pointed to the link rather than
the files directly it seems to work fine (breath in deeply after
such a long sentence). Many thanks for your help guys and sorry
to have bothered you with something so trivial that I should have
picked up myself.


I would never under any circumstances put any of my clients' data on
a Linux file server. I would not support this.

It's not that Linux and Samba are not reliable -- they certainly are
-- it's that there are lots of complicated timing issues with the
way Jet works with the file system that I know for a fact is
supported by Windows, but can never know for certain what's going on
with Linux.

Linux and Access simply don't mix, in my opinion.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Feb 17 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: AH | last post by:
I have two functions in my shared library which are declared as follows: void setName(const std::string& str); std::vector<std::string> getInfo(); Since the code is compiled and in shared...
6
by: George McLean | last post by:
Hello, I am trying to isolate some performance issues. The database is DB2 v8.1 running on a Win2000 server with 4 processors and 1gb of RAM. The application is a GIS application that uses...
5
by: Van Nguyen via DotNetMonster.com | last post by:
My app run at 2 modes: Windows and Service. At Windows mode, my app works fine but at service mode, I can not use CreateDirectory command to create a new directory on server. Ex:...
10
by: darrel | last post by:
I'm still trying to sort out in my head the differences between public and shared when referring to declaring properties or variables. This is my understanding: shared - akin to a 'global'...
4
by: john | last post by:
I'm having some Interop problems. I really need someone's help on this, i'm running out of ideas. I have upgraded my Data access controls to the latest ver. Now then i have a form with these...
1
by: Duffman | last post by:
Hi, I have what seems to be a common problem, but the solutions I've found don't seem to work. I would like to use a web service to create a file at a UNC location in a shared file. Currently...
3
by: Newbie | last post by:
Hi All Trying to create a mini-ASP web dev with a couple of PCs at school. When the teachers are happy with the site on the LAN then going to upload it to the school site. Problem is having...
3
by: Earl Anderson | last post by:
One of the users in our departmental db has Read/Write permissions to a particular form. He was able to access and edit the form at will until 2 weeks ago. His current problem was that he was not...
3
by: John Dann | last post by:
Trying to learn Python here, but getting tangled up with variable scope across functions, modules etc and associated problems. Can anyone advise please? Learning project is a GUI-based...
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
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
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?
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
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

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.