MS Access Upgrade to SQL Server 2000

• Morty

  SSC Eights!

  Points: 836

  More actions

  October 14, 2003 at 8:27 am

  #65499

  I'm getting sp_addextendedproperty errors when I use the upsizing wizard in Access 2002. I can't find the equivalent of 'extended properties' in the Access table so I can check out the before/after picture. (I know how to check it in SQL). Can anyone help please? Thanks.

• bigdmoore

  SSChasing Mays

  Points: 630

  More actions

  October 15, 2003 at 11:36 am

  #478345

  Access 2002 uses extended properties in SQL to store meta data about the access application.

  Are you using SQL 2000? I don't think SQL 7 had extended properties - not sure though.

  This might help:

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro02/html/sql02a10.asp