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\d b\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... 5 3392
"DeanL" <de************ *@yahoo.com> wrote in message
news:11******** **************@ g14g2000cwa.goo glegroups.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\d b\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
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...
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?
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...
"DeanL" <de************ *@yahoo.com> wrote in
news:11******** **************@ f14g2000cwb.goo glegroups.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/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 library. Every thing is great
if the customer of my shared library is using the same compiler
version (and same STL version). I am wondering if the customer changes
their compiler version (or STL version) which may have same interface
|
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 ADO to access the database.
It was not written specifically for DB2 and I think almost all queries are
running as dynamic queries. The performance issue arise when users are
|
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:
Directory.CreateDirectory(@"\\ghpvn-linux1\ghp\20041205");
ghpvn-linux1: is the server name
ghp: is the shared directory
20041205: is the directory that I want to create
I receive error, starting "Could not find part of the path '\\ghpvn-linux1\ghp'."
I try...
|
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' variable for the application. Any other code
within the application can access it.
public - can be shared across the application if instatiated.
Does that sound about right? It seems these are more useful for methods
rather than variables. Most of...
|
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 ref's:
Interop.DAO,System,System.Data,System.Drawing,System.windo
ws.forms,System.XML.
all that's on this form is a button and when the button
is clicked it opens up a fox pro database and gets the
needed info/close. Now this works just fine on my
| |
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 I'm just running it locally and saving
the file locally using my machines UNC path.
I have given user ASPNET full control over the folder I want to write the
file to. I've also tried using the web config identity impersonation to use
my user...
|
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 real problems with the ASP side of
things.
Timeline of events is as follows:
1) Added IIS (via Add/Remove Windows Components) on WinXP Pro machine (6
|
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 able to edit the data
(no message ever appeared telling him he could not change any data). The
only change to the db since he experienced the problem was that a new
version of the db was made available for installation which everyone has now...
|
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 (wxPython) Python program that needs
to access external data across a serial port.
The first thing that I need the program to do when it starts up is to
check that it can see the serial port, the first step of which is to
check that it can import the...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |