Re: Rebuilding Relationships

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: FBxiii (FBxiii_at_discussions.microsoft.com)
Date: 12/07/04 

Date: Tue, 7 Dec 2004 03:55:02 -0800

Oh, I see.

So, if I have related the tables in the backend, and create a new
relationship in the frontend (mirroring the relationship at the back), it
actually deletes the relationship from the frontend, but the relation still
exists?

Ahha! I think I understand. Does a relationship created in the frontend
actually do anything?

Cheers,
Steve.

"Douglas J. Steele" wrote:

> The relationships must be in the back-end: relationships in the front-end
> don't do anything.
>
> That having been said, relinking the tables shouldn't do anything to the
> relationships.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (No private e-mails, please)
>
>
> "FBxiii" <FBxiii@discussions.microsoft.com> wrote in message
> news:00122578-3C0D-4CF5-8651-8AC0B75E96BC@microsoft.com...
> > No, I am not trying to post this to an agony aunt site :)
> >
> > I have created a front/backend system. The front detects changes in the
> > backend and then re-links all the tables. Unfortunately, this removes the
> > relationships between the tables. There is 1 'central' table, used for
> > tracking the data items passing through the DB. Several other tables are
> > linked to the tracking table via a unique identifier (Primary key).
> >
> > How/if, using code, do I re-create the relationships? Ive got the
> > re-linking bit down to a tee, but all the indexes, etc seem to mess
> up......
> >
> > Cheers for any advice,
> > Steve.
> >
>
>
>

Relevant Pages

  • Re: Design problem : security layers
    ... I'd like to reuse the Objects i write for the frontend in the backend, ... So for the moment what i do is having two packages, ... the credit sub-package will contain all that behaviour that ...
    (comp.lang.java.programmer)
  • Re: Deleting Database Objects
    ... Dim dbs As Database ... > The reason for deleting/re-linking is I want the Frontend to be 'dynamic'. ... > a form/table/report in the backend and update the version number, the> frontend detects this then delete's all the non-system objects and> re-imports ... > "Nikos Yannacopoulos" wrote:>>> Steve, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Compiler textbook available online
    ... Just had a glance over the Alvilda website. ... compiler about a year ago. ... AST (that would be generated by the frontend). ... descent on the backend side as well. ...
    (comp.compilers)
  • Re: Need Help Choosing Digital DVD/VHS Recorder
    ... know it works with my HDTV wonder, but I can't figure out how to run it. ... A single machine has runs both the backend and frontend. ... frontend only machine has no tuners and doesn't run the backend software. ...
    (alt.tv.tech.hdtv)
  • Re: Exchange 2007 frontend with Exchange 2003 backends
    ... - Exchange 2003 frontend ... Users who have their mailbox on the 2007 backend can use the 2007 frontend ... the back-end server, then the front-end server will not work. ...
    (microsoft.public.exchange.setup)