Single User

J

John Vinson

Is Access the Single user database?
Click to expand...

No; it supports up to 256 simultaneous users according to the
specifications (though I'd say that 100 simultaneous read/only users,
maybe 30 simultaneous updating users would be safer).

John W. Vinson[MVP]
 
D

Douglas J. Steele

No. Out of the box, it's capable of supporting multiple users.

The recommended approach is to split the application into a front-end
(containing the queries, forms, reports, macros and modules), linked to a
back-end (containing the tables). Only the back-end should be on the server:
each user should have his/her own copy of the front-end, preferably stored
on their hard drive.
 
V

Van T. Dinh

It is a multi-user file-sharing database.

However, it is recommended that for a multi-user application, you should
always split the system to Front-End (GUI) and Back-End (data).
 
L

Lam

I try to write a aspx page in c# to access the Access database
if I open the mdb file, the aspx page willl show "The file is in use error"
how can I access mdb file when it' s open? or maybe I should ask that
question
in C# news group
Thanks a lot
 
L

Larry Linson

Lam said:
I try to write a aspx page in c# to access the Access database
if I open the mdb file, the aspx page willl show "The file is in use error"
how can I access mdb file when it' s open? or maybe I should ask that
question
in C# news group
Click to expand...

If appropriate system permissions and sharing options have been set,
multiple users should be able to use that Jet database (which even Microsoft
often calls an "Access database" because Jet is the default database engine
installed and used with Microsoft Access). As to what ADO.NET commands you
need to use, yes, an ASP.NET, ADO,.NET, or C# newsgroup would be better.

Larry Linson
Microsoft Access MVP
 
D

Douglas J Steele

You need to ensure that the Id under which the aspx is running has Change
access (Read, Write, eXecute, Delete) on the folder where the mdb file
exists. I'm not sure about ASP.Net, but I know with ASP, typically that id
is IUSR_<MachineName>
 
Top