Data shows on my computer but not on others.

[kaeld]

Hello all,

I've been working on a project that displays data from a Data Environment object which connects to a few different Access databases. Everything works fine on my computer, but when I try it out on another computer, none of the data loads for one (and only one) of the forms. Does anybody know any possible reason for this to happen?

The only difference between the data on this form and the others is that I was using data shaping, but I re-configured things to avoid data shaping and the problem is still there.

Kael

 

[PGoRule]

Can you post the code?

Sharing the best from my side...

--Prashant--

 

[kaeld]

This really isn't a code heavy problem. There was no meaningful code in the form when I was using datashaping, and now there's just a filter statement to make it work as if I had used datashaping.

The form contains some text boxes containing information from one table-type command from the data environment, and a datagrid containing information from an SQL command from the data environment. Nothing fancy. Both commands use client-side and static cursors, with the table command using optimistic locking, and the SQL read-only. The connection that these commands are working under uses Jet 4.0 to connect to an Access Database, with client-side cursors again.

There's not much else I can tell you. Nothing fancy is going on. I think that there may be some system files or something like that that are missing, although no errors come up. The computers that it doesn't work on do not have VB 6 on them, but other VB 6 programs work on them.

Thanks for reading this too-long post,

Kael

 

[JoeAtWork]

Maybe a permissions issue to the folder where the Access database is located? Are you logged in to the network as the same user on the computer that doesn't work as you are when on your development machine?

Are you installing the application on the client machines with setup files created with Package & Deployment Wizard? That should install all the required files.

 

[kaeld]

The network account that needs to access this program is not mine, but the problem occurs on my account as well. The data only has trouble loading for one of the forms, so I doubt that there can be any permission issues.

The program is stored on a common drive that can be accessed by any user in my department. There is no installation required/available with the current set-up.

What is this Package & Deployment Wizard? I'm relatively new to VB, and I have not heard of this before.

Kael

 

[PGoRule]

This could be a problem with MDAC version on those particular machines.
One more thing, as this package is not installed using package setup and Visual Basic is not installed on those machines, probably Visual basic runtime environment may be missing on those machines...
Check these factors as well...

Sharing the best from my side...

--Prashant--

 

[kaeld]

The latest version of MDAC has been installed on the machine in question in order to try to fix this problem, to no avail. Would it be possible to run Visual Basic programs without the Visual Basic Runtime Environment? The computer in question has Microsoft Access on it, hence it has VBA, so it would be ridiculous for it not to have the runtime environment.

Kael

 

[JoeAtWork]

You should find the Package & Deployment Wizard in Start -> Microfot Visual Basic 6.0 -> Microfot Visual Basic 6.0 Tools. When you start it, you choose a .VBP project file then click the Package button. The Wizard should be rather intuitive. At the end you get a setup package which includes a .CAB file with all required components that the program depends on.

I'm not positive, but I'm pretty sure that VBA does not use the VB6 runtime. However, it could be one of the other components you are missing.

 

[BobRodes]

I would be very careful standardizing around the P&D wizard. The problems associated with it are well-documented on this forum. Other oft-recommended alternatives are the Visual Studio Installer, and INNO setup. I personally use the former, despite its warts.

Bob

 

[PGoRule]

Yeah...I agree on the part of installation of Visual Studio on the machine. But sometimes it's not possible due to some issues. So it's better to go through packaging, create setup for your application which carries VB6 runtime and other required components necessory to run that application.

Sharing the best from my side...

--Prashant--

 

[strongm]

>The latest version of MDAC ...

May not fix it as it no longer contains (as of MDAC 2.6) the Jet components, which are available as a seperate download. Here's a lot to read on the subject, with links to downloadable components:

http://support.microsoft.com/kb/239114/