Quote:
I am alos thinking about an artical I was reading about using SQL in the back and having access link to it in the front. I wish microsoft would have made this easier.... does it get better in 2002 / XP?
You should be able to link the tables in your Access front-end.
Lets say the tables are on a sql-server, and you want to use an ODBC connection..
You make a new DSN (data source name) in the ODBC-Control panel in the Control-Panel
The DSN has certain properties like where the database is stored, username & password, and of course the name of the datasource.
Now.. when you want to link these tables in your ms-access front-end.
you select File/Get External Data/ Link Tables..
Now Access show you a common dialog box and asks you which file to link the tables from.
In the bottom of this screen you can select numerous of database-types..
Select the ODBC-type..
If everything went okay you should now be able to see the DSN you made before..
Select it, and now your Front-end is linked to the tables stored on the sql-server.
Hope this helps you out.
Greetz