Question about ASP working with Access 98

[Dave]

I'm thinking about pulling information from Access 98 database via ASP. Is
there any limitation to achieving this goal?

Dave

 

[Douglas J. Steele]

Could be interesting, given that there never was an Access 98...

Your question is a little too vague, though, to be able to provide any
answer.

 

[Brendan Reynolds]

Well, as Doug says elsewhere in this thread, there is no Access 98, and
there are limitations to everything. But you can certainly access (no pun
intended) data in a JET (MDB) database using ASP or ASP.NET. Whether a JET
database is the optimal solution for any specific application is a much more
complex question. Will this be a high-traffic web site? Do you need 24-7
availability? How stringent are your security and data protection
requirements, etc., etc.

 

[Dave]

Ahem, I uh, meant to say Access '97.
There will be no vital information. No plans for high traffic so I know
Access should be able to handle the demand. It would be a 24-7 site.
I have worked with setting up an Access 2000 DB with ASP. But I don't know
if Access '97 would work with ASP.
I will not be using ASP.NET.

Dave

 

[Douglas J. Steele]

I've use Access 97 and ASP without any problems in the past.

Since ASP uses ADO to communicate, you might use
Provider=Microsoft.Jet.OLEDB.3.51;, rather than
Provider=Microsoft.Jet.OLEDB.4.0;, but other than that, everything should
work the same.

 

[Brendan Reynolds]

The 24-7 requirement is a potential problem, as you'll need to take the site
off-line for any maintenance, such as running a compact and repair.

I think the best advice I can offer is to try it and see, but perhaps start
investigating the possibility of transferring the data to SQL Server, so
that you'll be prepared if/when that becomes necessary.