Lookup Columns in ADP/SQL Server 2005 combination

  • Thread starter Thread starter MarkEJackson
  • Start date Start date
M

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
 
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.
 
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
 
you mind sharing your script?

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

-Aaron
 
Back
Top