Results 1 to 4 of 4

Linking tables in frontend and backend

This is a discussion on Linking tables in frontend and backend within the Microsoft Access forums, part of the Question Forums category; I'm sure there is an answer to this question on this board some where but I haven't found it. Each ...

  1. #1
    me2
    me2 is offline
    Board Regular
    Join Date
    Feb 2005
    Posts
    112

    Default Linking tables in frontend and backend

    I'm sure there is an answer to this question on this board some where but I haven't found it.

    Each month I add a new table to my backend database. The frontend database allows the user to select any 2 tables and get the reasons for variance. Usually I run current month to prior month and current month to first of year. But every once in awhile, some manager wants quarterly reports. So I keep all months in the backend.

    I want to have the frontend link to all tables in the backend with the name format of yyyy-mm-dd without me having to create that link.

    How do I do this?

    TIA,

    me

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Ontario, Canada
    Posts
    332

    Default Re: Linking tables in frontend and backend

    why are you even doing this like that? You should have a table with the date field with in it as a field, this consolidates the data within the table?

    It's like you using Access as if it were Excel files in a folder?

    You need to rethink this design, give more details of table structure and process.
    Ziggy
    ô¿ô

  3. #3
    me2
    me2 is offline
    Board Regular
    Join Date
    Feb 2005
    Posts
    112

    Default Re: Linking tables in frontend and backend

    Well for one thing I never thought of that. I'm comparing data from 2 points in time so it made sense to me to have 2 tables to compare. And to have the flexibility to select which to tables to compare.

    It is a fairly ridiculous task anyhow. I'm supposed to take data from a source with no built-in data integrity and explain (in 14 reasons) why the output changed. I’m also have to correctly identify “matching” data when one or more of the identifying characteristics have changed AND correctly determine if data is “different” when none of the characteristics have changed.

    Thanks for your suggestion. I’ll give it a try. While your idea will solve the linking question, I'm not so confident that my computer will play nice with one big table. It pretty grinds to a halt if I don't create multiple backends each with no more than a quarter's worth of data in it. But nothing ventured, nothing gained.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Ontario, Canada
    Posts
    332

    Default Re: Linking tables in frontend and backend

    hey your not alone when it comes to getting assigned ridiculous tasks.....

    There are many ways you can make your life easier, if your worried about one big table slowing you down, then think of it this way....

    Load up a single table as your Archive, and then create a Maketable query (from the archive) along with criteria for date range....this will create a work table for you to query the data you want to work with.

    You can automate this with code/macro's
    Ziggy
    ô¿ô

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com