Runtime Error 91

[tipster69]

I have a database that everytime I run it on my main pc I get a "Microsoft Visual Basic Runtime Error 91".

The same database runs fine on 3 different laptops I have.

It stopped doing it for a while after running a Kaspersky Virus scan then started again after a number of days.

I have tried running the virus scan again and it still gives me the error.

Any Ideas?

Many Thanks

 

[mp9]

Does Access have the same References set up on all the different PCs? In a VBA editing window within Access, click Tools, References to review this.

http://www22.brinkster.com/accessory/

 

[PHV]

And does the DB compiles properly .
menu Debug -> Compile ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tipster69]

I kinda just "scam" my way around access. I am no whizz with it by any stretch of the imagination.

I have no idea how to open a VBA editing window.

I have clicked debug and the compile option is greyed out?

 

[tipster69]

It also cause allsorts of other problems I forgot to mention.
I use a table (report) fromn the database to export as html to upload to our website.

I cannot do this from the pc (the one with the runtim error on)

It says' "cannot find the database on server".

I end up having to run it on a laptop and copy the html files across to the main pc.

It's all in all in a bit of a mess lol.

Thanks for your earlier replies guys.