Elam, Debbie
DElam at jenkens.com
Thu Aug 7 16:54:11 CDT 2003
I had lots of Access 97 databases hooking to SQL 7.0 BEs. I did not have a single problem when they were upgraded to 2000. Unless the server name is changing, I don't see that you would need to do anything. Debbie -----Original Message----- From: Nicholson, Karen [mailto:knicholson at gpsx.net] Sent: Thursday, August 07, 2003 5:00 PM To: Dba-Sqlserver (E-mail) Subject: [dba-SQLServer]Migrating from SQL7 to SQL2000 I will be migrating from SQL7 to SQL2000 in the next month or so. Need advice - what will be my major problems? In addition, our company has many Access 97 databases that are linking and updating (augugughghghg!!!!) to SQL7. I am working through those folks to get them into Crystal interfaces and running stored procedures to update their data, but am concerned about the compatability if I do not catch all the apps before I migrate. I already have contacted those using JAVA to let them know to gear up. All advice is appreciated. Thank you. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com - JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject to the Attorney-Client Privilege, (2) an attorney work product, or (3) strictly confidential. If you are not the intended recipient of this message, you may not disclose, print, copy or disseminate this information. If you have received this in error, please reply and notify the sender (only) and delete the message. Unauthorized interception of this e-mail is a violation of federal criminal law. This communication does not reflect an intention by the sender or the sender's client or principal to conduct a transaction or make any agreement by electronic means. Nothing contained in this message or in any attachment shall satisfy the requirements for a writing, and nothing contained herein shall constitute a contract or electronic signature under the Electronic Signatures in Global and National Commerce Act, any version of the Uniform Electronic Transactions Act or any other statute governing electronic transactions.