Hi all,
we got here one database which has several linked tables, whereas the
link points to several csv-files. Currently we also have 2 different
queries using the linked tables. Now one of us is opening query 1 and
the other one is trying to open query 2 after query 1 was opened. But
opening query 2 (from a different computer) is not allowed and gives
the following error message:
"The Microsoft Jet database engine cannot open the file 'query 1'. It
is already opened exclusively by another user, or you need permission
to view its data."
We are not even openening the same query! I can hardly believe that you
cannot run two different queries at one time! Are there any options we
have to set?
System: Win 2003 Server
Access Version 2003
thanks in advance for any help and hints
Florian
6  2486 
Split your database and create separate frontends for each user. Make sure
that the Default record locking is set to Edited records on your backend.
One of the main "rules" of a multiuser Access implementation is an mdb for
each user. To find out how to split your db type split in the Access help. fa**********@gm x.de wrote: Hi all,
we got here one database which has several linked tables, whereas the
link points to several csv-files. Currently we also have 2 different
queries using the linked tables. Now one of us is opening query 1 and
the other one is trying to open query 2 after query 1 was opened. But
opening query 2 (from a different computer) is not allowed and gives
the following error message:
"The Microsoft Jet database engine cannot open the file 'query 1'. It
is already opened exclusively by another user, or you need permission
to view its data."
We are not even openening the same query! I can hardly believe that you
cannot run two different queries at one time! Are there any options we
have to set?
System: Win 2003 Server
Access Version 2003
thanks in advance for any help and hints
Florian
--
Message posted via AccessMonster.c om http://www.accessmonster.com/Uwe/For...ccess/200606/1
jahoobob via AccessMonster.c om wrote: Split your database and create separate frontends for each user.
I doubt that has much to do with anything regarding the OPs problem.
Make sure that the Default record locking is set to Edited records on your backend.
One of the main "rules" of a multiuser Access implementation is an mdb for
each user. To find out how to split your db type split in the Access help.
We have no idea if someone has /excl on the shortcut. We have no idea
of the queries are using multiple CSVs. We have no idea what the
attributes/properties are on the CSVs or folder. We have no idea if the
mdb is already split or not. We don't know if this is an Action query
or a Select statement. We don't even know why they guy is getting a
message about query1 when he's opening query2. Maybe "WITH OWNERACCESS
OPTION" needs to be added to the SQL statement. I think its something
more than splitting the mdb.
fa**********@gm x.de wrote:
Hi all,
we got here one database which has several linked tables, whereas the
link points to several csv-files. Currently we also have 2 different
queries using the linked tables. Now one of us is opening query 1 and
the other one is trying to open query 2 after query 1 was opened. But
opening query 2 (from a different computer) is not allowed and gives
the following error message:
"The Microsoft Jet database engine cannot open the file 'query 1'. It
is already opened exclusively by another user, or you need permission
to view its data."
We are not even openening the same query! I can hardly believe that you
cannot run two different queries at one time! Are there any options we
have to set?
System: Win 2003 Server
Access Version 2003
thanks in advance for any help and hints
Florian
You're asking for locking problems when more than one user tries to access a
single mdb! Why not go ahead and split?
salad wrote: Split your database and create separate frontends for each user.
I doubt that has much to do with anything regarding the OPs problem.
Make sure that the Default record locking is set to Edited records on your backend.
One of the main "rules" of a multiuser Access implementation is an mdb for
each user. To find out how to split your db type split in the Access help.
We have no idea if someone has /excl on the shortcut. We have no idea
of the queries are using multiple CSVs. We have no idea what the
attributes/properties are on the CSVs or folder. We have no idea if the
mdb is already split or not. We don't know if this is an Action query
or a Select statement. We don't even know why they guy is getting a
message about query1 when he's opening query2. Maybe "WITH OWNERACCESS
OPTION" needs to be added to the SQL statement. I think its something
more than splitting the mdb.
Hi all,
[quoted text clipped - 18 lines]thanks in advance for any help and hints
Florian
--
Message posted via http://www.accessmonster.com
jahoobob via AccessMonster.c om wrote: You're asking for locking problems when more than one user tries to access a
single mdb! Why not go ahead and split?
What if it is already split?
"jahoobob via AccessMonster.c om" <u12179@uwe> wrote in
news:6210fc7d16 dd4@uwe: You're asking for locking problems when more than one user
tries to access a single mdb! Why not go ahead and split?
Absolute rubbish. If the application is properly designed, and the
table locking parameters are correctly set to shared and current
record only, there should be no problem when linking a .mdb to
another .mdb
The original poster's problem is that he's got linked .csv files.
Access has no mechanism for locking records in a .csv file so it
locks the whole file. Access won't even let one user open two
instances of a .csv in the same query.
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from http://www.teranews.com fa**********@gm x.de wrote in
news:11******** **************@ p79g2000cwp.goo glegroups.com: Hi all,
we got here one database which has several linked tables,
whereas the link points to several csv-files. Currently we
also have 2 different queries using the linked tables. Now one
of us is opening query 1 and the other one is trying to open
query 2 after query 1 was opened. But opening query 2 (from a
different computer) is not allowed and gives the following
error message:
"The Microsoft Jet database engine cannot open the file 'query
1'. It is already opened exclusively by another user, or you
need permission to view its data."
We are not even openening the same query! I can hardly believe
that you cannot run two different queries at one time! Are
there any options we have to set?
Even the same user cannot open the two queries on the same
machine at the same time, if they point to .csv files.
Import your tables to a back end .mdb and the problem will go
away. You'll also have much improved performance.
System: Win 2003 Server
Access Version 2003
thanks in advance for any help and hints
Florian
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from http://www.teranews.com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Andreas Lauffer |
last post by:
I changed from Access97 to AccessXP and I have immense performance
problems.
Details:
- Access XP MDB with Jet 4.0 ( no ADP-Project )
- Linked Tables to SQL-Server 2000 over ODBC
I used the SQL Profile to watch the T-SQL-Command which Access ( who
creates the commands?) creates and noticed:
|
by: John E |
last post by:
I have an Access 2000 database in which there are remotely linked SQL tables
and a couple of local tables.
If I have queries in Access that are designed to pass data between these
remote linked and local tables, is it possible to execute these queries
externally (i.e. from outwith Access) using, for example, .NET/C#? Or is it
possible to run an Access user defined function or macro externally which
then in turn deals with the queries?
...
|
by: Aaron |
last post by:
Hello fellow programmers,
I am trying to run an append/update query from code, a command button
on a form initiates the queries.
the format i am using is;
_____________________________________________________
SELECT "criteria"
|
by: Stinky Pete |
last post by:
Hi,
I've got two users needing to look at the same database, but both are
running differnent versions of access. One is running running Win 98 /
Access 97 and the other is running Win XP / Access 2003. I've converted the
file to 97 format so both can use it - but is there a better way to do this
and not mess with the original version? Obviously ugrading would a good,
but I'm not going to get approval to change until a new PC is...
|
by: Jim S |
last post by:
To my surprise and chagrin, newer versions of Access have disabled the
functionality that lets users change the data in linked tables that point to
a range in an Excel workbook. This is "because of legal issues..." according
to Office Support.
I have other issues, specifically a couple of applications that do things
such as calculate price updates in Access and read them back by means of
update queries into the spreadsheets our marketing...
| | |
by: google |
last post by:
I am creating a new database for use within our company, that I'd like
to make reasonably secure (short of a true server based solution). The
back-end of a non-server based database seems to be the biggest
security hole, due to the ease of opening, linking, and/or importing
raw data directly from the back-end database. I've read information
that indicates that locking down the back-end tables to the owner, then
using RWOP queries in the...
|
by: Janelle.Dunlap |
last post by:
I have a table in my database that is linked to an excel spreadsheet. I
need to be able to manipulate the data in this linked table so that I
can create smaller normalized tables that work with what I am trying to
do (all data used in my db will come from this one spreadsheet). I am
currently trying to utilize the make-table queries to create the tables
that I need from this data, however I am unsure of how to add foreign
keys to a...
|
by: Chandan Ahuja |
last post by:
Hello ,
I use MFC DAO classes to access my MS access database .
I am using some linked tables(Linked to Oracle) in my MS Access database .
Also i have some queries in my databse , these queries select some rows from the linked tables and insert them in MS access local tables .
I am facing problem while executing these queries .
The problem is that -- through the code ; when i am asking these query to execute , it prompts...
|
by: nimajneb via AccessMonster.com |
last post by:
Can anyone offer me any insight on the following problem?
I have an Access database on a company shared drive. I'm the designer and
the only user (so far). Suddenly, any time I try to open a table, Access
crashes... but if I look at that same data by *querying* the table (SELECT *
FROM ), everything works fine.
Even though my data seems fine *for now*, it's a little scary for me.
Insight? Possible solutions?
|
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: 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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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: 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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: 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.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
