Relationships

  • Thread starter Thread starter Noel
  • Start date Start date
N

Noel

Hi. I usually work in a backup copy of a database and
then export all my new and ammeded objects when the users
have logged off. When I go to Tables view and click on
Relationships, I see that the table relationship links
have disapeared. Probably because I export in a new
version of an existing table, then change the names of
the old and new ones to bring the new one into play.

The database seems to continue to work perfectly well.
Does it remember the relationships I created in the first
place? Should I recreate the broken links in the
Relationships view?

Thanks, Noel
 
Noel said:
Hi. I usually work in a backup copy of a database and
then export all my new and ammeded objects when the users
have logged off.
Click to expand...

You want to split the MDB into a front end containing the queries,
forms, reports, macros and modules with just the tables and
relationships. The FE is copied to each network users computer. The
FE MDB is linked to the tables in the back end MDB which resides on a
server. You make updates to the FE MDB and distribute them to the
users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp.htm for more info. See
the Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. It also supports Terminal Server/Citrix quite nicely.

You will still have to have the users logged off to add fields to
tables already in use.
When I go to Tables view and click on
Relationships, I see that the table relationship links
have disapeared. Probably because I export in a new
version of an existing table, then change the names of
the old and new ones to bring the new one into play.

The database seems to continue to work perfectly well.
Does it remember the relationships I created in the first
place? Should I recreate the broken links in the
Relationships view?
Click to expand...

Yes, you should definitely be using relationships. They help with
data integrity issues and help keep you from screwing up such things
as subforms.

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

The problem though is that your relationships themselves may be
missing. However having the relationships window copied will save a
lot of time.

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
 
Back
Top