Hey folks -

I have a site design with a form set up - I want to call information from a Microsoft Access Database - I Know, MySQl would probably be better - but I HAVE to use Microsoft access.

My question - What do I need to do (after the data and primary key is selected) to trigger my page that I designed to call forth that DB info? Any tuts involving Frontpage would be great - that's all we have here at work.

Thanks

Originally Posted by dziner

I Know, MySQl would probably be better

Not really.

Anyway, if you're using FrontPage and Access, it implies you're doing this for a Microsoft shop. Can you confirm they'll be using IIS? Do you know what version? Most importantly, you're using ASP.NET and not ASP Classic, right?

Originally Posted by Learning Newbie

Not really.

Anyway, if you're using FrontPage and Access, it implies you're doing this for a Microsoft shop. Can you confirm they'll be using IIS? Do you know what version? Most importantly, you're using ASP.NET and not ASP Classic, right?

It will be integrated with MS Sharepoint- not pleased about it - but thats really the only spec I know.

Hmmm. Sharepoint means IIS and ASP.NET, but that's most of what I know about SPS.

I think you'll need to do this with ASPx programming, probably with VB.NET or C# (your choice, really). I don't know the specific object model and events you need to tap into, tho.

reading data from and writing data to Access DBs is the same as reading and writing to any other ODBC source.

Just the ODBC/ADO driver used is different.

http://www.asp101.com/samples/ take a look at the database samples.