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 6 4288
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
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
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
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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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,...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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)...
|
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...
|
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....
|
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
|
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...
| |