When accessing Access 2003 with VB6 - Runs very slow

[DazzaMac]

I am in the process of upgrading our computer systems.

Several years ago I wrote a VB6 front end that connects to, reads and writes
to Access97 as its database using DAO 3.51

I have now upgraded the database from Access97 to Access2003 which initially
gave me connection problems as my VB6 code would not recognize an Access2003
database. I have since upgraded my VB6 references to use DAO 3.6 and my code
now works perfectly with Access 2003 just as it used to do with Access 97.

The only problem I now have is that it seems to run much slower when
selecting records from a table and the general operation is therefore much
slower.

What have I missed - is there some other updates I need to know about ?

Can anyone help me please ?

 

[Ever So Grateful]

Hi DazzaMac

I do not have the answers for u but I am wondering if u can help ...

I am experiencing similar problems after i installed ACCESS 2003.

I have updated my Project Reference to 'Microsoft Access 11.0 Object
library'
and also use DAO 3.6
I have changed the properties of the DATA controls in my vb6 form to the
following

Connect Access
Default type 2 - UseJet

when I run the form I get this error msg

"Unrecognized Database Format c:\..."

Would really appreciate any help on this ...

Too bad I know too little to be able to help u in return

Grateful
B

 

[DazzaMac]

Hi

Unfortuntately Data Grids dont appear to work with Access 2003 and I
received the same error message.

I have replaced all my Data Grids with Flex Grids instead which arent that
much more difficult to program with. These Flex grids work in just the same
way for displaying data and work perfectly with Access 2003.

 

[Ever So Grateful]

Wow ... I am delighted with such a prompt reply.

As it happens my earlier codings used Grid and my newer codings use
MsFlexGrid.
So I decided that it could be my DATA1 which was throwing out the message
before it even gets round to populating the Grid/MsFlexGrid.
So I wrote a new set of codes to test on a new 2003 database

again making sure the DATA1 control property is set for ACCESS and UseJet

General
Dim DB As Database
Dim ws As DAO.Workspace
Dim RS As DAO.Recordset
Dim dbpath As String


Private Sub Form_Load()

dbpath = "C:\report1\TEST2003.mdb"
Data1.DatabaseName = dbpath
Data1.RecordSource = "Select SuppName, SuppAddress1 from Supp order by
Suppname"
Data1.Refresh

Unfortunately .. I am getting the same error msg

Unrecognizable Database format 'c:\report1\test2003'

Will appreciate ANY suggestion

Thank u