[AccessD] FW: [U] Soldier in Iraq needs Access Help

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




More information about the AccessD mailing list