I have some few Questions regarding How MSAccess Connects to other databases:
1- In what circumstances Should I use :
dim dbs as database
2- Is there anyway to Connect to SQL server Database programmaticaly without going through ODBC datasource wizard?
3- Pass-through query are assumed to be the fastest way to get responses from SQL server database. Does Pass-Through query uses the same SQL statement that is used in SQL Server Query analyzer? if so , is it possible to copy an SQL statement from the Query analyzer and paste it in Pass-through query window and run it?
4-How can I create a stored procedure and/or triggers from MSAccess?
5-Is MSAccess a 03 tier environment? please explain the concept of 03 tiers if you can.
I will much appreciate your help