Max Users Access 2007

[Dweeberella]

Regarding the Microsoft Access 2007 template program for Contact Management --

Do you think 30 users could easily use the Contact Management application at
the same time with Access 2007 Runtime?

 

[Tony Toews [MVP]]

Regarding the Microsoft Access 2007 template program for Contact Management --

Do you think 30 users could easily use the Contact Management application at
the same time with Access 2007 Runtime?

Thirty users is reasonable with Access so long as the network is
stable and you're on a LAN. If a WAN it'd better be very fast as in
100 Mpbs.

You want to split the MDB into a Front End MDB containing the queries,
forms, reports, macros and modules with just the tables and
relationships in the Back End MDB. The FE is copied to each network
users computer. The FE MDB is linked to the tables in the back end
MDB which resides on a server. You make updates to the FE MDB and
distribute them to the users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. The utility also supports Terminal Server/Citrix quite
nicely.

Tony

 

[Dweeberella]

Thank you for your feedback, Tony.

Do you think 30 users is still reasonable if I upsize the back end to SQL
Server Express 2008?

 

[Tony Toews [MVP]]

Do you think 30 users is still reasonable if I upsize the back end to SQL
Server Express 2008?

You could have a thousand users on SQL Server.

Tony

 

[Dweeberella]

Thanks Tony

Both SQL Server and SQL Server Express?

 

[AccessVandal via AccessMonster.com]

err.....If you already have SQL Server, you don't need SQL Server Express.

 

[Dweeberella]

We don't have SQL Server.

err.....If you already have SQL Server, you don't need SQL Server Express.

 

[AccessVandal via AccessMonster.com]

Than, download SQL Server Express.

We don't have SQL Server.