How to generate ALTER TABLE statements for all foreign key to primary key refrences in vba?
I wonder how i can generate ALTER TABLE statements for all foreign key to primary key references of current
access db using vba and writeing them to a text file. I be happy if some one show me a working code .Thanks

You're thinking of SQL Server etc. I don't think Access does this.


mmcdonal

What is the alteration that you want to make?
Could you describe the process you are trying to set up?

well i am trying to use meta data of access database to reconstruct the alter statements and save them in to a file!