Reset table field properties globally

V

Virgil

I'm have to recreate ~ 100 replicated tables to remove the
replication info fields ("s_..." fields). Certain field
properties such as "Allow Zero Length" were reset to the
default NO when the new tables were made. Is there a way
to globally reset field property values rather than change
each table's field properties one at a time. I vaguely
remember seeing a solution somewhere.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

reset all pivot field properties 0
Resetting a field property from text to Autonumber in Access 2002 3
Best Text Field Defaults: Null or Zero Length String 4
Null values 5
Look up tables vs. value fields via combo box on form 2
modify link table property 1
Is there a maximum size of field caption property in a table? 3
Autonumber field (Incremented change to Increment) 1

Top