Import Access Database?

I am trying to upsize an Access database with the intent of using Access as
the front-end and MSDE as the back-end. I know MSDE allows you to import
DTS
packages, but I am not really familiar with DTS, so I decided to use the
Access wizard.
All in all, it seems pretty straight forward. I chose a default instance of
SQL Server that I created using the MSDE (residing on my local machine), set
a username and password, and told it to link the tables (I also tried using
..adp, but I got the same errors). I also told it to upsize the indexes, but
nothing else.
The program seemed to be working fine, but when it finished it gave me the
following error messages:
EXEC sp_addextendedproperty N'Attributes', N'2', N'user', N'dbo', N'table',
N'EntireSpreadsheet', N'column', N'ID'
EXEC sp_addextendedproperty N'CollatingOrder', N'1033', N'user', N'dbo',
N'table', N'EntireSpreadsheet', N'column', N'ID'
EXEC sp_addextendedproperty N'Type', N'10', N'user', N'dbo', N'table',
N'EntireSpreadsheet', N'column', N'ID'
...
and also:
Server Error 15233: Property cannot be added. Property 'Attributes' already
exists for 'dbo.EntireSpreadsheet.ID'.
I am not entirely sure what these errors mean, and all the data seems to be
displaying properly, but if anyone could offer any suggestions about how to
import the file to MSDE (even if it's using DTS) I would appreciate it.
Thanks,
Chris
Here's a resource that has links to various topics that address your
questions:
Migrating Microsoft Access Applications to SQL Server
http://www.microsoft.com/sql/accessmigration.mspx.
--Mary
On Mon, 10 Oct 2005 17:02:16 -0400, "Chris Burnette"
<chrisb@.publishamerica.com> wrote:

>
>I am trying to upsize an Access database with the intent of using Access as
>the front-end and MSDE as the back-end. I know MSDE allows you to import
>DTS
>packages, but I am not really familiar with DTS, so I decided to use the
>Access wizard.
>All in all, it seems pretty straight forward. I chose a default instance of
>SQL Server that I created using the MSDE (residing on my local machine), set
>a username and password, and told it to link the tables (I also tried using
>.adp, but I got the same errors). I also told it to upsize the indexes, but
>nothing else.
>The program seemed to be working fine, but when it finished it gave me the
>following error messages:
>EXEC sp_addextendedproperty N'Attributes', N'2', N'user', N'dbo', N'table',
>N'EntireSpreadsheet', N'column', N'ID'
>EXEC sp_addextendedproperty N'CollatingOrder', N'1033', N'user', N'dbo',
>N'table', N'EntireSpreadsheet', N'column', N'ID'
>EXEC sp_addextendedproperty N'Type', N'10', N'user', N'dbo', N'table',
>N'EntireSpreadsheet', N'column', N'ID'
>...
>and also:
>Server Error 15233: Property cannot be added. Property 'Attributes' already
>exists for 'dbo.EntireSpreadsheet.ID'.
>I am not entirely sure what these errors mean, and all the data seems to be
>displaying properly, but if anyone could offer any suggestions about how to
>import the file to MSDE (even if it's using DTS) I would appreciate it.
>Thanks,
>Chris
>