One form across multiple locations for medium enterprise size

[The_learnerSimon]

I have team across 4 different locations and must use one Acc form through shared network. The form consists daily activities with hours to input. Since team size upto 70, creating copies of Fe form for each individual can be tiresome or is there a way to split ONE form into frontend and shared to everyone in ONE email. So they can download into their location machines.

Challenge is I will have multiple users using form at the same time and the data entered by each individual should be used for further analysis. Confused to see the best option.

 

[theDBguy]

Hi. Welcome to AWF!

Where is your data stored? If Access, is it split?

 

[The_learnerSimon]

Hi. Welcome to AWF!

Where is your data stored? If Access, is it split?

Hello and thank you.

Yes it is split.

 

[The_Doc_Man]

Just for verification, is everyone on a Local Area Network? If the answer is NO then you have other issues to consider.

Query slow on split database on network

I haven't used Access much in several years now, so I am rusty on how to use it and also never knew the full ins and outs, so I may need a thorough explanation. I am hoping to clean up a 5+ year old database that hasn't been used for a while but they are picking up again. The database is split...

www.access-programmers.co.uk

Look at post #15 in that thread for an example of a batch file that you could use pretty easily. If you read more of Pat Hartman's comments following post 15, you would see how to use it for any number of front ends. The batch job just downloads and launches the FE file and everyone gets their own copy.

What you do not EVER want to do is share a "monolithic" database with multiple users opening the same file in a central location because of issues in Windows file locking. But if everyone has a unique front-end that was split off of a monolithic database then nothing in the individual FE files will encounter a lock-style fault (called a lock collision.) And if the things in the FE are properly programmed, the shared BE file will be OK. I've had as many as 40 to 50 users of which maybe 10 would be on at once and I never had issues.