Connecting Tech Pros Worldwide Forums | Help | Site Map

a2k recovered from corruption, missing relationships

Deano
Guest
 
Posts: n/a
#1: Nov 13 '05
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
Guest
 
Posts: n/a
#2: Nov 13 '05

re: a2k recovered from corruption, missing relationships


"Deano" <deanma66999@hotmail.com> wrote:
[color=blue]
>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.[/color]

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
Guest
 
Posts: n/a
#3: Nov 13 '05

re: a2k recovered from corruption, missing relationships


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
resource@pcdatasheet.com
www.pcdatasheet.com


"Deano" <deanma66999@hotmail.com> wrote in message
news:411052e2$0$12947$ed2619ec@ptn-nntp-reader02.plus.net...[color=blue]
> 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
>
>[/color]


Closed Thread