Local db access

I have an ASP application running on my server in which several users
subscribe to. Each user has their own directory and their own Access
database. Each user can download their own database to their local machine
for backup purposes.

Im looking for a Windows app or something I can script, that would allow the
user to view tables from the local database file in case they cannot get to
my server or their internet connection is down.

Preferably there would be some kind of pre-written query which would pull
the db results into a structured HTML page or text file rather than just
dumping the raw database table as is. Something like an Access Report
without the need for the user to have Access installed.

Is there a pre-existing app that can do this or any suggestions on how I can
go about this?

Thanks!

Re: Local db access

"Targa" wrote in message
news:#2OeAmv2EHA.3820@TK2MSFTNGP11.phx.gbl...
> I have an ASP application running on my server in which several users
> subscribe to. Each user has their own directory and their own Access
> database. Each user can download their own database to their local machine
> for backup purposes.
>
> Im looking for a Windows app or something I can script, that would allow
the
> user to view tables from the local database file in case they cannot get
to
> my server or their internet connection is down.
>
> Preferably there would be some kind of pre-written query which would pull
> the db results into a structured HTML page or text file rather than just
> dumping the raw database table as is. Something like an Access Report
> without the need for the user to have Access installed.
>
> Is there a pre-existing app that can do this or any suggestions on how I
can
> go about this?
>
> Thanks!

I gather that you don't want to allow them to update the database while
offline as it may not be the most current version.

You can use ADO in a VBS (or HTA) file to access a local database. The HTA
allows you to provide a UI beyond InputBox().

Re: Local db access

Correct - no need to update. Just ability to view.

Thanks!

> I gather that you don't want to allow them to update the database while
> offline as it may not be the most current version.
>
> You can use ADO in a VBS (or HTA) file to access a local database. The
> HTA
> allows you to provide a UI beyond InputBox().
>
>