Upsizing errors

[Guest]

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 decided not to go
the .adp route). 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 shine some light on this that would
be great.

Thanks,

Chris

 

[dbahooker]

why didnt you go with ADP?

it is a MUCH better solution

 

[Guest]

Sorry, but can you explain that? I was under the assumption that ADP is no
longer supported by Microsoft. I have read various posts on this board that
seem to suggest that ADP is not really worth using due to the time and energy
necessary not only to learn it but also to redo much of what you've done so
that it works in
ADP.

Of course, at this point our DB is still pretty basic (not too many
forms/queries etc.), so maybe ADP would be the way to go. Does anyone else
have an opinion on the subejct?