1. I am not sure what to set on my website to allow multiuser access to my
Access database. I am using a systemDSN. I don't use the Database wizard
because I find it too limiting.. and use vbscript, asp and javascript. The
website is a company intranet so depending on department, some can add,
change,delete while others only get to view information. There is only 13
users so Access should be adequate.

2. Also, reports: what is the best way to generate them? When an employee
wants a list of all projects, they may need to be able to print them. I can
code it for page-breaks, headers etc.. and make it okay for printing but..
some reports may need to be landscape.. so therein lies the problem..
without prompting the user to change to landscape.. I read about using pdfs
but not sure how to create/write to one using dynamic data.. based on user
selection. I can't go out and buy all kinds of software but I can get Adobe
if required.. (professional?)

Thanks for any information/direction you may be able to give.

#1 There is nothing to set, Access is a multi-user database application and the .mdb is a multi-user
file structure.

Make sure the database is only being access directly from your ASP pages and not via Access at the
same time.

#2 Create all interaction with the database via ASP pages, and learn CSS to help control printing.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Cheryl" <(E-Mail Removed)> wrote in message news:uxt$(E-Mail Removed)...
> 1. I am not sure what to set on my website to allow multiuser access to my
> Access database. I am using a systemDSN. I don't use the Database wizard
> because I find it too limiting.. and use vbscript, asp and javascript. The
> website is a company intranet so depending on department, some can add,
> change,delete while others only get to view information. There is only 13
> users so Access should be adequate.
>
> 2. Also, reports: what is the best way to generate them? When an employee
> wants a list of all projects, they may need to be able to print them. I can
> code it for page-breaks, headers etc.. and make it okay for printing but..
> some reports may need to be landscape.. so therein lies the problem..
> without prompting the user to change to landscape.. I read about using pdfs
> but not sure how to create/write to one using dynamic data.. based on user
> selection. I can't go out and buy all kinds of software but I can get Adobe
> if required.. (professional?)
>
> Thanks for any information/direction you may be able to give.
>
>