over ten users causes Access application to crash 1

[xwizardx]

I've written an application that runs in a small office. It works fine with a small number of users running the application. When it gets up to around ten users, though, the entire system crashes.

1. Is there some limit to how many users can use an Access '07 application?

2. Have others run into this problem?

3. Are there any solutions to this problem?

Thanks for any insights you can giave me.

Barry Davis, President
Small Business Computing, LLC

 

[dhookom]

Ten shouldn't be causing an issue. Does each user have his/her own front-end file? Are any users connecting using wireless?

Is there anything we should know about your application?

Duane
Hook'D on Access
MS Access MVP

 

[xwizardx]

There are about 30 potential users. No more than around ten are on line at any one time. Some number of them are hooking up wirelessly. Also, people who are in the office at any given time have a tendancy to just click into the system and let it sit until they need it. Any given person might make five or six entries in an entire day.

Thanks for the quick response.

Barry Davis

Barry Davis, President
Small Business Computing, LLC

 

[xwizardx]

oh! And each has his/her own front end file.

Barry Davis, President
Small Business Computing, LLC

 

[dhookom]

I don't care much for wireless connections and Access. You might consider SQL Server Express which is free and much more robust.

Duane
Hook'D on Access
MS Access MVP