Single User

  • Thread starter Thread starter Lam
  • Start date Start date
Is Access the Single user database?

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]
 
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.
 
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).
 
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
 
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

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
 
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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top