Deleting Relationships...

I need to change the data type of my ID fields in all my tables from number
to text. The way I see it, I would need to delete all the relationships
between the tables that connect the ID fields. Is there another way to do
this? -OR- If I do have to delete the relationships, change the data types,
then recreate the relationships exactly as they are now, will that screw
things up royally? This is assuming I do not runa any reports/queries/forms,
etc. while the relationships are gone...

Thanks for your help!

You will need to remove the relationships, change the data type and
then re-establish the relationship. Make sure your data types and
sizes are exact when you change them or you may create problems for
yourself as your database gets larger.




On Wed, 15 Dec 2004 12:25:04 -0800, "Kojones"
wrote:

I need to change the data type of my ID fields in all my tables from number
to text. The way I see it, I would need to delete all the relationships
between the tables that connect the ID fields. Is there another way to do
this? -OR- If I do have to delete the relationships, change the data types,
then recreate the relationships exactly as they are now, will that screw
things up royally? This is assuming I do not runa any reports/queries/forms,
etc. while the relationships are gone...

Thanks for your help!

We're all mentats here so don't tell us why you're doing whatever it is
you're doing. That would give us an unfair chance toward understanding
what's on your mind.

You say you want to end up with things exactly as they are before you start.
I suggest that you leave them that way. You say that you want to get things
back to that state before you run any queries or reports ...

Just create a new, empty database and copy into it the tables you need.
Change the data type for the key fields to text and you should be ready for
your mystery operation.

HTH
--
-Larry-
--

"Kojones" wrote in message
...
I need to change the data type of my ID fields in all my tables from
number
to text. The way I see it, I would need to delete all the relationships
between the tables that connect the ID fields. Is there another way to do
this? -OR- If I do have to delete the relationships, change the data
types,
then recreate the relationships exactly as they are now, will that screw
things up royally? This is assuming I do not runa any
reports/queries/forms,
etc. while the relationships are gone...

Thanks for your help!

Check out the Tools section to copy relationships from one MDB to
another

http://www.etechrecovery.com/001-AccessFAQ.asp#Tools