MS-Access2003-Abt Select data source screen

ramsundar · April 27th, 2007, 02:03 AM

Hi Everyone,

I am trying to access my sql server database through MS-Access 2003. (My System configuration is OS-VISTA and MS-OFFICE 2003). I have completed my ODBC configuration first. Then i have created blank database in MSAccess 2003. Then i am trying to link my database-tables through File->Get External Data->Link Table. "Select Data Source" screen is not getting populated automatically on my machine. Due to this reason i am not able to access my link my tables.

It will be very helpful for me if you suggest something on this...

Thx & Regards
Ramsundar

ramsundar

mmcdonal · April 27th, 2007, 06:34 AM

Select the Tables object, then select Insert > Table > Link Table, and then when the link table file explorer comes up, use the FileType pull down and select ODBC data sources.

I find provider statements and programmed interaction work better than ODBC and linked tables with SQL, and is faster. But ODBC linked tables are easier to work with.

Did that help?

mmcdonal