Re: Error when upsizing Access 2K Database
From: Mary Chipman (mchip_at_online.microsoft.com)
Date: 10/16/04
- Next message: Derrick Leggett: "Re: SOX audit tool"
- Previous message: Fred Yarvin: "Error when upsizing Access 2K Database"
- In reply to: Fred Yarvin: "Error when upsizing Access 2K Database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sat, 16 Oct 2004 10:39:01 -0400
You might find this page helpful troubleshooting the upwiz:
http://office.microsoft.com/en-us/assistance/HP030894261033.aspx
FWIW, the upsizing wizard does not do a very good job of migrating
from Access/Jet to SQL Server even when it does work. It creates an
unholy mess of triggers, views and inefficient data type conversions.
You'd be better off recreating the schema in SQL Server to take
advantage of SQLS features like constraints and stored procedures, and
then migrate the data using DTS or even queries from linked tables.
--Mary
On Fri, 15 Oct 2004 13:21:06 -0700, "Fred Yarvin" <Fred
Yarvin@discussions.microsoft.com> wrote:
>When I try to upsize an Access 2K database, I get the following two errors,
>one after the other:
>
>SQL Server does no exist or access denied.
>The Upsizing Wizard only works with MS SQL Server (Versions 6.50 SP5 or
>higher). Please log onto a SQL Server data source.
>
>I doesn't matter whether I login as 'sa' or use a trusted connection, create
>a new database or use an existing one, or use '(local)' or the name of my
>computer as the server name. If trying to use an existing database, I am
>using a File Data Source that appears to work just fine elswhere (test
>connection returns success, and I can import/link tables in an Access
>database). I have read the KB article that says to use a file DS, but that
>hasn't helped. I have even tried a machine DS, but same errors.
>
>I am the dbo of the existing database, and I and the sa account should have
>database create priviliges. I can create databases and tables in SQL
>Enterprise manager just fine.
>
>I get these same two errors if I try to create a new adp file and selecting
>New Database. I am using XPPro and Office XP Developer Edition.
>
>Thanks.
- Next message: Derrick Leggett: "Re: SOX audit tool"
- Previous message: Fred Yarvin: "Error when upsizing Access 2K Database"
- In reply to: Fred Yarvin: "Error when upsizing Access 2K Database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
