Add record to Access Database

[Guest]

I am using ASP to insert records into an Access database, and I have two
questions:

(1) The users are ONLY adding records to the database: is there a need to be
concerned about performance given the limits of Access in terms of
simultaneous connections?

(2) What settings do I need to check in Access to make sure that the
database will allow records to be written from a web form (with asp)?

Thanks.

 

[Guest]

I am using ASP to insert records into an Access database, and I have two
questions:

(1) The users are ONLY adding records to the database: is there a need to be
concerned about performance given the limits of Access in terms of
simultaneous connections?

Depends on the # of users trying to add at the same time. I seriously doubt
you will have problems unless you are talking about hundreds of users adding
at the same time.

(2) What settings do I need to check in Access to make sure that the
database will allow records to be written from a web form (with asp)?

There are no special Access settings you need to make. You need to make
sure though that the Web Server has permissions to the file and has full
rights to the directory the file is in as it will need to create an LDB file
and delete it as needed.

--Steve Huff

 

[Guest]

Thanks!

Depends on the # of users trying to add at the same time. I seriously doubt
you will have problems unless you are talking about hundreds of users adding
at the same time.


There are no special Access settings you need to make. You need to make
sure though that the Web Server has permissions to the file and has full
rights to the directory the file is in as it will need to create an LDB file
and delete it as needed.

--Steve Huff