Here are a list of errors that can occur when connecting Access to SQL Server

Read about our Access to SQL Server Upsizing Program
MUST Access Upsizer

Information about the Microsoft policy on forgotten password assistance with Microsoft Access (259134)
You may receive an error message when you try to upsize your Access database by using the Upsizing Wizard (838594)
How to use ADOX to create an SQL pass-through query in Access 2002 or in Access 2003 (304323)

How to use data transformation services (DTS) to export data from a Microsoft Access database to an SQL Server database (285829)
You receive a "Compile Error: Can't Find Project or Library" error message when you run a procedure that references Jet and the Replication Objects library (282331)

You receive an "unspecified error" error message when you create more than 64 connections to an Access Database in one process (830133)
How to attach an existing SQL Server 2000 Database to SQL Server 2000 Desktop Engine (290623)
ACC2002: How to Edit the Most Recently Used Template List (288441)

Logon errors occur when you connect to a SQL Server database from a Microsoft Access project (297373)
"Unexpected Error from External Database Driver (8961)" error message when you try to import dBASE files into Access (321003)
ACC2002: RecordExit Event Unavailable in Microsoft Access 2002 (286477)

How to store SQL database login IDs and passwords locally (209502)
How To Set the Mask and Picture Properties for Office XP CommandBars (286460)
You cannot link tables into a Microsoft Access project by using an ODBC Data Source Name (DSN) (287414)

Unexpected write conflict error occurs when you close a form in Access (304181)
ACC2002: Euro Currency Symbol Does Not Appear in Tables Exported to XML (287466)
ACC2002: When You Paste Table Struct

ACC2002: PivotTable List Displays "No Totals" or "No Details" in Data Area (301379)
PRB: Error "Unrecognized Database Format" When You Upgrade to Access 2000 or 2002 (238401)
How to create subforms that are based on SQL pass-through queries in Access 2002 (288633)

ACC2002: Unable to Transfer a SQL Server Database That Is Connected to an Access Project (287415)
The Script Editor unexpectedly quits when you use the Script Editor for the first time in an Office program (898789)
HOW TO: Use a VBA Procedure to Determine the Current Page of a Tab Control in Microsoft Access 2002 (324583)

ACC2002: Access Quits When Previewing Report Created from Form (295270)
How to create a top values per group report in Access 2002 (296449)
Results do not appear when you run a query that references Linked SQL Server tables (824169)

You cannot update a form that is bound to an ADO Oracle recordset in an Access project in Access 2002 or 2003 (826758)
ACC2002: Can't Use /Pwd Option with Password-Protected Database (292302)
How to programmatically change the database in a DSN that is using a trusted connection in Access 2002 (316752)

You receive an error message when you try to install Microsoft SQL Server 2000 Desktop Engine (287416)
BUG: You receive a "Disk or network error" error message when you open Access 2.0 database files in Access 2000 or Access 2002 (814811)
Microsoft Access stops responding when you edit a record that is being edited by another user (824173)

STS: Office Program Stops Responding When You Connect to SharePoint Team Web Site (289314)
Upgrade detection fails when you upgrade to Office XP (295346)
How to deploy an Access 2002 project that includes the Microsoft SQL Server 2000 Desktop Engine (299297)


Microsoft SQL Server 2000 Desktop Engine is not installed by Office XP Setup (290627)
ACC2002: Can't Find Data Type Conversion Functions in VBA Help (287063)
List of Microsoft Jet 4.0 reserved words (321266)


Jet OLEDB provider requires a Jet 4.0 system database in Access 2002 (286376)
BUG: You may receive a "Data provider failed while executing a provider command" error message when you try to access a three-tier data access page that is bound to a security-enhanced Access database or to an SQL Server database (840258)
How to change the connection string for an Access 2002 data access page (304324)


"ODBC Call Failed" error when you run a query with an outer join against linked SQL Server tables (303257)
How to sort records in an Access database in Access 2002 (304250)
Silent design changes may be discarded in a multiuser environment in Access 2002 (285828)


How to create a DSN-less connection to SQL Server for linked tables in Access 2003 and in Access 2002 (892490)
ACC2002: Name AutoCorrect Does Not Fix Changed Field Names in Union Query (282322)
PRB: Macro Warning Occurs in an Office Application When You Load a .NET Add-In (316724)

Descending indexes in Access 2002 become ascending indexes when upsizing to SQL even after you install Office XP SP-2 or Office XP SP3 (328019)
Microsoft Access quits when you add data through a query after you upgrade to Microsoft Jet 4.0 Service Pack 5 (309163)
Access 2002 Post-Service Pack 2 Hotfix Package: September 12, 2003 (827972)


ACC2002: Database Unexpectedly Upsized to SQL Server Master Database (281950)
Updated version of the Microsoft Jet 4.0 Service Pack 8 replication files is available in the Download Center (321076)

How to modify query properties in Microsoft Access (304356)
BUG: Records display #Deleted when you use Access 2002 to link to a SQL Server table that contains ROWGUID (290332)
You cannot create a table in design view if you enable your keyboard to use a bidirectional language (828418)

 
ACC2002: Cannot Use ADOX Views Collection with SQL Server (292791)
PRB: Installation of Runtime Deployment Package May Fail in Windows 98 (826280)
Issues that are fixed in Access 2002 by Office XP Service Pack 3 (836030)


ACC2002: You Cannot Open a Partial Replica File That Is Created in the Access 2002 Format (321850)
ACC2002: Error When You Select an Option from the Office Links Menu (280557)
ACC2002: JET Commits a SQL Server Transaction Instead of Rolling the Transaction Back (821703)

The first phase of upgrading is converting your data structure into SQL Server. During this phase we can upgrade your full database or you can strip any sensitive data from your database and reinsert that information after the conversion is complete.  We will provide you with a SQL Server 2005 database that you can install in SQL Server.

The second phase of the upgrade involves modifying your database. The software that we use is very robust and will usually work with the complexities of unusual naming conventions and other programming issues that tend to make upsizing with the built in Access wizard very expensive.