MS Access Interop

[Sehboo]

I am using access interop (object 10.0) in my application. It works
fine on my machine but when I test it on some machine which has an old
version of access then it fails. This is how I am declareing my
variable.

Dim oAccess As Access.Application

How do I resolve the issue so that it doesn't matter if it is old or
new access it works?

Any idea?

Thanks

[t.egginger]

Hello,

i guess you can not solve this via interop. (as far as i
know)
either you use reflection and create the access object at
runtime, or you simply write your own com-wrapper class
solving this for you!

regards

tom

-----Original Message-----
I am using access interop (object 10.0) in my application. It worksfine on my machine but when I test it on some machine which has an oldversion of access then it fails. This is how I am declareing myvariable.

Dim oAccess As Access.Application

How do I resolve the issue so that it doesn't matter if it is old ornew access it works?

Any idea?

Thanks
.

[Sehboo]

Any example of any of that?

thanks

"t.********@removethis-gmx.net" <an*******@discussions.microsoft.com> wrote in message news:<17*****************************@phx.gbl>...

Hello,

i guess you can not solve this via interop. (as far as i
know)
either you use reflection and create the access object at
runtime, or you simply write your own com-wrapper class
solving this for you!

regards

tom

-----Original Message-----
I am using access interop (object 10.0) in my

application. It works

fine on my machine but when I test it on some machine

which has an old

version of access then it fails. This is how I am

declareing my

variable.

Dim oAccess As Access.Application

How do I resolve the issue so that it doesn't matter if

it is old or

new access it works?

Any idea?

Thanks
.