Open Access MDB in-situ from a web page?

[DaveBo]

Is it possible from a web page (ASP?) to open a Microsoft Access MDB file on the server, e.g. to utilize its switchboard and/or forms?

When I try it makes a local copy of the MDB, i.e. from the server onto the local user PC, but I don't want to be copying all the data/tables.

Thanks, DaveBo

[Danial]

Originally posted by DaveBo
Is it possible from a web page (ASP?) to open a Microsoft Access MDB file on the server, e.g. to utilize its switchboard and/or forms?

When I try it makes a local copy of the MDB, i.e. from the server onto the local user PC, but I don't want to be copying all the data/tables.

Thanks, DaveBo

If the MDB file is in the same server/mache as the asp file then you can use ADO to read/write records from the MDB.

Your post is not clear, what are you trying to copy?

[mendhak]

Originally posted by DaveBo
to utilize its switchboard and/or forms?

No. Unless you make the user download the MDB to their machines and then open it.

[DaveBo]

Just to clarify:

What I'm trying to do is open the MDB file right where it is and use it as GUI without copying the whole thing over the intranet.

We have many small apps written using Access, containing various sets of data and forms/reports etc. We'd like to provide users on our intranet a common access point into these via their browsers and not have to reinvent each form/report/query etc.

i.e. provide a web page with links to the various Access DBs.

Thanks, DaveBo

[Danial]

Originally posted by DaveBo
Just to clarify:

What I'm trying to do is open the MDB file right where it is and use it as GUI without copying the whole thing over the intranet.

We have many small apps written using Access, containing various sets of data and forms/reports etc. We'd like to provide users on our intranet a common access point into these via their browsers and not have to reinvent each form/report/query etc.

i.e. provide a web page with links to the various Access DBs.

Thanks, DaveBo

As far as i know, that cant be done. Though i remember seeing something like web form in Access. Try the VBA forum, they might know..

[Ecniv]

Isn't that what Asp/IIS, Mdb, CSS and html/javascript is for?
Oh and loadsa money to learn and utilise said apps for the companies benefit...


Vince

[DaveBo]

I can fire up MS Access on the local/client PC from an asp on the server by just using
C:\Program Files\Microsoft Office\Office\MSACCESS.EXE
as a hyperlink URL

and then I can manually select the remote .MDB file from Access' opening dialog.

But, I can't fire up Access and pass the MDB in as an arg to come up automatically.

Any ideas? Can I somehow do a VBscript Shell on the client side to start Access locally and give it the remote DB filename?

Thanks, DaveBo

[Danial]

Only thing i can think of is using an ActiveX control, embed that in a web page and then download the file to the client machine and then execute it.

Note that it will only work in IE and the User will have to allow the ActiveX to be be downloaded and run.

For secerity reason you wont be able to Shell from a HTML page, or you could do all sort of things!