anyone know what err 3134 is ???

[iono]

i have a routine that queries an access 2000 db and uses sql to move data - since moving the db to a server the routine fails and I get the error 3134

anyone know what it is ???

 

[LlomaxX]

Probably need more to go on, but a 3134 is an Application or Object defined error. The line of code that generates the error would be great.

Are you creating an instance of the Access 2000 application in your code? Let's then state the obvious - Is Access 2000 installed on the server?

 

[iono]

ummm not sure it certainly was on the standalone machine - i will have to check on monday and if necessary install - thanks a lot for that

 

[CCLINT]

This is a syntax error in the sql Select statement you are using in the routine.

 

[iono]

thanks all now found the problem