NEWBIE!!!! Access 2K and MsSQL 2k

[Pierrick]

Hi all,

I couldn't find any obvious answer to my question so here goes.

Is it possible to programmatically (via a VBA module) to:

1. create a connection to SQL (that I know is possible), then
2. open tables in MsSQL as recordsets WITHOUT having to link them.

Basically I'd like to bypass this linking thing, which seems to me -as a newbie- an utter waste of time.
If it is possible has anyone got a quick and dirty bit of code I could study?

Thanks in advance

 

[Pierrick]

Hi All,
Alright, so I didn't look well enough... Actually I didn't know about the 'Project' thingie in Access 2K so I was using the wrong keywords in my searches (this is my excuse).
So I merrily started an Access project, connected to the MsSQL server, and voila! This project thing seems very cool, much more versatile and efficient than linking SQL tables.
Thanks anyway.