Community discussion forum

Urgent Help pls!: Run Time Error 91 on Data Control

• • Reply

  1 year ago

  by okess

  okess

  , Nigeria

  Joined 1 year ago

  Hi,

  I have a program which runs on my laptop but when I place the .exe file on the network drive, it doesn't work on some terminal PCs. I have registered all the components needed for the program on the terminal PC but it didn't work. I have developed the program in VB6 using MS Access as the database.

  The first version of the .exe file was ok until I have made some updates placing a Data Control in the form. What it basically does is it binds the data I have declared on the flex grid. 

  Appreciate anyone's help please...

  Thanks!

  Report abuse
• • Reply

  1 year ago

  by Jugatsu

  Jugatsu

  , United Kingdom

  Joined 3 years ago

  Can you step through the code (F8) to find which line the error occurs.

   

  You can get this error by calling rs.RecordCount if the rs (recordset) is empty.

  You need to check this first....

  Report abuse
• • Reply

  1 year ago

  by okess

  okess

  , Nigeria

  Joined 1 year ago

  Thank you very much for your attention on this! 

  On my laptop where I programmed the application, it works so no errors whatsoever is experienced. But when I run the compiled exe file in the terminal PCs, that's where the error occurs. The only thing I added on the program is the Data1 or Data Control. Before I added that, the program works even in the terminal PCs.

  I would really appreciate if you can help me solve this. Thanks again!

  [quote user="Jugatsu"]

  Can you step through the code (F8) to find which line the error occurs.

   

  You can get this error by calling rs.RecordCount if the rs (recordset) is empty.

  You need to check this first....

  [/quote]
  Report abuse
• • Reply

  1 year ago

  by Jugatsu

  Jugatsu

  , United Kingdom

  Joined 3 years ago

  Does the data Control have database properties filled in.

  Is this location accessable for the other PCs.

  There may be an access issue, check your locations.

  Report abuse
• • Reply

  1 year ago

  by okess

  okess

  , Nigeria

  Joined 1 year ago

  MSFlexGrid's DataSource = Data1 (Standard Data Control. I'm not using the ADODC)

  Data1 is set to a Recordset.

  There are 50 to 60 terminal PCs who are using this program. I've tested the program using 3-5 from these PCs and none works. Then I've tested it using a colleagues' PC from another team but from our department and it works on his PC. But he is not going to use the program though.

  Report abuse
• • Reply

  1 year ago

  by incidentals

  Bill Stewart

  , United Kingdom

  Joined 2 years ago

  is your recordset set relative to the program or as an absolute address, and is that address in a formsat that can be accessed over the network.

  when making progs on our own machines it is often too easy to access things as the machines are opften more tollerant than the environment the program must eventually live in.

  I have a unix based web server and a development pc if I use the wrong case in a file name the pc will happily see it but when calling for it over the unix network the case must be identical.

  if it works on you machine and you can access machines over you network then i would suggest you start with the name and placement of the datafiles

  hope this helps

  Report abuse