Yeah, I tried that to link the tables, i'm a bit rusty so maybe that was why. I didn't see any option to connect to the MS SQL Database, it was asking for ODBC connection etc. etc. So I just exported from SQL Manager.
It actually took me far longer to actually do all this than it did to put the query together and run it once I got the data into MS Access. I think I'm now fairly certain that there must be something very wrong with the online service if it cannot output 5,000 records from this query. But yes, I am very comfortable with MS Access, and I haven't come across a tool with similar ease of use and flexibility for MS SQL or MySQL yet. 2008/11/28 Jerry Barnes <[EMAIL PROTECTED]>: > Don't know if you knew this or not, but you can use Access as a front end to > SQL Server. Make a new database project and point it to the server and > database. The nice thing about this is the ability to use the query > designer, report designer, macros and such in access without having to > import the data. You create tables, edit data, create views, and stored > procs. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:281713 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
