Magma is ok. Jean-Pierre put a post to this group a while back saying they are pretty good. I have yet to meet my version of 'great' tech support, but they definitely beat my recent experiences with Bell.
I forgot to mention, I have created a local project and tried to do an File -> Get external data from Magma too. I can download the stored procedures (thank you XP, you can't do that with 2000) and table structures, but I get no data. (I even checked the little copy data flag too). It runs and says it is copying data, but when it finishes, I have empty tables. Any ideas as to why that might be? Dave -----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)
