Form with 3 users

[mulderm]

Hello,

Question 1:
Is it possible to use the same form, from the access database on the
server, working with 3 users on 3 different pc's?


Question 2:
How can I send data, wich is in the cells of an Excel file, to an Access
database in a table?
I have a machine that put data in an Excel-file without opening.
Because I want put the data in Access I want automatically, done by
VBA, send the data from Excel to Access without opening Excel.
Is this possible?

greetings,

mulderm

 

[labanTek]

Question 1

Hi i had a ms access app that i placed on a server and 36 different users accessed the database at the same time with no problems. 3 is minor. hope this helps

 

[mulderm]

Hi,Labantek,

But can the users also working at the same form at the same
time?
What will happen if they add a new record on the same time?

mulderm

 

[iazcac]

The only problem you will have if more than one user is editing data on the same record at the same time as you will get a write conflict. But users being in the same form is not a prob

As for them all entering new records at the same time, not a problem either

 

[mulderm]

Thank you for the information.

mulderm