Maximum amount of users

[mech55]

How many users can an access database support? I'm setting up an app accross 3 workstations but each has multiple users. There may be as many as 1000 records a day entered. Can an access database handle this or do I need to switch to sql server?

 

[mech55]

So as long as I Filter when I open a form it should be ok to connect to a table?

 

[Ron_dK]

Upsizing the database will require certain form changes regardless of whether you choose an .adp (which I don't recommend) or an .mdb (which I DO recommend).

Just curiosity Pat, but why would you prefer to upsize as an .MDB in stead of an .ADP

 

[Ron_dK]

Thanks for exlanation Pat. The reason I was asking this is that we considered using an .apd with SQL server. I reckoned that adp only uses
forms/reports/code, whereas mdb has extended features as tables/queries and the like. So , we will definitely go for mdb.

Cheers, Ron