Connecting to VB 6.0

amolbehl

Hi I am trying to connect to VB 6.0 and access

I am new to VB so am having difficulty.

when I say
Global x as Database
in my module

it says "User defined type not allowed"

can anyone plz tell me wht I am doing wrong??

Dököll

Quote:

Originally Posted by amolbehl

Hi I am trying to connect to VB 6.0 and access

I am new to VB so am having difficulty.

when I say
Global x as Database
in my module

it says "User defined type not allowed"

can anyone plz tell me wht I am doing wrong??

Are you using Access 97? It's been known to have this issue...There's a solution here but you'll need to do some reading. I'll attempt to find in and post link. I would fetch using "connect vb to ms access" something in that kind of a line...should pull up an array of examples nontheless!

In a bit!

missinglinq

Quote:

Originally Posted by amolbehl

Hi I am trying to connect to VB 6.0 and access
I am new to VB so am having difficulty.
when I say
Global x as Database
in my module
it says "User defined type not allowed"

Am I write in reading this as saying that you're placing this code in a module in VB 6 and not in VBA?

Linq

Connecting to VB 6.0

re: Connecting to VB 6.0

re: Connecting to VB 6.0

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about