DBGrid32.ocx always retuns empty...

I've written a program to look through the content of *.MDB tables without Access, based on DBGrid32.ocx. Unfortunately, after successful installation, on some win'98 machines dbgrid form always retuns empty content without any error... I wish I know how to fix this strange behaviour of standard MS component. MDAC & JET are installed everywhere...
TIA
igorgAsked:
Who is Participating?
 
SpideyModCommented:
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0
 
gronCommented:
Show us some code.
A DBgrid is always bound to your data through an underlying recordset that you must create with an SQL statement or a Data Control, but you mention neither of these.
0
 
igorgAuthor Commented:
First, my settings for Data1 component in design view:
--------------
Connect=Access 2000;
DefaultCursorType=0-DefaultCursor
DefaultType=2-UseJet
--------------
My VB code follows:
-----
Set dbz = Workspaces(0).OpenDatabase(App.Path & "\" & DBName, False, False, PWDStr)
Set Me.Data1.Recordset = dbz.OpenRecordset(TableName, dbOpenSnapshot)
Me.Data1.Refresh
Me.DBGrid1.Refresh
-------

I guess the reason of notworking my code on some machines is in absense (or different version) of some DLL, which is not included by Package and Deployment Wizard.
Yesterday I tested my code on clean Win98SE machine. Installing DCOM98,MDAC 2.52,Jet4, VB6Runtime SP3 - changed nothing. Reinstalling my prog setup - again cased no positive results.
Only after a few seconds of VB6 setup (which was still in progress), the DBgrid started to work normally.
0
 
DanRollinsCommented:
Hi igorg,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Refund points and save as a 0-pt PAQ.

igorg, Please DO NOT accept this comment as an answer.
EXPERTS: Post a comment if you are certain that an expert deserves credit.  Explain why.
==========
DanRollins -- EE database cleanup volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.