I am currently working on an "upsized" db that had a couple of lookup fields set on the tables. In UpsizingAccesstoSQLServer.ppt , which a UG generously posted, the presenter states that lookup fields will absolutely not upgrade, and I agree. My Frontend will no longer show the table contents at all, because it cannot find the lookup fields.
Microsoft says nothing about it that I can find, and now I can't figure out how to shut off the lookups so I can see the table contents. Even if I create a new ADP, the lookups are there, not working, so they must "live" in the SQL Server backend. I haven't found their lair, though.
Ron
Microsoft says nothing about it that I can find, and now I can't figure out how to shut off the lookups so I can see the table contents. Even if I create a new ADP, the lookups are there, not working, so they must "live" in the SQL Server backend. I haven't found their lair, though.
Ron