Multi User Problem

Drunkenneo

Registered User.
Local time
Tomorrow, 00:19
Joined
Jun 4, 2013
Messages
192
I have made a mdb with the backend and front end which is given to users.

The problem is i have to import file with 100 records and other have only one record, when executing the importing at same time one use get duplicate error and one gets 101 record updated, This is strange to me, Please help as is searched else where in forum and didn't found one?
 
It appears that each user has their own Back End. Is this correct.

A backend should reside on the server and should be shared by everyone.

However eack user should have their own Front end on their own C:\Drive.
 
the BE is on the server, and the Frnt end Generated is on the users PC.
 
the BE is on the server, and the Frnt end Generated is on the users PC.

So if you only update the one back end how do the users gey a different result.

Or am I misreading the question.
 
Last edited:
Unable to get the point, please elaborate.

If everybody is using EXACTLY the same front end, except for the fact that they are copies.

Then each FE is linked to the same BE in the same way.

How can there be different results.
 
For the part i would like to say, if user 1 is importing a file from import button and user 2 is doing the same from his front end, simultaneously...
the table is getting updated for both of us only difference is user 2 is promted for duplicate record else user1 have been showing records (user1) + Records (user2) updated.

I have given the same FE for both the users. but if they do one followed by another then the result is positive for both of them.
 
But they are importing to the one and only Backend.

So regardless if the import is correct or not it should be the same for every user.
 
Try closing the Database and reopen.

It should not make a difference but still it should be tested.
 
Last edited:
The result is same, BTW what is PM you mentioned above?
 
The result is same, BTW what is PM you mentioned above?

Sorry (Typo)

That should be PK for Primary Key or FK for Foreign Key.

If you had a bucket and put two apples in it, then you should see two apples and so should I.

Is each user using the same Append Query.

How do you run this query. If you run it in the Module have you turned off warnings.

Just thinking of other possibilities.

Try running the two queries from the same Front end. One after the other. What happens.
 
How are you doing the import? Are you using TransferText? or something similar or did you write your own code? Does the target table have an autonumber as its primary key?
 
How are you doing the import? Are you using TransferText? or something similar or did you write your own code? Does the target table have an autonumber as its primary key?

Import as DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Temp", fname, True code. no i am using transfer spreadsheet.

No the target doen't have autonumber.
 
This requires testing to see exactly when the problem is caused.

You should be able to recreate the problem using the same front end.

That is. Same Front End on the Same Computer.
 
Why are two people importing the same fiel at the same time or is the imported files different?

Should one person be delegated to update the BE with the new import file.?
 
that is the part of checking when same event is occured at same time then this thing need to be incurred, because we are going to do the same with 8 users who may do this and since the datas are in millions it may not be possible to check at the time.
 
that is the part of checking when same event is occured at same time then this thing need to be incurred, because we are going to do the same with 8 users who may do this and since the datas are in millions it may not be possible to check at the time.

If you are dealing with Millions of Records on a Daily basis you may run into a problem with Access. Access has a size limit of 2Gb.

That is room for a lot of Data however millions of records every day certainly will add up to be a problem. In the future you may have to move to SQL Server or as I prefer MySQL. This is a problem you should be aware of but there is no need to do anything at the moment. Just keep an eye on the size of the back end.
 
:) yes, thanks for the suggestion that is on the watch. however main thing is still remaining opened.

Rainlover: could you help please as this is not the chain to ask, however i have a dialer pro exe i want to call it from access on a click of button, i could be able to call the exe from code in VBA, A little will be a help?
 
Rainlover: could you help please as this is not the chain to ask, however i have a dialer pro exe i want to call it from access on a click of button, i could be able to call the exe from code in VBA, A little will be a help?

I am sorry but I am not familiar with your terminology.

Like chain to ask or dialer pro.

If this has nothing to do with the original problem then start a new thread.
 

Users who are viewing this thread

Back
Top Bottom