application cannot run modules on boxes without VB 1

[5166narda]

I have developed an access 2000 application that does some simple modules in VB. It works great on my box but when we delivered to a machine in Italy - it is getting errors trying to access the modules. Is there a trick to delivering an access database that runs VB modules to non-VB boxes?

 

[KenReay]

Hi

Does the PC in Italy have Access Installed ?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[5166narda]

It has access 97 installed

 

[KenReay]

Hi

well that is your problem, it needs Access2K, Access97 will not run an .mdb created by Access2K.

You MAY be able to save it in Access97 format from Access"k and get it to work, depends if you have used any Access"k specific features

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[5166narda]

I have converted it to access 97 which works except for the modules. Is there a way to compile these or make them functional on a box without VB?

 

[KenReay]

Hi

It has nothing to do with VB, it has to do with the fact you are trying to run a mdn developed in v2000 on a mchine with v97 on it.

Access is not different to most software it is backwards compatible (ie v2000 will run v97) but not forwards compatible. To be forwards compatible developers would have to be able to see into the future, now I know we are good, but forecasting the future is beyond even us

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Ed2020]

He's converted the database from Access 2000 back to Access 97.

Access isn't forwards compatible but you can create a 2000 DB and convert it back to 97.

My guess is the problem is reference related. DLLs in different locations maybe.....

Ed Metcalfe.

Please do not feed the trolls.....

 

[KenReay]

Hi

Ed2020 Yes, good point,

5166Narda - on the PC where it does not work, open any code module in design view, choose Tools\References and look for any which say MISSING, deselect them, but note the names, look down the list and reselect the relevant libraries (they may have slightly different versions eg Microsoft DAO3.6 rather than Microsoft DAO3.5)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[5166narda]

thanks much - that is what worked. I changed the dao and compiled and saved all modules and it seems to work fine.

thanks much

 

[Ed2020]

!!

lol

Please do not feed the trolls.....