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
0
votes
1 answer

Using Access to do a Make Table query to create a SQL Server table using ODBC connection

I am upsizing an Access 2010 database to SQL server. There is an updatable "Make Table" query that is run to create a table and fill it. Currently, it fills a backend table in another ACCDB file. I have moved all the backend tables to SQL Server…
Ron
  • 978
  • 3
  • 13
  • 27
0
votes
0 answers

Bad Behavior after upsizing MDB to SQL Server (no upsize_ts in Table)

maybe you could help, i didn't find any proper solution for my problem: Working Environment: Access 2003 SQL Server 2008 R2 Express Database (based on Access 2003) containing a few dozens of Tables, related to each other: - Table "Customers"…
Daniel Alexander Karr
  • 325
  • 1
  • 4
  • 16
0
votes
1 answer

Upsizing Access to SQL UK vs. US date formats

I'm trying to upsize from Access 2010 to SQL Server 2008. All is working except one table; the table gets created in SQL Server, but no data gets upsized. The reason is, one column contains a date which, as stored in Access, is in the UK format…
David Barrows
  • 758
  • 7
  • 20
1
2