Unable to see records bound to ADO data control in my exe. file

[stars04]

I have developed an application that has MSAccess database as backend and VB6.0 as front-end, made it an exe file and also created setup file using Inno Setup 4.
Firstly, using the exe file on the users machine, I am able to retrieve records or search records, save records. However all the forms that has MSHierarchicalFlex grid or a data bound control whose data source is the ADO data control does not display the records.
I have used Microsoft Activex Data Objects 2.5 Library and the components used are Microsoft ADO Data control 6.0(OLEDB), Microsft DataList Control 6.0, Microsoft Hierarchical FlexGrid Control 6.0 (SP3)(OLEDB)
The machine I work is XP, does this matter? I urgently need help. And this application needs to be used by around 10 users.
Secondly, since this application is to used in a multiuser environment, I have field which is a auto generated sequence number. But when 2 or more users retrieve the next number they get same numbers on their machines which will result into update failure. Currently I use Adopendynaset and Pessimistic locks but somehow doesnot work fine it still gives me same number on different machines.

 

[bdavis96]

Did you make sure that the other computers were running the same mdac version as your computer is running. If that doesn't fix it, take your Exe that is working on your computer, and use it to overwrite the Exe on the other computers. I tried that once when I was trying to make my Exe work on other computers, which I was using the VB installer.