Jim Lawrence
accessd at shaw.ca
Tue Nov 21 13:13:49 CST 2006
It appears that MS, to that end, has set all their MS SQL products time-sensitive. Any partner copies of MS SQL 2000 that have not been installed within a certain time period will not install. Upon a discussion with a MS rep, though not official, it was described as an attempt to move their partners away from supporting older versions and towards the latest offering. This of course cause some issues with supporting clients who have large investments in an older MS SQL and the developer having to borrow their legal copy so a development site can be created.... legal? I guess the push is not to continue supporting current SQL but to encourage clients to upgrade and developer to retrain. Comments? Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly Sent: Monday, November 20, 2006 6:40 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] FW: [U] Soldier in Iraq needs Access Help SQL Server 2005 Express Edition with Advanced Services SP1 234 Meg http://msdn.microsoft.com/vstudio/express/sql/download/ Advanced Services contains the following features: SQL Server Management Studio Express, a graphical management tool based on SQL Server Management Studio that makes it easy to manage and administer SQL Server Express databases. Reporting Services, an integrated report creation and design environment to create reports. Full-Text Search, a powerful search engine for searching text-intensive data. However Note this about Vista and MSDE non support In an effort to provide customers with more secure products, Microsoft Windows Server "Longhorn" and Microsoft Windows Vista will only support SQL Server 2005 Service Pack 2 (SP2) or later when it becomes available. Earlier versions of SQL Server, including SQL Server 2000 (all editions including Desktop Engine edition, a.k.a MSDE), SQL Server 7.0, and SQL Server 6.5, will not be supported on Windows Server "Longhorn" or Windows Vista. http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx You can use the Export functionality in Access to send data to a number of places, including SQL Server. You should be able to find information on this in the Access help file, but here is the general process: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=295865&SiteID=1 Open your database in Access and choose the Export option. Choose ODBC Database from the Files of Type list. Follow the wizard to create a DSN to your SQL Express instance. Pick the tables and click OK. You will need to enable TCP connections to SQL in order for Access to be able to connect and if the SQL Express server is on a different computer than Access you'll need to open Exceptions in the firewall on the server computer. Instructions on how to do that are at http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx http://blogs.msdn.com/sqlexpress/default.aspx Regards, Mike Wachal SQL Express team FAQ: How to connect to SQL Express from "downlevel clients"(Access 2003, VS 2003, VB 6, etc(basically anything that is not using .Net 2.0 or the new SQL Native Client)) http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx Susan Harkins wrote: > >I would probably do this with SQL Server 2005 Express Edition with Advanced >Services.SQL Server 2005 Express Edition with Advanced Services is perfect >for use as a backend to a small, multiuser application that requires more >advanced features such as Web reporting or Full-text Search. >You could do this with the full version of SQL 2000 but now is available in >Express. > >========Are you sure that full-text search is supported by Express? > >Susan H. > > > -- Marty Connelly Victoria, B.C. Canada -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com