Connecting to an Access database

[NateBuckley]

Hello, I'm looking for a good tutorial on connecting to an Access database
and can't find any. Due to not everyone at work having Access on their
machines, I'm having to have the front end of the system running through
Excel (as they all have that) and connect to a database, I'm just wondering
if anyone could spare a few minutes writing the code to connect to a database
along with how to close the connection.

I can figure out all the SQL type commands to get information from it, i'm
just having problems finding a good tutorial on showing me how to actually
get connected.

Thanks for any help in advance.

 

[Norman Jones]

Hi Nate,

See Ole P Erlansen at:

http://www.erlandsendata.no/english/index.php?t=envbadac

 

[NateBuckley]

You Beauty.

Thanks muchly.

Hi Nate,

See Ole P Erlansen at:

http://www.erlandsendata.no/english/index.php?t=envbadac

 

[Bob Phillips]

See
http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForMicrosoftJet

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)