Recordsets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gavin Sharp - 29 Dec 2003 21:15 GMT

Hi All,

Before I start I wish you all a very happy and successful 2004.

I'm using access DB's for storing info in my apps. I open them using a
connection & recordset procedure. Normal stuff

cn.ConnectionString = "provider=Microsoft.Jet.OLEDB.3.51;data source=C:\Main
Files\Programs\Playout Scheduler\Data\CDLib.mdb;"
cn.open
rs.addnew

etc. etc

However, I can only seem to open Access 95 files with my connection string.
Had a look at to what might be causing it but have yet to find a way of
opening Access 2002 files.

Any Ideas?

Many Thanks

Gavin.

Reply to this Message

Frank Adam - 29 Dec 2003 22:04 GMT

>Hi All,
>
>Before I start I wish you all a very happy and successful 2004.

And a good one to you and family.

>However, I can only seem to open Access 95 files with my connection string.
>Had a look at to what might be causing it but have yet to find a way of
>opening Access 2002 files.
>Any Ideas?

Yeah, on the MS site there is an upgrade for VB that includes the
latest DAO/ADO and MDAC. I'm not sure anymore what it was called, but
have a good look in the VB downloads, or updates sections.
I'm also not sure if it'll work with AC2002 files, but will certainly
work with the 2K ones.

I belive these were the files that did that, so try searching the MS
site for them.:
Jet40Sp3_Comp.exe (perhaps there is a sp4 for 2002 ?)
MDAC_TYP.EXE or MDAC_TYP2.7.EXE (for whatever reason i have two of
those, that look identical, yet with different names)

Signature

Regards, Frank

Reply to this Message

Frank Adam - 29 Dec 2003 22:15 GMT

>I belive these were the files that did that, so try searching the MS
>site for them.:
>Jet40Sp3_Comp.exe (perhaps there is a sp4 for 2002 ?)
>MDAC_TYP.EXE or MDAC_TYP2.7.EXE (for whatever reason i have two of
>those, that look identical, yet with different names)

Whoa, i did the search myself, invoice is in the mail. :-)

We're talking Jet4.0 SP8 now and SP3 has been "retired" ! Good one MS,
that's a nice way to say "we've had to plug so many holes in the data
access libraries that it completely stuffed JetSp3, so we had to shoot
it". ;-)

Anyhow, have a good read through this place, MDAC2.8 is also out and
the Jet pack is somewhere about 3/4 way down in the list.
http://msdn.microsoft.com/library/default.asp?url=/downloads/list/dataaccess.asp

ps: i remember that there is also a writeup somewhere on how and what
to modify in Visdata so it can also read/create 2k files. In case you
do use VisData that is.

Signature

Regards, Frank

Reply to this Message

William - 31 Dec 2003 01:24 GMT

Before you got out and download please visit this site:
http://support.microsoft.com/default.aspx?scid=kb;en-us;821373

Backwards compatibility has been broken in some instances due to the amount of
security enhancements done with this new version.

SP3 for jet has been retired because of the Java lawsuit with Sun
MicroNoBrains. As well SP5 for VS is also slated for retirement because of
this.

Will

>>I belive these were the files that did that, so try searching the MS
>>site for them.:
[quoted text clipped - 16 lines]
>to modify in Visdata so it can also read/create 2k files. In case you
>do use VisData that is.

Reply to this Message

Gavin Sharp - 30 Dec 2003 15:45 GMT

> Yeah, on the MS site there is an upgrade for VB that includes the
> latest DAO/ADO and MDAC. I'm not sure anymore what it was called, but
> have a good look in the VB downloads, or updates sections.
> I'm also not sure if it'll work with AC2002 files, but will certainly
> work with the 2K ones.

Works fine with both AC2002 and AC2K files!!.

>the Jet pack is somewhere about 3/4 way down in the list.
>http://msdn.microsoft.com/library/default.asp?url=/downloads/list/dataacces

s.asp

Cheers Frank.

Gav.

Reply to this Message

VB Forum / General 2 / December 2003

Recordsets