ODBC and ACCESS tutorial

[RiderJon]

Hello all,

I have been using VBA and ACCESS to create databases and link tables between them.

Now, I need to deal with a ODBC type. I have no idea how it works: for example, when I double click on the "green" ODBC link, it does not display the data as would a linked table.

My Question: Do you know of any good ONLINE tutorials on ODBC, especially with examples and references to MS ACCESS.

Thank you for the help.

RiderJon
"I might have created ctrl+alt+del,
But Bill made it famous" - Dr. Dave

 

[pweegar]

go to google.com and do a search on odbc ms access. There's lots of info.

 

[jrbarnett]

There's a free book on it that I wrote available from the "Free Stuff" page at

http://www.jrbarnett.freeserve.co.uk/

John

 

[RiderJon]

John:
Thank you! But is there a more simpler and user-level tutorial.

It might sound stupid but:
1) What does it mean when I double click on the ODBC in my ACCESS database? I can go into it's design view and see the fields.

2) Say I have an ODBC dbo_cust. Now how I can create a query from it?


Pweegar:
What's google? .... just kidding. Ofcourse I tried google, but only came across pure ODBC or high level. I am lookingfor something like "Using ODBC in ACCESS for dummies" kinda deal.










RiderJon
"I might have created ctrl+alt+del,
But Bill made it famous" - Dr. Dave

 

[jrbarnett]

If you double click an ODBC linked table in Access, you will get to access that table in Access (sorry for the unintentional pun).
You can treat an ODBC linked table just like any Access table in queries, reports, forms etc.

John

 

[RiderJon]

John:

Wonderful! I was hoping for the same result, but when I clicked on it, it gave me an error message. After reading your brief tutorial, my guess is I need to do "something" to properly setup the ODBC connection.

Another simple questions: By ODBC tables, you are referring to that "greeny spherical" things right?

Sorry if questions cannot get any stupider, but am new to ODBC, somewhat old to ACCESS. Was expecting the ODBC to function like linked tables in ACCESS. Forgot the connectivity part.

Thank you for the help.

RiderJon
"I might have created ctrl+alt+del,
But Bill made it famous" - Dr. Dave

 

[jrbarnett]

RiderJon

I've just tried creating an Access ODBC connection to link to another ODBC connection, and Access itself refused to let me do so (Access 2000 format on Access 2002); this is probably because the linked table feature can do the job just fine.

John