Data Type Change

[Bruister via AccessMonster.com]

I have many linked tables with a common field named 'ID'. It was originally a
Text field but I need to change it to a 'Number' field in all tables. Can I
do this easily without causing errors with links?

 

[Piet Linden]

I have many linked tables with a common field named 'ID'. It was originally a
Text field but I need to change it to a 'Number' field in all tables. CanI
do this easily without causing errors with links?

the part that will cause problems would be the queries that use the ID
field as a filter. You would have to remove the single quotes around
any literal values. Other than that, you should be okay. Make a copy
of your DB and test it out.