 | |
Re: Table relationships lost when ran splitting wizard. WHY?
comp.database.ms-access comp.database.ms-access
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: Table relationships lost when ran splitting wizard. WHY? -
01-26-2004
, 05:42 PM
|
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 |
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.
#2
| |||
| |||
|
|
"Stephen Lebans" ForEmailGotoMy.WebSite.-WWWdotlebans...alid (DOT) com wrote 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. |
#3
| |||
| |||
|
|
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]" <michkap (AT) online (DOT) microsoft.com> wrote in message news:4015a5ea$1 (AT) news (DOT) microsoft.com... "Stephen Lebans" ForEmailGotoMy.WebSite.-WWWdotlebans...alid (DOT) com wrote in message news:AAWQb.73411$IF6.1865635 (AT) ursa-nb00s0 (DOT) 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. |
#4
| |||
| |||
|
|
I actually wanted to go that route Michael but you have not published the Source code!<grin |
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.
#5
| |||
| |||
|
|
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? |
this. Of course, if they do then they have a wizard to update (the Print
Relationships wizard), so they may well keep it stable.
Quote:
|
For anyone interested the relevant BLOB is in the MSysObjects table. The desired row has a NAME field = "ADMIN". |
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.
#6
| |||
| |||
|
|
"Stephen Lebans" ForEmailGotoMy.WebSite.-WWWdotlebans...alid (DOT) 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 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. |
#7
| |||
| |||
|
|
"Stephen Lebans" ForEmailGotoMy.WebSite.-WWWdotlebans...alid (DOT) 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. |
#8
| |||
| |||
|
|
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). |
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
#9
| |||
| |||
|
|
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. |
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
#10
| |||
| |||
|
|
"Michael \(michka\) Kaplan [MS]" <michkap (AT) online (DOT) 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 |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.