2 questions -frontpage 2003 and access - multiuser and report generation

[Cheryl]

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.

 

[Thomas A. Rowe]

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

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================