Upload MS Access database to a website

Oracle · 20 Mar 2006 at 11:07

Guys, sorry to keep banging on about this. There has to be an easy way to do this that i'm missing.

It can be as totally bland as you like, but I just need to get my already created MS Access database into a webpage.

The page will be run from the PC (http://localhost) so i dont even need to 'upload it' so to speak!?

Please can someone help me, or point me in the direction of a tutorial...

Thanks

happytechie · 20 Mar 2006 at 11:41

in my copy of Access here, (2003) I have a wizard that will create a data access web page for me?

have you tried that?

HT

Oracle · 20 Mar 2006 at 11:46

thats what i'm looking for. I have access 2003

Where is the wizard?

Thanks

happytechie · 20 Mar 2006 at 11:57

on the pages bit, create data access page by using a wizard.

the page is a hideous IE only active X page but it WILL do what you want with 0 programming effort. Obviously an ASP.net page with propper datagrids linked to the OleDb connection to the database would be abetter solution but that will get you moving...

HT

Oracle · 20 Mar 2006 at 12:02

Found it. Thanks

Actinic for the win! lol

punky_munky · 20 Mar 2006 at 12:22

Assuming you're working in ASP you can use a simple DSNless connection string.

Code:

<%Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & server.MapPath("Sample_Database.mdb")%>