473,326 Members | 2,147 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

ASP to Access 97 mdb under MDAC 2.8

MM
If I have a web site using ASP 3.0 and MS Access and hosted on a
server with MDAC 2.7/2.8 installed, does it make any difference
whether the mdb is an Access 97 one or an Access 2000 one? I only have
Access 97. The hosting company intimated that I should seriously
consider converting the mdb to Access 2000. Could I do that with ADO?
I have VB6.

MM
Nov 13 '05 #1
6 4288
MM
On Wed, 04 May 2005 17:58:20 +0100, MM <ky******@yahoo.co.uk> wrote:
If I have a web site using ASP 3.0 and MS Access and hosted on a
server with MDAC 2.7/2.8 installed, does it make any difference
whether the mdb is an Access 97 one or an Access 2000 one? I only have
Access 97. The hosting company intimated that I should seriously
consider converting the mdb to Access 2000. Could I do that with ADO?
I have VB6.


Ah, it looks like Visual Data Manager in VB6 might come to my aid
here. I can create a version 2.0 mdb, then import the Access 97
tables, probably. The mdb stores only tables, no code, no macros, no
queries. It is -just- a database. Has anyone tried converting this
way, using VisData/VB6?

MM
Nov 13 '05 #2
MM
On Wed, 04 May 2005 18:08:35 +0100, MM <ky******@yahoo.co.uk> wrote:
On Wed, 04 May 2005 17:58:20 +0100, MM <ky******@yahoo.co.uk> wrote:
If I have a web site using ASP 3.0 and MS Access and hosted on a
server with MDAC 2.7/2.8 installed, does it make any difference
whether the mdb is an Access 97 one or an Access 2000 one? I only have
Access 97. The hosting company intimated that I should seriously
consider converting the mdb to Access 2000. Could I do that with ADO?
I have VB6.


Ah, it looks like Visual Data Manager in VB6 might come to my aid
here. I can create a version 2.0 mdb, then import the Access 97
tables, probably. The mdb stores only tables, no code, no macros, no
queries. It is -just- a database. Has anyone tried converting this
way, using VisData/VB6?


Oops! That version 2.0 malarkey, they don't mean Access 2000, do they!
I'd forgotten all about Access 2.0. Oh well, back to the drawing
board. Has anyone written a utility to convert 97 to 2K?

MM
Nov 13 '05 #3
MM
On Wed, 04 May 2005 18:13:02 +0100, MM <ky******@yahoo.co.uk> wrote:
On Wed, 04 May 2005 18:08:35 +0100, MM <ky******@yahoo.co.uk> wrote:
On Wed, 04 May 2005 17:58:20 +0100, MM <ky******@yahoo.co.uk> wrote:
If I have a web site using ASP 3.0 and MS Access and hosted on a
server with MDAC 2.7/2.8 installed, does it make any difference
whether the mdb is an Access 97 one or an Access 2000 one? I only have
Access 97. The hosting company intimated that I should seriously
consider converting the mdb to Access 2000. Could I do that with ADO?
I have VB6.


Ah, it looks like Visual Data Manager in VB6 might come to my aid
here. I can create a version 2.0 mdb, then import the Access 97
tables, probably. The mdb stores only tables, no code, no macros, no
queries. It is -just- a database. Has anyone tried converting this
way, using VisData/VB6?


Oops! That version 2.0 malarkey, they don't mean Access 2000, do they!
I'd forgotten all about Access 2.0. Oh well, back to the drawing
board. Has anyone written a utility to convert 97 to 2K?


Fixed it! I referred to Larry Rebich's article "DAO 3.60 and Jet 4 -
July 1999 and December 2000" to create an Access 2000 mdb in VB6.
http://www.buygold.net/v02n12/v02n12.html

Then I followed the mods in:
How To Modify the Visual Data Manager (VISDATA) to Work with Access
2000 Databases
KB Q252438

Finally, I recompiled visdata, opened a newly created Access 2000 mdb,
and imported the tables from my Access 97 mdb.

MM
Nov 13 '05 #4
MM <ky******@yahoo.co.uk> wrote in
news:cf********************************@4ax.com:
If I have a web site using ASP 3.0 and MS Access and hosted on a
server with MDAC 2.7/2.8 installed, does it make any difference
whether the mdb is an Access 97 one or an Access 2000 one? I only
have Access 97. The hosting company intimated that I should
seriously consider converting the mdb to Access 2000. Could I do
that with ADO? I have VB6.


Your ISP is run by ignorant people.

If the MDAC installation is Jet 4, it can deal perfectly well with a
Jet 3.5 database (an Access database is a special kind of Jet
database with objects of its own that Jet itself knows nothing
about; on a website using ASP, you're not using any of the Access
properties of the MDB, so you're not really using an "Access"
database at all, just a Jet db).

You don't have any need to convert the db to Jet 3.5.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #5
MM
On Thu, 05 May 2005 00:41:11 GMT, "David W. Fenton"
<dX********@bway.net.invalid> wrote:
MM <ky******@yahoo.co.uk> wrote in
news:cf********************************@4ax.com :
If I have a web site using ASP 3.0 and MS Access and hosted on a
server with MDAC 2.7/2.8 installed, does it make any difference
whether the mdb is an Access 97 one or an Access 2000 one? I only
have Access 97. The hosting company intimated that I should
seriously consider converting the mdb to Access 2000. Could I do
that with ADO? I have VB6.


Your ISP is run by ignorant people.

If the MDAC installation is Jet 4, it can deal perfectly well with a
Jet 3.5 database (an Access database is a special kind of Jet
database with objects of its own that Jet itself knows nothing
about; on a website using ASP, you're not using any of the Access
properties of the MDB, so you're not really using an "Access"
database at all, just a Jet db).

You don't have any need to convert the db to Jet 3.5.


Thanks, David. The current Access 97 mdb works fine on Brinkster,
using the Jet.OLEDB.4.0 provider. The bloke reckoned there were 'big
locking issues' with Access 97, but I have used it to build and
maintain many databases for years without any trouble.

MM
Nov 13 '05 #6
MM <ky******@yahoo.co.uk> wrote in
news:n4********************************@4ax.com:
On Thu, 05 May 2005 00:41:11 GMT, "David W. Fenton"
<dX********@bway.net.invalid> wrote:
MM <ky******@yahoo.co.uk> wrote in
news:cf********************************@4ax.co m:
If I have a web site using ASP 3.0 and MS Access and hosted on a
server with MDAC 2.7/2.8 installed, does it make any difference
whether the mdb is an Access 97 one or an Access 2000 one? I
only have Access 97. The hosting company intimated that I should
seriously consider converting the mdb to Access 2000. Could I do
that with ADO? I have VB6.
Your ISP is run by ignorant people.

If the MDAC installation is Jet 4, it can deal perfectly well with
a Jet 3.5 database (an Access database is a special kind of Jet
database with objects of its own that Jet itself knows nothing
about; on a website using ASP, you're not using any of the Access
properties of the MDB, so you're not really using an "Access"
database at all, just a Jet db).

You don't have any need to convert the db to Jet 3.5.


Thanks, David. The current Access 97 mdb works fine on Brinkster,
using the Jet.OLEDB.4.0 provider. The bloke reckoned there were
'big locking issues' with Access 97, . . .


Why in the world should there be any at all? Jet 4 record locking is
a joke and nobody that I know actually uses it (it adds so much
overhead that it drags everything to a halt).

Jet 4 and Jet 3.5 are really pretty much identical in real-world
usage in regard to record-locking issues, even if Jet 4 is supposed
to be improved in that regard.
. . . but I have used it to build and
maintain many databases for years without any trouble.


ISP's generally know absolutely zilch about Access and Jet. The hard
part is convincing them of their ignorance, something of a
delicately diplomatic task.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: ErickR | last post by:
We are experiencing a problem with Sql Server 2000 linking to an Access 97 file. We have two machines that link to this .mdb file, and we recently upgraded one to newer hardware, SP3a, MDAC 2.8,...
1
by: Steph | last post by:
Hi Everyone! Hope someone has some ideas...here's my problem: 1) Have an Access 2000 database front end to a SQL Server 2000 database. 2) It used to work fine on all company PCs. The PCs had...
9
by: Tony Lee | last post by:
Some time a ago, on this newsgroup the following comments were made in recommending good references for Access (2003) >I used to recommend Dr. Rick Dobson's, "Programming Access <version>" for...
9
by: Nick | last post by:
Hi, We're are about to develop an app in C# that will use a MS Access database file for data storage. The db structure will not be modified. The user will use the C# developed app to view and...
8
by: Luminal | last post by:
Greetings Recently I've developed a C# application using an Access database. For this I use the Data.OleDb namespace. Now I have customer telling me that he can't use the application. The...
0
by: ASP.Confused | last post by:
The old message looked a little stale, so I am re-posting it here. Anybody have any ideas of what I could do?!? The previous responses to this question are below. If you want to look at the...
1
by: James | last post by:
I have a VB windows forms application that accesses a Microsoft Access database that has been secured using user-level security. The application is being deployed using No-Touch deployment. The...
2
by: Jan Krouwer | last post by:
Let me rephrase a question for which I received no answer. I thought dotnet requires MDAC 2.6 or later for data access. I have a dotnet Windows app that uses Access. It won't run on Windows 98...
10
by: BobAchgill | last post by:
What is the best way to get data from an MDB (Access) file into a Win Form? And is there a way to do this but not have to install the H-U-G-E MDAC? (Note: My target users are on Windows 2000...
0
by: =?Utf-8?B?QnJhaW5SYWNraW4=?= | last post by:
The following error occurs trying to open my Access database with ASP.NET app: The .Net Data OLE DB Provider(System.Data.OleDb) requires Microsoft Data Access Components(MDAC). Please install...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.