Import from csv file works fine , but not in multi user env.

[juvi]

Hello,

I have a front-end db and back-end db. The FE imports csv files into tables.
This works fine but if more than one user tries to import the files then only
the first gets all data. How to manage this for multi user or catch this with
message "currently in use, try later".??

thx
juvi

 

[Ken Snell \(MVP\)]

Are the two users importing at exactly the same time? Do they import into
the exact same table in the backend file? Please, tell us many more details.

 

[juvi]

it can happen that they are trying to import at the same time. They import it
local into their front-end-DB and later they try to upload data through
odbcDB-connection to the back-end-DB (same tables and here it can also
happen, that they are trying to do this at the same time).

It could also happen that somebody wants to work with the back-end-DB local

 

[Ken Snell \(MVP\)]

First question I must then ask: why in the world would you want to allow
more than one user to import and upload the exact same data to the exact
same database? Perhaps the better approach to fixing this problem is to
resolve having multiple people doing the exact same task in the database?

If someone has opened the backend file on the server while others are trying
to edit/upload/delete/add data to that backend file, you are asking for
various corruption likelihoods and conflict errors. No one should be able to
connect to the backend while another person has directly opened that backend
file.

 

[juvi]

These are requirements to this project. Cannot change them. The data in the
csv changes only once a day and the users are updating maybe twice a week. So
I am now checking, if the file is open or not. If yes the user can try the
download later.

I see no problems here. The second requirement: Upload of data stored in the
Frontend-DBs to the Backend-DB. These data differ from each user, so it is
not the same data, which is uploaded, but it is uploaded into the same table
of the Backend-DB.

How would you manage this if the requirements are the following:
- upload of data to Backend-DB from various users (without collision at the
same time)
- usage of that data local without collision of upload-connections

thx

 

[Ken Snell \(MVP\)]

There must be some aspects of your setup that I am not understanding.

The use of a backend database is intended to minimize "conflicts" when users
are editing/changing/adding data to the backend database file. From what
you've described, each user is wanting to upload different data into the
same backend database. You don't specify the exact method that you're using,
but, assuming that your backend database file is an .mdb file, I would link
to the backend table to which I want to add the data, and run an append
query to add the data to that table. I assume that the users are already
linked to tables in the backend file, right?
--

Ken Snell
<MS ACCESS MVP>

 

[NO]

Hello,

I have a front-end db and back-end db. The FE imports csv files into
tables.
This works fine but if more than one user tries to import the files then
only
the first gets all data. How to manage this for multi user or catch this
with
message "currently in use, try later".??

thx
juvi


---
avast! antywirus: Przychodzace wiadomosc czysta.
Baza sygnatur wirusow (VPS): 080707-0, 2008-07-07
Przetestowano na: 2008-07-07 19:28:29
avast! - Copyright (c) 1988-2008 ALWIL Software.
http://www.avast.com

---
avast! antywirus: Wychodzace wiadomosc czysta.
Baza sygnatur wirusow (VPS): 080709-0, 2008-07-09
Przetestowano na: 2008-07-09 19:29:29
avast! - Copyright (c) 1988-2008 ALWIL Software.
http://www.avast.com