Originally posted by Bulldog I get the distinct feeling Redforest wasn't talking about connecting tables from two databases together.
But what do I know?
Access is more than just a database, it is a complete database environment and you can build forms (including web forms) and reports that work with any ODBC database. "Linked Tables" just means that the table shows up in the list within Access -- MSSQL still does all the back end work -- there isn't an Access table.
Now I wouldn't recommend using Access as a Web development tool, but it does a good job for desktop front ends. And yes, I know this is WebHostingTalk.
I just wanted to offer that it is possible to "connect to an MSSQL Database with Access", in case anyone thought otherwise.
So you mean you can build query forms inside Access that can be used against other databases?
Well, you learn something new everyday! Wouldn't doing this slow down the performance of each considerably? I mean why wouldn't you just make straight SQL queries in ASP? Or is this for people who don't know anything about SQL?