Redirect page to Microsoft Access database

[davepisarek]

I am looking for a quick and dirty way to create a hyperlink that will
open a Microsoft access database written in asp.

 

[Mark Rae]

I am looking for a quick and dirty way to create a hyperlink that will
open a Microsoft access database written in asp.

More information, please...

Presumably you don't expect to render an Access database in your web browser
the same way as you can with an Excel spreadsheet or a Word document, so
what do you actually mean...?

And what exactly do you mean by "a Microsoft Access database written in
ASP"...? How did you "write" an Access database in ASP Classic? Did you
instantiate ADO and / or MDAC, create a new database file, and then populate
its tables etc...?

 

[davepisarek]

More information, please...

Presumably you don't expect to render an Access database in your web browser
the same way as you can with an Excel spreadsheet or a Word document, so
what do you actually mean...?

And what exactly do you mean by "a Microsoft Access database written in
ASP"...? How did you "write" an Access database in ASP Classic? Did you
instantiate ADO and / or MDAC, create a new database file, and then populate
its tables etc...?

Sorry about the lack of information. The database was created in Access
and we would like to be able to place a link on a web site that will
call the database which would open in Access. I was told that this is
possible if you create a .lnk, i.e. databasename.mdb.lnk and create a
respond.redirect to that .lnk. If this is not possible just let me
know. I created a form in Access that opens first when the DB is opened.

 

[Mark Rae]

Sorry about the lack of information. The database was created in Access
and we would like to be able to place a link on a web site that will
call the database which would open in Access. I was told that this is
possible if you create a .lnk, i.e. databasename.mdb.lnk and create a
respond.redirect to that .lnk. If this is not possible just let me
know. I created a form in Access that opens first when the DB is opened.

Blimey! I can't imagine doing that, but never mind...

So, presumably this Access database is on a network share somewhere...?

Do you intend to download it to the local machine and run it from there, or
are you trying to run it over the network...?

 

[Rob]

I did somethign like this for our corporate Intranet where users could
add their own favourites, of which we also managed to get the following
to work:

Microsoft Word
Microsoft Excel
Microsoft FrontPage
Microsoft PowerPoint

but not Frontpage at that time - not sure if anyone has managed it
since...you call the app to execute then using the methods for it, open
a document - we didn't manage to get website opening in Frontpage
either come to think of it - at the end of the day it seemed like a
LOAD of hard work for us just to save some lazy people clicking on a
link on their desktop! )

Good luck though..

Rob

 

[davepisarek]

I did somethign like this for our corporate Intranet where users could
add their own favourites, of which we also managed to get the following
to work:

Microsoft Word
Microsoft Excel
Microsoft FrontPage
Microsoft PowerPoint

but not Frontpage at that time - not sure if anyone has managed it
since...you call the app to execute then using the methods for it, open
a document - we didn't manage to get website opening in Frontpage
either come to think of it - at the end of the day it seemed like a
LOAD of hard work for us just to save some lazy people clicking on a
link on their desktop! )

Good luck though..

Rob

Mark,

Eitherway is good. If this is a butt load of work then nevermind. The
easiest would be to have it run over the network so they would need to
store it locally but like I said if this is not easily accomplished it
is not worth it.