I don't use link tables. You have to create a new access project. It is not a mdb file. It is an adp file. Just click new and then select project with existing database. You can them type in the location of the database, username, and password.
One other neat feature of the access front end is the copy and paste ability. You can copy and paste records with great quickness. I'll open my local, dev, and live databases and copy the records over all the time from one to the other. J On Fri, Nov 28, 2008 at 9:13 AM, Vivec <[EMAIL PROTECTED]> wrote: > 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:281733 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
