Web access to MS Access report building

[mkreach]

I'm just getting started with Microsoft Access, and I don't know if this is the right approach - please redirect me if necessary.
My department is interested in providing an online search application for our ODBC database, and I see that Access can read our database fine. My question is, is there a way to make a web page that allows a user to 1) pick the tables he or she wants to look at, 2) pick the variables he wants to see, 3) variables to sort on, 4) tests involving the variables, and 5) format the report? In short, a way to allow users on the web to be able to act as if they had Access installed themselves, to design and build their own reports. I don't mean to build all this stuff myself in VB or whatever, but rather is there a way to get Access to just present itself this way on the web?
Thanks very much

 

[dhookom]

I wouldn't attempt to do this with Access. You might be able to craft something with FrontPage and ASP or some other web development technology.

I have use GenericDb with some success

http://www.genericdb.com/default.asp.

I seem to recall issues connecting to this web site in the past but it seems to be up now.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[fneily]

is there a way to get Access to just present itself this way on the web?". Not without alot of work.
Mr. DHookom wouldn't attempt it with Access, but I would by creating Data Access Pages (DAP's) and coding with VBScript or JScript. ASP is incorporated in DAP'S along with XML. But, obviously, the choice is yours. Either way, it'll be alot of work.

 

[dhookom]

I haven't done anything with DAPs since my day job is web/database development where I use ASP and ColdFusion.

In addition to GenericDb, there is UTE

http://www.codeproject.com/asp/ute.asp

which seems similar. It has the ability to output records to a CSV file which can be opened with Excel and formatted for printing.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]