Stack Overflow
Stack Overflow

Questions tagged [upsizing]

Upsizing is a feature of Microsoft Access for upgrading an Access database to a SQL Server database while still retaining accessibility through Microsoft Access.

Quote from Wikipedia:

Upsizing is the term coined by Microsoft to describe the process of upgrading Microsoft Access Database to a Microsoft SQL Server. This allows to continue using Microsoft Access as a database front-end whereas the actual back-end is served by a separate local or remote SQL Server allowing much higher productivity and data volumes. Microsoft Access from the version 2000 on has a special Upsizing Wizard which facilitates the data migration to the proprietary Microsoft SQL Server. No other RDBMS are currently supported for upsizing.

18 questions
7
votes
5 answers

Upsizing a split Access database

I need to upsize a split Access database, i.e., one that's currently split between tow mdb files, a front-end and back-end. I see many webpages that in essence say, "run the Upsizing Wizard." My first, very basic question: Should I be running this…
Matt
6
votes
5 answers

MS-Access sees SQL server's datetime2 fields as TEXT

I'm upsizing my application from MS-Access FE and BE to MS-Access FE and SQL Server BE. I used the SSMA Access "upsizing" tool to convert all the tables from Access to SQL, then I linked the SQL tables in the Access FE using ODBC. In my access…
Mathieu Pagé
  • 10,764
  • 13
  • 48
  • 71
2
votes
3 answers

Force SET IDENTITY_INSERT to take effect faster from MS Access

I'm working on upsizing a suite of MS Access backend databases to SQL Server. I've scripted the SQL to create the table schemas in SQL Server. Now I am trying to populate the tables. Most of the tables have autonumber primary keys. Here's my…
mwolfe02
  • 23,787
  • 9
  • 91
  • 161
2
votes
1 answer

Create & Copy Access tables to SQL via SSIS? SQL 2008

I am trying come up with a way to pull the tables out of an Access database, automate the creation of those same tables in a SQL 2008 DB, and move the data to the new tables. This process will happen on a regular basis and there may be different…
John S
  • 7,909
  • 21
  • 77
  • 145
2
votes
1 answer

Is upsizing MS-Access to MS-SQL-Server version independent?

I am planning to upsize an Access 2010 database to a SQL Server version 11 (these are the versions I use in the moment). I am familiar with Access since version 1.0 and, to a lesser extent, with SQL-Server since a couple of years. But the last time…
Edgar
  • 2,527
  • 2
  • 19
  • 40
2
votes
2 answers

how to automate upsizing from Access to SQL Server?

I need to automate the migration from an Access (2003) to an SQL Server DB (2005 or 2008). The upsizing should be done automatically as part of a build process. I need that because there are 2 versions of the software, a single user rich client and…
Arne
  • 23
  • 1
  • 3
2
votes
0 answers

How to upsize Access 2013 to Sharepoint on Office365, but still keep synced "offline tables"

In a previous question (Options for cloud based MS Access backend) one poster, Albert D. Kallal, stated: "...you could certainly consider to up-size your Access back end tables up to office 365 and continue to use your Access front end. And more…
Jaspos
  • 365
  • 1
  • 4
  • 17
1
vote
1 answer

MS Access: Substitutes for Upsizing Wizard (SSMA?)

Our team has been using Microsoft Access 2010 as a frontend for an SQL Server 2014, and are dependent on the Upsizing Wizard in Access to migrate tables from Access to SQL. For example, if there is an SQL database named papers, our team has an…
SindreKjr
  • 249
  • 2
  • 17
1
vote
0 answers

Upgrading multiple Access Databases Programmatically on 64-bit

I have an ASP.net application that is pulling data from Access databases using the JET provider. I have recently pushed this application to production and learned that there is not a 64 bit provider for connecting to an Access database. These…
Eric
  • 170
  • 3
  • 12
0
votes
2 answers

MS Access Upgrade to SQL Server

I have developed an MS Access 2007 database with forms that works fine in access, but when I upsize the back end to SQL Server, I completely lose functionality on a sub-form. Has anyone else run in to this problem? Is there a work around?
PeteTheFish
  • 11
  • 2
0
votes
1 answer

Access Upsizing - Property 'Attributes' already exists for 'table'

I'm trying to use Access's upsizing wizard to move the data from Access to SQL Server. I'm currently on this error but can't figure out where the property is coming from; Property 'Attributes' already exists for 'table'. The SQL its trying to run…
Ash Burlaczenko
  • 24,778
  • 15
  • 68
  • 99
0
votes
0 answers

Access 2007 Front End won't open linked sql server express 2014 recordset. Why?

I am trying to upgrade an Access 2007 Backend database to Sql Server Express 2014 because it is too slow across a network now. I was able to upsize the db and link the tables back into my Access Front End using built in ODBC linking…
Darwind
  • 11
  • 1
0
votes
1 answer

Critical Error #-2147217887 Multiple-step OLE DB operation generated errors

I've converted an access DB to an SQL express DB using the built in upsizing wizard in MS access. But I now get an error when I try to programmatically add a record to the SQL server table: Critical Error #-2147217887 Multiple-step OLE DB operation…
user1801904
  • 99
  • 3
  • 9
0
votes
2 answers

Migrating the backend from MS Access to SQL Server

The requirement for the client is to convert the backend of the current application running on MS Access 2007 to SQL Server 2005. For this I tried to create an .adb using an upsizing wizard. The problems I face are Almost all complex queries are…
Bharath Jain
  • 11
  • 5
0
votes
1 answer

Data migration from Access 2007 to SQL Server 2005

I have been asked to migrate data and queried from MS Access to SQL Server. While using upsizing wizard, out of 73 tables 69 got upsized properly and the other 4 tables were skipped (with no data migrated, only structure got created). The reason I…
Bharath Jain
  • 11
  • 5
1
2