>It runs and says it is copying data, but when it finishes, I > have empty tables. Any ideas as to why that might be? >
this sounds like your or your host's SQL license has expired. Saul > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On > Behalf Of Saul Rothbart > Sent: Thursday, July 18, 2002 3:38 PM > To: [EMAIL PROTECTED] > Subject: Re: [CFTALKTor] MS Access XP -> Tools -> Database transfers > > > > you wrote > > When I create an XP project in Access, and do a File -> import from > the > > SQL server v7.0, I loose my keys and MS conveniently changes my > VARCHAR > > to NVARCHAR etc. > > That is the normal state of affairs with MS SQL transfers. > Unfortunately, you then need to connect back into the DB and manually > set > your primary and foreign keys and most likely each table's data types. > > > > It scripts for about 1/2 hour, then I get the following: > > And then (drum roll please...) > > [Microsoft][ODBC SQL Server Driver][SQL Server]Windows NT user or > group > > 'MAGMANT\Administrator' not found. Check the name again.Initialize > > servers ... > > This may very well be a result of using a dial up connection. Especially > on > a shared server, things really do get funky. > > If you can, try connecting to the hosted db through your local MS SQL > Query > Analyzer. > > Out of curiousity how is Magma's service? > > Saul Rothbart > Rothbart Interactive > www.rothnet.ca > [EMAIL PROTECTED] > > > > > > > > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: "Saul Rothbart" <[EMAIL PROTECTED]> > To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > Manager: Kevin Towes ([EMAIL PROTECTED]) > http://www.CFUGToronto.org/ > This System has been donated by Infopreneur, Inc. > (http://www.infopreneur.net) > > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: "David Porter [Sympatico]" <[EMAIL PROTECTED]> > To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ > This System has been donated by Infopreneur, Inc. > (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Saul Rothbart" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
