warning message / form while data is being processed

[webisti]

Hi
I do have a DB that takes some data from Stripes and imports them into access.
Since this will be a multi user DB I want to make a warning form,
Basically a user will do the download, I want a form or a pop up message that will show to the next user that will open the DB while the download process is ongoing, to see that the download data process is still ongoing,
That he needs to wait until the data download has finished.
Any ideas how to achieve this?

Thanks

Webisti

[rpeare]

Is there a reason you can't link directly to the data source and avoid the import process altogether?

Based on your description I don't see why you'd import the data. Are you saying that your data source (the stripes part) is not part of your local setup that you're actually receiving a file from an outside source that you have to deal with? Even if you are, as long as the file is in a format MS access can recognize you should be able to link to it directly rather than having to import the data every time.

For instance let's say you receive a file today

it's named BLAHBLAH_001.txt

tomorrow you receive a file named

BLAHBLAH_002.txt

If you were to, say, name your 'current' file Current_BLAHBLAH.txt

you could establish a link in access to the file and regardless of whether the file was currently downloading or not your database would still work. You'd just have to coordinate when you're going to rename the files which is a much shorter and easier thing to deal with in your database.

[webisti]

Hi
Basically since this db is a multiuser one, What I want to do is that the first user will open the DB and a warning message will let him know that the sales for that day have not yet been downloaded,
He will do the download, but if another user will open the same db just 10 sec later I want him to see a screen that will tell him that Data download is under process,
Once the download has taken place the next user that will open it will see a green form telling him all data has been downloaded. and he can go ahead with his checks.

The reason I want to do this is to avoid two users doing the downloada in the same time (they are not sitting in the same location)

any ideas

webisti

[rpeare]

I understood the problem the first time around all you really did was explain the same situation again and didn't answer any of my questions

So let me say this: if you are trying to detect whether or not a download is in progress between two machines on your network that is not a problem for access, that is something that would have to run on your server if anywhere and it wouldn't involve access at all.

You would be better of attempting to prevent importing duplicate information rather than trying to stop someone from performing the download, that way if they did import the same data twice it wouldn't hurt you.

[webisti]

I understood the problem the first time around all you really did was explain the same situation again and didn't answer any of my questions

So let me say this: if you are trying to detect whether or not a download is in progress between two machines on your network that is not a problem for access, that is something that would have to run on your server if anywhere and it wouldn't involve access at all.

You would be better of attempting to prevent importing duplicate information rather than trying to stop someone from performing the download, that way if they did import the same data twice it wouldn't hurt you.

Ok Let me start from begining. I do not want to use linked tables, I want access to be an independent database of any external links.
since this will be used by 12 people
I have aa form that tells to the first user logging into the DB that data has not been downloaded, and he will do the download. How can I prevent the other users not to do the download while the first user is doing the process. How to make them tell that User A is already downloading the data, please wait,

That is my issues... and I am not using a SQL server, I just want a DB that will do this work for me.

Any ideas?

Webisti

[rpeare]

The short answer is you can not detect an ongoing download from one workstation to another. Nor can you prevent two different people from downloading the file unless you delete the source file as soon as it's downloaded, even then I don't know that that would prevent the second person (if their download is already in process) from completing. I'd suggest giving only one person the ability to download the file with one person as a backup who only completes the function if the first person is absent.

[webisti]

The short answer is you can not detect an ongoing download from one workstation to another. Nor can you prevent two different people from downloading the file unless you delete the source file as soon as it's downloaded, even then I don't know that that would prevent the second person (if their download is already in process) from completing. I'd suggest giving only one person the ability to download the file with one person as a backup who only completes the function if the first person is absent.

actually I found a way to do what I wanted, but I am still on the process to finish it:
There will be a splash form that will welcome the user and also warn if the data has not been downloaded.
On the afterupdate() of the splash form I will include a tracing record (vba) that will save in a new table called "tracing" the timestamp when he clicked the button "download data". If the second user will enter the db, the spash form will check the tracing table where the timestamp is stored and eventually will disable the "download data" button, or in the contrary will show him the warning.
Like this I make sure to have just one person doing the activity and not assigning this job to only one of them.
What do u think?

Webisti

[rpeare]

That is neither detecting or preventing multiple people from downloading the file but if it does what you want it to problem solved.