How Many Front-ends Can Be Attached To A Single Back-end?

[sandybam]

Is there a limit to how many front-ends can be attached to a single back-end database?

Thank you!
Sandy

 

[scking]

Not that I'm aware of. A link is merely a full path to a database and tablename.

Steve King Growth follows a healthy professional curiosity

 

[sandybam]

Thank you Steve!

 

[Cleis]

SandyBam:

It is my understanding that for performance issues, you should not go over 25 concurrent users for a mdb or mde file. Someone correct me if I'm wrong


Rich

 

[dhboston]

Rich is correct. Access limits the concurrent users to 255 but for performance, 25 is the recommended limit.

Darwyn

 

[AdamIT]

Geez, Access is not much of an enterprise level DBMS is it? 25 user recommended limit, 1 gig max db size (97 anyhow, don't know about 2000).

Quick question though, does Access support stored procedures? As far as creating a command object in VB and using it to run a stored procedure that returns a recordset object? Is this possible with an Access db? (maybe this should be a seperate post...

 

[tlbroadbent]

Correct. Access isn't an Enterprise RDMS. It is a desktop RDMS, development environment, reporting tool, GUI interface, etc.

Access 2000 has a 2GB size limit.

Native Access using the Jet DB Engine doesn't support stored procedures. Access projects support stored procedures on SQL Server or MSDE. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.