|
 |
asp_databases thread: Microsoft Access Driver
Message #1 by "Rod Aubertin" <webmstr@r...> on Wed, 24 May 2000 21:0:6
|
|
I am using Access 2000 Databases for data access, but the only driver I can
seem to find is for Access 97.
Do I have to keep all my Access Databases in 97?
I use FP 2000 to design my database results, along with some coding done by
an html editor.
Rod Aubertin
webmstr@r...
Message #2 by "Ken Schaefer" <ken.s@a...> on Thu, 25 May 2000 10:53:40 +1000
|
|
goto: http://www.microsoft.com/data and download MDAC v2.5 (or MDAC v2.1
SP2) and this will update your drivers, eg you get access to OLEDB v4 which
supports Access 2000.
If you're using InterDev also install SP3, which provides support for MDAC
v2.1 SP2 +
Cheers
Ken
----- Original Message -----
From: "Rod Aubertin"
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, May 24, 2000 12:00 AM
Subject: [asp_databases] Microsoft Access Driver
> I am using Access 2000 Databases for data access, but the only driver I
can
> seem to find is for Access 97.
>
> Do I have to keep all my Access Databases in 97?
>
> I use FP 2000 to design my database results, along with some coding done
by
> an html editor.
>
> Rod Aubertin
> webmstr@r...
Message #3 by <frontfoot@y...> on Wed, 24 May 2000 22:23:32 -0500
|
|
I use Win2k pro
My MDB driver I use with Access 2000 is
version 4.00.4403.02 file ODBCJT32.dll 12/7/1999
check out mdac section for downloads
http://www.microsoft.com/data/download.htm
mj
-----Original Message-----
From: Rod Aubertin []
Sent: Wednesday, May 24, 2000 12:00 AM
To: ASP Databases
Subject: [asp_databases] Microsoft Access Driver
I am using Access 2000 Databases for data access, but the only driver I can
seem to find is for Access 97.
Do I have to keep all my Access Databases in 97?
I use FP 2000 to design my database results, along with some coding done by
an html editor.
Rod Aubertin
webmstr@r...
Message #4 by "Darryl W. Dison" <DarrylD@k...> on Wed, 24 May 2000 23:34:54 -0400
|
|
One option you could look at would be using the Frontpage folder for data
access, this eliminates the problem of needing a DSN. The new jet drivers
should have been installed with FP2000 so the Microsoft Access database
Engine should support the 2000 databases. You would then have to use the
server DSN to point to the database.
-----Original Message-----
From: Rod Aubertin
Sent: Tuesday, May 23, 2000 8:00 PM
To: ASP Databases
Subject: [asp_databases] Microsoft Access Driver
I am using Access 2000 Databases for data access, but the only driver I can
seem to find is for Access 97.
Do I have to keep all my Access Databases in 97?
I use FP 2000 to design my database results, along with some coding done by
an html editor.
Rod Aubertin
webmstr@r...
Message #5 by "Robert Larsson" <robert.l@m...> on Thu, 25 May 2000 10:04:43 -0700
|
|
I believe so, but why don't you download the latest MDAC from Microsoft's
website ?
Mvh,
Robert Larsson!
Web-production Coordinator
---------------------------------------------------------------------
Mindflow AB | www.mindflow.se | 08-545 635 10
----- Original Message -----
From: "Rod Aubertin"
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, May 24, 2000 12:00 AM
Subject: [asp_databases] Microsoft Access Driver
> I am using Access 2000 Databases for data access, but the only driver I
can
> seem to find is for Access 97.
>
> Do I have to keep all my Access Databases in 97?
>
> I use FP 2000 to design my database results, along with some coding done
by
> an html editor.
>
> Rod Aubertin
> webmstr@r...
>
Message #6 by "Velzen, Marvin van" <MVE@e...> on Thu, 25 May 2000 16:34:29 +0200
|
|
Or you use a ado connection string like :
<%
dim objCon, objRst
set objCon =server.createobject("ADODB.connection")
objCon.open "provider=Microsoft.Jet.OLEDB.4.0;" & _
" data source=d:\Kantinemenu\kantinemenu.mdb"
sql = "select * from menu"
set objRst=objCon.Execute(sql)
%>
<Table>
<TR>
<TD>Diverse Salades</TD>
<TD></TD>
<TD>
<%
Response.Write ObjRst("salade1").value
Response.Write "<BR>"
Response.Write ObjRst("salade2").value
Response.Write "<BR>"
Response.Write ObjRst("salade3").value
%>
</TD></TR>
<TR>
</Table>
-----Original Message-----
From: Darryl W. Dison
Sent: donderdag 25 mei 2000 5:35
To: ASP Databases
Subject: [asp_databases] RE: Microsoft Access Driver
One option you could look at would be using the Frontpage folder for data
access, this eliminates the problem of needing a DSN. The new jet drivers
should have been installed with FP2000 so the Microsoft Access database
Engine should support the 2000 databases. You would then have to use the
server DSN to point to the database.
-----Original Message-----
From: Rod Aubertin
Sent: Tuesday, May 23, 2000 8:00 PM
To: ASP Databases
Subject: [asp_databases] Microsoft Access Driver
I am using Access 2000 Databases for data access, but the only driver I can
seem to find is for Access 97.
Do I have to keep all my Access Databases in 97?
I use FP 2000 to design my database results, along with some coding done by
an html editor.
Rod Aubertin
webmstr@r...
|
|
|
View Cart
