Refreshing Links

[Guest]

I am working with a database that has been upsized to a SQL Server. I am the
database's project trying to add a default value to a field. I am able to
add it to the project and it stays in there. When I try to refresh my links
in the actual database, the default value is not refreshing. Is there
something that I am missing?

 

[Granny Spitz via AccessMonster.com]

When I try to refresh my links
in the actual database, the default value is not refreshing.

Refreshing the links won't work. The table's metadata (column names and
sizes, indexes, statistics, database password, etc.) is stored in the Access
database at the time of link creation and is *never* updated. If you make
structural changes to the linked table, you have to drop the link and
recreate it to pick up the *current* table metadata.

 

[Guest]

So even though before the database was upsized there was a default value in
there and now after the upsizing it disappeared. Does this always happen?

 

[Van T. Dinh]

Are you using MDB/MDE or ADP/ADE?

If you are using MDB/MDE, you need to modify the Table Design on the SQL
Server, not the Table as appear in MDB as this is only a linked Table to the
real Table in the SQL Server Back-End.

 

[Granny Spitz via AccessMonster.com]

So even though before the database was upsized there was a default value in
there and now after the upsizing it disappeared. Does this always happen?

Yes. For a list of the *features* of the upsizing wizard, you can look in
the book, "Access Developers Guide to SQL Server," by Andy Baron and Mary
Chipman. If you don't have the book, you can read Brett Collings's summary
here:

http://groups.google.com/group/microsoft.public.access.setupconfig/msg/0980f7f817ebdf6c?hl=en
&