Lookup Columns in ADP/SQL Server 2005 combination

[MarkEJackson]

I have an ADP that was linked to SQL2K, now to SQL2005. There are
tables that contain lookup columns (the data was an integer link to a
record in another table) that displayed values in easy to read formats.
The columns that were created in SQL2K still work and have the lookup
information. New columns that are created since the conversion cannot
be changed to lookup columns. Is there a way around this as the lookup
data has to be local to Access's ADP file?

Thx

Mark Jackson

 

[Sylvain Lafontaine]

The lookup properties are stored as extended properties on the SQL-Server
side. Maybe you can manage yourself these properties as required by ADP.
If you want to take a look at these properties:

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

 

[Sylvain Lafontaine]

However, the best solution would be to design and use a form instead of a
datasheet. With a form, you have full control on everything.

 

[MarkEJackson]

As soon as I posted, found my own answer, the lookup info is stored on
the SQL server as an extended property, I was able to create a script
to add the extended properties I wanted.

Thx

Mark Jackson

 

[aaron.kempf]

you mind sharing your script?

I'd just love the world to see it; it's beautiful; huh?

-Aaron