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)
