General discussion

Locked

Access 2000:Report Only On An Intranet

By sowhatsowhat ·
How do I get a query based report on our intranet, without each person having to open the entire database or having access to the database? The report is set up to search 2 fields in the database that asks for a specific dept.# and the start and enddate then the report returns the results based on the user's input. The # of users for this report will be over 100. The ideal outcome is to select the option to search, enter your info. and just receive the results in the report format without having to have the DB open on their computer and/or even have Access on their computer. We are not running SQL server.

This conversation is currently closed to new comments.

10 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access 2000:Report Only On An Intranet

by MelodyJ In reply to Access 2000:Report Only O ...

Hopefully you have IIS somewhere in the house... If so, you can save an Access query to HTML. Just look up information on the "Publish to the Web Wizard" in access. Also, this page may be of help... http://msdn.microsoft.com/library/techart/DeployDAP.htm

Regards,
Melody

Collapse -

Access 2000:Report Only On An Intranet

by sowhatsowhat In reply to Access 2000:Report Only O ...

Poster rated this answer

Collapse -

Access 2000:Report Only On An Intranet

by kirya In reply to Access 2000:Report Only O ...

You can export Tables and forms to ASP using File\Export. You can make a pair of ASP pages by yourself to query your database (www.learnasp.com). And then publish them on intranet website with IIS (on NT/2000 Server) or PWS (win98/95). Also you can try ASPDataBase(www.aspdatabasecom), wich must be easier to use ( I haven't tried it yet).

Collapse -

Access 2000:Report Only On An Intranet

by kirya In reply to Access 2000:Report Only O ...

Sorry, it's not AspDataBase, it's ASPDB (www.aspdb.com)

Collapse -

Access 2000:Report Only On An Intranet

by sowhatsowhat In reply to Access 2000:Report Only O ...

Poster rated this answer

Collapse -

Access 2000:Report Only On An Intranet

by nicholasP In reply to Access 2000:Report Only O ...

More info will be needed, but this can be done using ASP.

You will open the database using ODBC connectivity and then run the query.

Let me know if you have questions

Collapse -

Access 2000:Report Only On An Intranet

by sowhatsowhat In reply to Access 2000:Report Only O ...

The question was auto-closed by TechRepublic

Collapse -

Access 2000:Report Only On An Intranet

by PrinterManager In reply to Access 2000:Report Only O ...
Collapse -

Access 2000:Report Only On An Intranet

by sowhatsowhat In reply to Access 2000:Report Only O ...

The question was auto-closed by TechRepublic

Collapse -

Access 2000:Report Only On An Intranet

by sowhatsowhat In reply to Access 2000:Report Only O ...

This question was auto closed due to inactivity

Back to Software Forum
10 total posts (Page 1 of 1)  

Related Discussions

Related Forums