Hi all,

in vb6 I can get databases access with no problem but when I try to use what I know for database access in VB6 in VB Studio 2008 it is not happy

what I want to do is set a global database access so i only have to have one
connection open to the local database

Can some one help me with the code for this as I have NO Idea how to access and query a database

I would like to do it via code so I have more control over the database.