I created a form using Access 2003 and VB (6.3) in a network shared folder on PC #1.

I have Access 2000 on PC #2.

From PC #2 I can browse to and Open the remote mdb file and the Access Database and Form are displayed in Access 2000.  When I launch the Form, it comes up OK, but when I select an item in a combobox, I get the following error:
Microsoft Visual Basic
Compile Error:
Method or data member not found
[OK]   [Help]

When I click on OK,
the debugger lands on a listbox.AddItem() call.

I am guessing that something is out-of-wack with the version of VB but do not know how to fix it.

The remote PC VB version indicates 6.0.
I downloaded and ran the Visual Basic 6.0 SP5: Run-Time Redistribution Pack (VBRun60sp5.exe) but that didn't help.

UPDATE:
I compared the References between the 2 VBA's and found that the Office 2003 PC has
Microsoft Access 11.0 Object Library
and the Office 2000 PC has
Microsoft Access 9.0 Object Library

I am guessing this might be it....
Does anyone know if Office 2000 can be updated with the 11.0 Object Library.

I am hoping that I don't have to buy a new Office 2003 license since this Access db is the only application that has a problem with office 2000 if my suspicion is corrrect.

HELP !!!




I appreciate any assistance.

- Bill


[Edited by ba1959nh on 26-05-2006 at 12:28 AM GMT]

Hi,
As far as I am aware:
Access 2003 adds loads of functionality to the form, that access 2000 doesn't know how to handle. You will either have to develop your db in access 2000, or buy 2003 for all client machines.
Incidentally, why are you using an access form in a vb app? If your form is in VB, then you will need the latest version of MDAC from microsoft.

Regards,
Kieron


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)

stickleprojects .....

thanks for the response.

Regrettably, you are right about the functionality differences between Access 2000 and 2003. I could write my own AddItem routine but that would be too counterproductive. I guess I am going to bite the bullet and update access so all the machines have Access 2003.

As far as using VB forms in Access....
I guess I am using VBA (launched from the Access Forms editor). I thought it was VB because Help - About indicates Visual Basic 6.3, but in the fine print I see VBA Retail: 6.4.8869.

This is my first Access project.

Thanks for your help.





I sure don't feel like a big cheese.



[Edited by ba1959nh on 26-05-2006 at 12:19 PM GMT]