Questions about Access.

[JDMils]

One of my users wants to create a front-end to our SQL database using
Access. He then wants to share this front-end with 60 users. Is this
possible? I heard that there is a limit of 10 concurrent users per Access
database.

Office 2003 Pro

 

[Rick Brandt]

One of my users wants to create a front-end to our SQL database using
Access. He then wants to share this front-end with 60 users. Is this
possible? I heard that there is a limit of 10 concurrent users per
Access database.

10 is a terribly low estimate even if using an MDB for the back end. Concurrent
user limits for "Access" basically do not apply when using a server back end.
The limit is what SQL Server can handle, not what Access can handle.

Of course you would want to give all 60 users their own copy of the Access front
end, not just throw a single copy on a server and have everyone use it.

 

[aaron.kempf]

This guy is full of crap.

Access MDB can't support 10 connections.

Use SQL Server 2000 and ACCESS DATA PROJECTS.

It's a _GREAT_ combination. I've been using them every day for YEARS.
it's a little bit to get used to.. but if you know SQL Server and you
can write sprocs and views-- it's a no-brainer.

a _MUCH_ simpler environment than MDB linked tables.

SPIT on people that use MDB Linked Tables.


-Aaron
ADP Nationalist

 

[aaron.kempf]

Access MDB will cause locking problems at a mere 25mb of data.

Don't touch MDB with a 10-foot pole.

-Aaron
ADP Nationalist

 

[John Vinson]

One of my users wants to create a front-end to our SQL database using
Access. He then wants to share this front-end with 60 users. Is this
possible? I heard that there is a limit of 10 concurrent users per Access
database.

It's perfectly practical; Access makes a very good frontend to SQL.

The way you'ld do it is to have the Access database with links to the
SQL tables (no local data, unless you want it for some reason); *EACH
USER* would get their own copy of this frontend, so you would not be
facing any concurrency issues.

FWIW Access is documented to allow 255 concurrent users; in practice
more than 30 or 40 updating users, or 100 or so read-only users, is
pushing it a bit. The 10 user figure is totally bogus.

John W. Vinson[MVP]

 

[aaron.kempf]

John

I disagree.

MDB isn't that scalable. 2 users in MDB would be lucky to not have
random, unexplained locking probems.

Maybe you should start speaking the truth about the short comings of
MDB.

ADP is an excellent choice. I highly reccomend that option.

Data Entry is wonderful; Reports are fast.. much much much simpler to
implement than any stupid MDB / Linked table solution.

Don't fight for the pink team-- MDB has been obsolete for 6 years;
almost 7 years now.


-Aaron Kempf
ADP Nationalist