Ideas on project- frontend?

[Ecniv]

I think it depends how you set the database up as to whether it can handle more than ten users.

I will test (hopefully) at some point in the future and post up if it fails miserably.

[Dave Sell]

I think it depends how you set the database up as to whether it can handle more than ten users.

Regardless of what "you think", MSAccess was not designed to handle more than 10 simultaneous users. I have found many article to articulate this in the past, but I don't have them now.

It's just a simple fact. There is no "server side" marshalling process with which to manage all the database activity between all the clients. This is what RDBMS's are there for - to balance and manage all the ins and outs to the database.

I will test (hopefully) at some point in the future and post up if it fails miserably.

This is not something you can "test". I failure may not show up for months, but it is nearly a guarantee, and you may lose all your data between that and the last backup.

You, like so many others, will "test the waters" and find no problems and assume its an appropriate setup.

You will do as you please, but consider yourself fairly warned...