Open Access MDB in-situ from a web page?
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
Re: Open Access MDB in-situ from a web page?
Quote:
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?
Re: Open Access MDB in-situ from a web page?
Quote:
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.
Re: Thank for the replies
Quote:
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..