a2k recovered from corruption, missing relationships

[Deano]

Just had a minor mishap which has meant starting a new database and
importing all objects. I did have the option to import relationships ticked
but these have not come over.

The prospect of recreating the contents of the relationship window is
freaking me out.

Any ideas?

Thanks
Martin

[Tony Toews]

"Deano" <de*********@hotmail.com> wrote:

Just had a minor mishap which has meant starting a new database and
importing all objects. I did have the option to import relationships ticked
but these have not come over.

The prospect of recreating the contents of the relationship window is
freaking me out.

Understandable.

Use the sysrels utility at the following location to copy the table relationships
layout window
http://www.trigeminal.com/lang/1033/...p?ItemID=12#12
Or use Save Restore Modify Relationship Window at
http://www.lebans.com/saverelationshipview.htm

You will likely have to recreate the relationships themselves though. You likely
could do that programmatically by running through the relationships collection.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[PC Datasheet]

Martin,

I am in business to provide customers with a resource for help with Access. I
can recreate the relationships in your database for you. I will provide a map of
all the tables in your database showing all the fields in each table, all the
relationships that exist between the tables and the type of each relationship. I
will then physically create all the relationships shown on the map. The tables
on the map will be arranged according to the logical processes in your database.
The map will serve you as excellent documentation of the design of your tables.
Email me at my email address below if you would like my help.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Deano" <de*********@hotmail.com> wrote in message
news:41***********************@ptn-nntp-reader02.plus.net...

Just had a minor mishap which has meant starting a new database and
importing all objects. I did have the option to import relationships ticked
but these have not come over.

The prospect of recreating the contents of the relationship window is
freaking me out.

Any ideas?

Thanks
Martin