Re: Link to SQL Server 2005

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

As Rich said, you can link to it from different versions of Access.
However, bear in mind that there isn't 100% compatibility between the
two when it comes to things like data types. You'll want to do some
research first to find out the most appropriate use cases for your
particular business scenarios. Here's a list of resources you might
find useful.

--Mary

TechEd Online Panel:
Go to http://msdn.microsoft.com/en-us/events/teched/cc676818.aspx and
search for:
"Are we there yet? Successfully navigating the bumpy road from Access
to SQL Server"

Microsoft Access or SQL Server 2005: What's Right in Your
Organization?
http://www.microsoft.com/sql/solutions/migration/access/sql-or-access.mspx

Optimizing Microsoft Office Access Applications Linked to SQL Server
http://msdn.microsoft.com/en-us/library/bb188204.aspx

What are the main differences between Access and SQL Server?
http://sqlserver2000.databases.aspfaq.com/what-are-the-main-differences-between-access-and-sql-server.html

"The Best of Both Worlds--Access MDBs and SQL Server"
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

SQL Server Migration Assistant for Access (SSMA for Access)
http://www.microsoft.com/sql/solutions/migration/access/default.mspx

FMS Upsizing Center
http://www.fmsinc.com/Consulting/sqlupsizedocs.aspx

Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/dp/0672319446


On Mon, 20 Oct 2008 17:11:01 -0700, SHIPP
<SHIPP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

My company is looking at setting up a SQL Server 2005 database. Can I link to
it from Access 2003 without a problem?
.

Relevant Pages

  • Re: Theres a new Borland Delphi directions survey up
    ... Choosing and Using MSDE 2000 as the Database Engine for Your Application ... The Microsoft SQL Server 2000 Desktop Engine is an alternative ... database engine in Microsoft Access 2002 which enables software developers ...
    (borland.public.delphi.non-technical)
  • Re: The data was added to the database but the data wont be displayed
    ... replication with queued updates (SQL Server 2005), ... When inserting records into a Microsoft SQL Server database from an ... Microsoft Access tries to reselect the newly inserted record to ... subscriber) are SQL Server 2000. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Need some query design help....
    ... is "Microsoft Access Developers Guide to SQL Server." ... > "John Viescas" wrote in message ... >> Let's say, for example, that you have Customers as a selection on your ...
    (microsoft.public.access.queries)
  • Re: Microsoft Support for Microsoft Access and ADPs
    ... I have been hearing rumours, from Microsoft Product Support Technicians, ... particular .adp projects and SQL Server Client Data Manager Interface (CDM ... position in regard to continuing support for Microsoft Access and SQL Server ...
    (microsoft.public.access.adp.sqlserver)
  • RE: SQL server failed to call Excels library after ms03-026 patch applied
    ... VBA environment in Microsoft Access successfully, ... related to SQL Server. ... contacting PSS and opening a Support incident troubleshoot this further. ...
    (microsoft.public.sqlserver.security)