By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,446 Members | 3,120 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,446 IT Pros & Developers. It's quick & easy.

Table relationships lost when ran splitting wizard. WHY?

P: n/a
Ed
I am running Access 2002 and just ran the built in Access wizard for
splitting a database into a back end (with tables) and front end (with
queries, forms, modules, etc.).

After running the wizard, I opened the table relationship view and noticed
that all the relationships are missing. Is this supposed to happen? If so,
why? I've noticed that queries are behaving strangely now, seemingly
because the relationships are not established.

Am I supposed to go into the back end database and reestablish the
relationships? Or, am I supposed to do that in the front end database.

This behavior seems odd. Is this an Access 2002 bug?

Thank you for your help!

Ed

Nov 12 '05 #1
Share this Question
Share on Google+
20 Replies


P: n/a
"Ed" <an*******@discussions.com> wrote:
I am running Access 2002 and just ran the built in Access wizard for
splitting a database into a back end (with tables) and front end (with
queries, forms, modules, etc.).

After running the wizard, I opened the table relationship view and noticed
that all the relationships are missing. Is this supposed to happen? If so,
why?
It shouldn't but then I've never used the splitting wizard. I'd go into the BE and
see if the relationship view is still there. You may need to click on the Show All
button on the tool bar.

If the layout is missing then use the appropriate sysrels tool from
www.trigeminal.com to copy the relationships window layout.

And if the relationships are not indeed in the backend you can still use the sysrels
utility to copy the relationships window layout. You'll have to drag and drop the
relationships yourself but that'll be less work.
I've noticed that queries are behaving strangely now, seemingly
because the relationships are not established.
Tell us more.
Am I supposed to go into the back end database and reestablish the
relationships? Or, am I supposed to do that in the front end database.


No, relationships are always created in the MDB in which the tables reside.

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
Nov 12 '05 #2

P: n/a
Tony Toews wrote:
"Ed" <an*******@discussions.com> wrote:
I am running Access 2002 and just ran the built in Access wizard for
splitting a database into a back end (with tables) and front end (with
queries, forms, modules, etc.).

After running the wizard, I opened the table relationship view and noticed
that all the relationships are missing. Is this supposed to happen? If so,
why?


It shouldn't but then I've never used the splitting wizard. I'd go into the BE and
see if the relationship view is still there. You may need to click on the Show All
button on the tool bar.

If the layout is missing then use the appropriate sysrels tool from
www.trigeminal.com to copy the relationships window layout.

And if the relationships are not indeed in the backend you can still use the sysrels
utility to copy the relationships window layout. You'll have to drag and drop the
relationships yourself but that'll be less work.


Tony, in one app I did I set my relationships in I visited the relationships window
later on and the window had myriads of tables in it, lines crisscrossing all over the
place. It looked like a spaghetti western. Is that normal as you define an application
and build and expand it?
Nov 12 '05 #3

P: n/a
Salad <oi*@vinegar.com> wrote:
Tony, in one app I did I set my relationships in I visited the relationships window
later on and the window had myriads of tables in it, lines crisscrossing all over the
place. It looked like a spaghetti western. Is that normal as you define an application
and build and expand it?


No. Or rather some of mine do indeed look like spaghetti but then I
designed the layouts that way. <smile> One of mine prints on a 48"
plotter and takes three feet of paper.

I have had that happen when I import the BE into a new BE. The
tables are placed on a grid and the lines are running all over the
place.

But this is where the sysrels utility comes in. It will copy the old
relationships window layout.

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
Nov 12 '05 #4

P: n/a
Just as an add-in to this thread there is a utility on my site that
allows you to save/restore multiple views of the Relationship window.
http://www.lebans.com/saverelationshipview.htm
NEW - Jan 21/2004 A2KSave-RestoreRelationshipWindow.zip is an MDB
containing functions to Save and Restore the Relationships View Window.
Allows an unlimited number of different Relationship Window Views to be
saved.

Here is the Access97 version:A97Save-RestoreRelationshipWindow.zip
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Tony Toews" <tt****@telusplanet.net> wrote in message
news:c4********************************@4ax.com...
Salad <oi*@vinegar.com> wrote:
Tony, in one app I did I set my relationships in I visited the relationships windowlater on and the window had myriads of tables in it, lines crisscrossing all over theplace. It looked like a spaghetti western. Is that normal as you define an applicationand build and expand it?


No. Or rather some of mine do indeed look like spaghetti but then I
designed the layouts that way. <smile> One of mine prints on a 48"
plotter and takes three feet of paper.

I have had that happen when I import the BE into a new BE. The
tables are placed on a grid and the lines are running all over the
place.

But this is where the sysrels utility comes in. It will copy the old
relationships window layout.

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


Nov 12 '05 #5

P: n/a
"Stephen Lebans" <Fo****************************************@linval id.com>
wrote in message news:AA*********************@ursa-nb00s0.nbnet.nb.ca...
Just as an add-in to this thread there is a utility on my site that
allows you to save/restore multiple views of the Relationship window.
http://www.lebans.com/saverelationshipview.htm
NEW - Jan 21/2004 A2KSave-RestoreRelationshipWindow.zip is an MDB
containing functions to Save and Restore the Relationships View Window.
Allows an unlimited number of different Relationship Window Views to be
saved.

Here is the Access97 version:A97Save-RestoreRelationshipWindow.zip


Very clever! Though you could have saved a bunch of time using the built in
Access methods for storing different views by using the SysRel utility I
wrote. :-)
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.

Nov 12 '05 #6

P: n/a
On Mon, 26 Jan 2004 15:42:47 -0800, "Michael \(michka\) Kaplan [MS]"
<mi*****@online.microsoft.com> wrote:
"Stephen Lebans" <Fo****************************************@linval id.com>
wrote in message news:AA*********************@ursa-nb00s0.nbnet.nb.ca...
Just as an add-in to this thread there is a utility on my site that
allows you to save/restore multiple views of the Relationship window.
http://www.lebans.com/saverelationshipview.htm
NEW - Jan 21/2004 A2KSave-RestoreRelationshipWindow.zip is an MDB
containing functions to Save and Restore the Relationships View Window.
Allows an unlimited number of different Relationship Window Views to be
saved.

Here is the Access97 version:A97Save-RestoreRelationshipWindow.zip


Very clever! Though you could have saved a bunch of time using the built in
Access methods for storing different views by using the SysRel utility I
wrote. :-)


Perhaps, I'm not understanding correctly, but I thought the SysRel utility
saved an internal Blob that represents the relationships. Is there any way to
know it's safe to restore those after changes have been made to the tables and
relationships since the time the Blob was saved? That had been my concern.
Nov 12 '05 #7

P: n/a
I actually wanted to go that route Michael but you have not published
the Source code!<grin>
The code only took an hour or so and I enjoyed the mental exercise.
:-)
--

Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Michael (michka) Kaplan [MS]" <mi*****@online.microsoft.com> wrote in
message news:40********@news.microsoft.com...
"Stephen Lebans" <Fo****************************************@linval id.com> wrote in message news:AA*********************@ursa-nb00s0.nbnet.nb.ca...
Just as an add-in to this thread there is a utility on my site that
allows you to save/restore multiple views of the Relationship window. http://www.lebans.com/saverelationshipview.htm
NEW - Jan 21/2004 A2KSave-RestoreRelationshipWindow.zip is an MDB
containing functions to Save and Restore the Relationships View Window. Allows an unlimited number of different Relationship Window Views to be saved.

Here is the Access97 version:A97Save-RestoreRelationshipWindow.zip


Very clever! Though you could have saved a bunch of time using the

built in Access methods for storing different views by using the SysRel utility I wrote. :-)
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.



Nov 12 '05 #8

P: n/a
Michael I finally took a look at the BLOB data in the MSysObjects table.
I was able to decipher the indvidual window coordinates from the data.
Without voiding any NDA you are under can you tell me if the location of
the window coordinates are fixed/static across all versions of Access?
Or do I need to continue to decipher the header for this BLOB?
For anyone interested the relevant BLOB is in the MSysObjects table. The
desired row has a NAME field = "ADMIN".

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Stephen Lebans"
<Fo****************************************@linval id.com> wrote in
message news:2U*********************@ursa-nb00s0.nbnet.nb.ca...
I actually wanted to go that route Michael but you have not published
the Source code!<grin>
The code only took an hour or so and I enjoyed the mental exercise.
:-)
--

Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Michael (michka) Kaplan [MS]" <mi*****@online.microsoft.com> wrote in
message news:40********@news.microsoft.com...
"Stephen Lebans" <Fo****************************************@linval id.com>
wrote in message

news:AA*********************@ursa-nb00s0.nbnet.nb.ca...
Just as an add-in to this thread there is a utility on my site that allows you to save/restore multiple views of the Relationship window. http://www.lebans.com/saverelationshipview.htm
NEW - Jan 21/2004 A2KSave-RestoreRelationshipWindow.zip is an MDB containing functions to Save and Restore the Relationships View Window. Allows an unlimited number of different Relationship Window Views
to be saved.

Here is the Access97 version:A97Save-RestoreRelationshipWindow.zip

Very clever! Though you could have saved a bunch of time using the

built in
Access methods for storing different views by using the SysRel

utility I
wrote. :-)
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.



Nov 12 '05 #9

P: n/a
"Steve Jorgensen" <no****@nospam.nospam> wrote...
Perhaps, I'm not understanding correctly, but I thought the SysRel utility
saved an internal Blob that represents the relationships. Is there any way to know it's safe to restore those after changes have been made to the tables and relationships since the time the Blob was saved? That had been my

concern.

It is perfectly safe, and this is what happens any time you modify schema
outside of Access (using ADO or DAO, etc.) and then later open the window in
Access -- it properly discards items that are no longer present.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.

Nov 12 '05 #10

P: n/a
"Stephen Lebans" <Fo****************************************@linval id.com>
wrote...
I actually wanted to go that route Michael but you have not published
the Source code!<grin>


Ah, I am not allowed to do that. The decipher code was easy enough, but the
writing to the system table is not something I am allowed to release as
source (though in the past I have licensed DLL versions for easy calling
from other tools <grin>),
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.

Nov 12 '05 #11

P: n/a
"Stephen Lebans" <Fo****************************************@linval id.com>
wrote...
Michael I finally took a look at the BLOB data in the MSysObjects table.
I was able to decipher the indvidual window coordinates from the data.
Without voiding any NDA you are under can you tell me if the location of
the window coordinates are fixed/static across all versions of Access?
Or do I need to continue to decipher the header for this BLOB?
Well, its no NDA violation since I dod not know if they ever plan to change
this. Of course, if they do then they have a wizard to update (the Print
Relationships wizard), so they may well keep it stable.
For anyone interested the relevant BLOB is in the MSysObjects table. The
desired row has a NAME field = "ADMIN".


Actually, it is whatever user name is the person looking at the
relationships window (thats why SysRel lets you save it under any name at
all).
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.

Nov 12 '05 #12

P: n/a
Thanks for the info Michael.
:-)

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Michael (michka) Kaplan [MS]" <mi*****@online.microsoft.com> wrote in
message news:40********@news.microsoft.com...
"Stephen Lebans" <Fo****************************************@linval id.com> wrote...
Michael I finally took a look at the BLOB data in the MSysObjects table. I was able to decipher the indvidual window coordinates from the data. Without voiding any NDA you are under can you tell me if the location of the window coordinates are fixed/static across all versions of Access? Or do I need to continue to decipher the header for this BLOB?
Well, its no NDA violation since I dod not know if they ever plan to

change this. Of course, if they do then they have a wizard to update (the Print Relationships wizard), so they may well keep it stable.
For anyone interested the relevant BLOB is in the MSysObjects table. The desired row has a NAME field = "ADMIN".
Actually, it is whatever user name is the person looking at the
relationships window (thats why SysRel lets you save it under any name

at all).
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.


Nov 12 '05 #13

P: n/a
Well since I am not able to write to the system tables I will have to
keep my current method and use DoCmd to Save the current RelationShip
View to the system table.
Thanks Michael.
:-)
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Michael (michka) Kaplan [MS]" <mi*****@online.microsoft.com> wrote in
message news:40******@news.microsoft.com...
"Stephen Lebans" <Fo****************************************@linval id.com> wrote...
I actually wanted to go that route Michael but you have not published the Source code!<grin>
Ah, I am not allowed to do that. The decipher code was easy enough,

but the writing to the system table is not something I am allowed to release as source (though in the past I have licensed DLL versions for easy calling from other tools <grin>),
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.


Nov 12 '05 #14

P: n/a
"Michael \(michka\) Kaplan [MS]" <mi*****@online.microsoft.com> wrote:
For anyone interested the relevant BLOB is in the MSysObjects table. The
desired row has a NAME field = "ADMIN".


Actually, it is whatever user name is the person looking at the
relationships window (thats why SysRel lets you save it under any name at
all).


Ah, yes, I recall a tip from someone, somewhere who stated that if you wanted a
different relationships view to logon to Access using a different userid.

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
Nov 12 '05 #15

P: n/a
"Stephen Lebans" <Fo****************************************@linval id.com> wrote:
Well since I am not able to write to the system tables I will have to
keep my current method and use DoCmd to Save the current RelationShip
View to the system table.


Well, yeah, but there's got to be some way of updating the system tables. After all
Michael can do it inside VB in his sysrels utility.

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
Nov 12 '05 #16

P: n/a
Or you can use my utility to save different views....
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.

"Tony Toews" <tt****@telusplanet.net> wrote in message
news:o9********************************@4ax.com...
"Michael \(michka\) Kaplan [MS]" <mi*****@online.microsoft.com> wrote:
For anyone interested the relevant BLOB is in the MSysObjects table. The desired row has a NAME field = "ADMIN".
Actually, it is whatever user name is the person looking at the
relationships window (thats why SysRel lets you save it under any name at
all).


Ah, yes, I recall a tip from someone, somewhere who stated that if you

wanted a different relationships view to logon to Access using a different userid.

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

Nov 12 '05 #17

P: n/a
"Tony Toews" <tt****@telusplanet.net> wrote:
Well, yeah, but there's got to be some way of updating the system tables. After all Michael can do it inside VB in his sysrels utility.


Yes, if you call Jet directly then there are all kinds of ways around rules.
In this case, the table in question is not secured using Jet security, so it
is easy enough to write data (for tables that have actual Jet security
permissions-based restrictions, this method would not be helpful).
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.

Nov 12 '05 #18

P: n/a
"Stephen Lebans" <Fo****************************************@linval id.com>
wrote...
Well since I am not able to write to the system tables I will have to
keep my current method and use DoCmd to Save the current RelationShip
View to the system table.


Well, one could always call this other tool. Not everything has to be done
in the database to be considered helpful. :-)
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.

Nov 12 '05 #19

P: n/a
Steve I had a chance tonight to publish a more complete Relationship
WIndow Layout tool. I was able to do add the functionality to copy the
Relationship Window Layout from an external MDB as I finally took the
time to decode the Layout BLOB. It was pretty straightforward. The BLOB
structure is documented below.
http://www.lebans.com/saverelationshipview.htm

NEW - Feb 04/2004
http://www.lebans.com/DownloadFiles/...-RelationshipW
indowLayoutver6.zip is an MDB containing functions to:

1) To allow the saving of the layout of the Relationship window to a
table.
2) To allow the restoration of the layout of the Relationship Window
from a table.
3) To allow the saving/restoration of multiple Relationship Window
views.
4) To allow the importing of the layout of the Relationship Window from
an external MDB.
Private Type RECTL
Left As Long
Top As Long
Right As Long
Bottom As Long
End Type
' First 68 Bytes are the Header
' This is followed by (NumWindows + 1) * 284 bytes per record
' Last padding record seems to be padding
Private Type RelBlob
Sig As Long
AAAs(1 To AAAlength) As Byte
RelWinX1 As Long
RelWinY1 As Long
RelWinX2 As Long
RelWinY2 As Long
Blank As Long
FFFs(1 To FFFlength) As Byte
ClientRectX As Long
ClientRectY As Long
Pad(1 To Padding) As Byte
NumWindows As Long
End Type

Private Type RelWindow
RelWinX1 As Long
RelWinY1 As Long
RelWinX2 As Long
RelWinY2 As Long
Junk As Long
WinName As String * NameLengthMax
Junk1 As Long
WinNameMaster As String * NameLengthMax
Junk2 As Long
End Type
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Steve Jorgensen" <no****@nospam.nospam> wrote in message
news:ld********************************@4ax.com...
On Mon, 26 Jan 2004 15:42:47 -0800, "Michael \(michka\) Kaplan [MS]"
<mi*****@online.microsoft.com> wrote:
"Stephen Lebans" <Fo****************************************@linval id.com>
wrote in message news:AA*********************@ursa-nb00s0.nbnet.nb.ca...
Just as an add-in to this thread there is a utility on my site that
allows you to save/restore multiple views of the Relationship window. http://www.lebans.com/saverelationshipview.htm
NEW - Jan 21/2004 A2KSave-RestoreRelationshipWindow.zip is an MDB
containing functions to Save and Restore the Relationships View Window. Allows an unlimited number of different Relationship Window Views to be saved.

Here is the Access97 version:A97Save-RestoreRelationshipWindow.zip

Very clever! Though you could have saved a bunch of time using the

built inAccess methods for storing different views by using the SysRel utility Iwrote. :-)


Perhaps, I'm not understanding correctly, but I thought the SysRel

utility saved an internal Blob that represents the relationships. Is there any way to know it's safe to restore those after changes have been made to the tables and relationships since the time the Blob was saved? That had been my

concern.

Nov 12 '05 #20

P: n/a
I still think saving it in the actual Access format would be cooler. And
there is no shame in having an external library, you know!
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.

"Stephen Lebans" <Fo****************************************@linval id.com>
wrote in message news:%d*********************@ursa-nb00s0.nbnet.nb.ca...
Steve I had a chance tonight to publish a more complete Relationship
WIndow Layout tool. I was able to do add the functionality to copy the
Relationship Window Layout from an external MDB as I finally took the
time to decode the Layout BLOB. It was pretty straightforward. The BLOB
structure is documented below.
http://www.lebans.com/saverelationshipview.htm

NEW - Feb 04/2004
http://www.lebans.com/DownloadFiles/...-RelationshipW
indowLayoutver6.zip is an MDB containing functions to:

1) To allow the saving of the layout of the Relationship window to a
table.
2) To allow the restoration of the layout of the Relationship Window
from a table.
3) To allow the saving/restoration of multiple Relationship Window
views.
4) To allow the importing of the layout of the Relationship Window from
an external MDB.
Private Type RECTL
Left As Long
Top As Long
Right As Long
Bottom As Long
End Type
' First 68 Bytes are the Header
' This is followed by (NumWindows + 1) * 284 bytes per record
' Last padding record seems to be padding
Private Type RelBlob
Sig As Long
AAAs(1 To AAAlength) As Byte
RelWinX1 As Long
RelWinY1 As Long
RelWinX2 As Long
RelWinY2 As Long
Blank As Long
FFFs(1 To FFFlength) As Byte
ClientRectX As Long
ClientRectY As Long
Pad(1 To Padding) As Byte
NumWindows As Long
End Type

Private Type RelWindow
RelWinX1 As Long
RelWinY1 As Long
RelWinX2 As Long
RelWinY2 As Long
Junk As Long
WinName As String * NameLengthMax
Junk1 As Long
WinNameMaster As String * NameLengthMax
Junk2 As Long
End Type
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Steve Jorgensen" <no****@nospam.nospam> wrote in message
news:ld********************************@4ax.com...
On Mon, 26 Jan 2004 15:42:47 -0800, "Michael \(michka\) Kaplan [MS]"
<mi*****@online.microsoft.com> wrote:
"Stephen Lebans" <Fo****************************************@linval id.com>wrote in message news:AA*********************@ursa-nb00s0.nbnet.nb.ca...> Just as an add-in to this thread there is a utility on my site that
> allows you to save/restore multiple views of the Relationship window.> http://www.lebans.com/saverelationshipview.htm
> NEW - Jan 21/2004 A2KSave-RestoreRelationshipWindow.zip is an MDB
> containing functions to Save and Restore the Relationships View Window.> Allows an unlimited number of different Relationship Window Views to be> saved.
>
> Here is the Access97 version:A97Save-RestoreRelationshipWindow.zip
>

Very clever! Though you could have saved a bunch of time using the built inAccess methods for storing different views by using the SysRel utility Iwrote. :-)


Perhaps, I'm not understanding correctly, but I thought the SysRel

utility
saved an internal Blob that represents the relationships. Is there

any way to
know it's safe to restore those after changes have been made to the

tables and
relationships since the time the Blob was saved? That had been my

concern.

Nov 12 '05 #21

This discussion thread is closed

Replies have been disabled for this discussion.