re: db for desktop and web

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

will eichert - 16 Sep 2003 00:56 GMT

Greetings. I have a desktop Access app (split into back-
end and front-end) that is currently used/updated by a
single person.

The next phase of the project has arrived, which is to
give read and write access to several people (3 or 4) on
our LAN, and to provide a web form for database update via
the internet. The web interface will only be used
occassionally, by very few people, probably no more than 1
at a time (though you never know).

Can a Jet-based db handle this, or do I need to upsize to
a SQL db? I'm planning on setting up a server to host the
backend db and run IIS, but I'm unsure which database
engine to use. If I can get away with the current Jet
engine (this would be easier, since I wouldn't need to do
the upsizing), how do I set up permissions that will
manage the concurrent connections? Can an ASP ADO
connection update an Access db when a desktop user has it
open for updating?

Thanks for any advice.

Will

Reply to this Message

Alick [MSFT] - 17 Sep 2003 05:12 GMT

Hi,

In database level, the maximum number of concurrent connection is 255; for
each connection to a shared database, the Jet database engine writes an
entry in the .ldb file of the database. The size of each .ldb entry is 64
bytes. The first 32 bytes contain the computer name (such as JohnDoe). The
second 32 bytes contain the security name (such as Admin). The maximum
number of concurrent users that the Jet database engine supports is 255;

ACC2002: Using Microsoft Jet with IIS
http://support.microsoft.com/?id=299974

Introduction to .ldb Files
http://support.microsoft.com/?id=299373

If the database is not opened exclusively, multiple users can open and
update the database; however, it seems in database level there is no easy
way to manage the permissions for concurrent connections. Possibly you can
use workgroup security file to do that, however, if possible I think it
could be better if we can manage it in ASP (web) level.

Please feel free to reply to the threads if you have any concerns.

Sincerely,

Alick Ye, MCSD
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

--------------------

| Content-Class: urn:content-classes:message
| From: "will eichert" <wfeichert@ucdavis.edu>
[quoted text clipped - 23 lines]
|
| Will

Reply to this Message