Question about ASP working with Access 98

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

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

Dave
 
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.
 
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.
 
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
 
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.
 
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.
 
Back
Top