MartyConnelly
martyconnelly at shaw.ca
Mon Nov 20 20:39:54 CST 2006
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