Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Access tables on different computers

Discussion in 'Information Technology' started by John, Jul 28, 2006.

  1. John

    John
    Expand Collapse
    Guest

    I have a problem opening tables on different computers. I always have to
    import them again if I e-mail them between the office and home. Is there any
    way of setting access up so that I do not have to do this every time?
     
  2. Loading...


  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    John wrote:
    > I have a problem opening tables on different computers. I always have
    > to import them again if I e-mail them between the office and home. Is
    > there any way of setting access up so that I do not have to do this
    > every time?


    What access do you have to the different computers? Do you share a LAN?
    Give us some idea of what is happening to the data? Does everyone view and
    EDIT the data, or are you just sharing a database where only one source
    edits the data?

    --
    Joseph Meehan

    Dia duit
     
  4. John

    John
    Expand Collapse
    Guest

    Thanks for responding. I have access to a computer at the office which is on
    a network but I am the only one with access to the particular database. I
    sometimes want to work on the data at home so I send it there by e-mail. When
    I go to open it at home on my pc I have to import the tables again - I
    presume the database is set
    for the "H" drive at work and when I copy it to my "D" drive at home the
    program doesn't recognize the path. I thought I read in a manual somewhere
    that there was a way of correcting this problem. Am I making myself more
    clear or is there more information you need.
    Thanks again.
    JOhn
    "Joseph Meehan" wrote:

    > John wrote:
    > > I have a problem opening tables on different computers. I always have
    > > to import them again if I e-mail them between the office and home. Is
    > > there any way of setting access up so that I do not have to do this
    > > every time?

    >
    > What access do you have to the different computers? Do you share a LAN?
    > Give us some idea of what is happening to the data? Does everyone view and
    > EDIT the data, or are you just sharing a database where only one source
    > edits the data?
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
    >
    >
     
  5. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    John wrote:
    > Thanks for responding. I have access to a computer at the office
    > which is on a network but I am the only one with access to the
    > particular database. I sometimes want to work on the data at home so
    > I send it there by e-mail. When I go to open it at home on my pc I
    > have to import the tables again - I presume the database is set
    > for the "H" drive at work and when I copy it to my "D" drive at home
    > the program doesn't recognize the path. I thought I read in a manual
    > somewhere that there was a way of correcting this problem. Am I
    > making myself more clear or is there more information you need.
    > Thanks again.
    > JOhn
    > "Joseph Meehan" wrote:


    Do you mean 're-link' the tables? or are you opening a copy of the
    database that was still on your machine and you are importing the tables
    from the mdb file you e-mailed from work. In the second case you should be
    able to open the copy of the file from work to where you copied it.

    If you are copying files, what are you copying them from? If it is a
    mdb file, why not just open that file?

    >
    >> John wrote:
    >>> I have a problem opening tables on different computers. I always
    >>> have to import them again if I e-mail them between the office and
    >>> home. Is there any way of setting access up so that I do not have
    >>> to do this every time?

    >>
    >> What access do you have to the different computers? Do you
    >> share a LAN? Give us some idea of what is happening to the data?
    >> Does everyone view and EDIT the data, or are you just sharing a
    >> database where only one source edits the data?
    >>
    >> --
    >> Joseph Meehan
    >>
    >> Dia duit


    --
    Joseph Meehan

    Dia duit
     
  6. SusanV

    SusanV
    Expand Collapse
    Guest

    What error message are you getting?

    "John" <John@discussions.microsoft.com> wrote in message
    news:853BC45D-01F1-4F64-8AFD-AB0058D599EF@microsoft.com...
    > Thanks for responding. I have access to a computer at the office which is
    > on
    > a network but I am the only one with access to the particular database. I
    > sometimes want to work on the data at home so I send it there by e-mail.
    > When
    > I go to open it at home on my pc I have to import the tables again - I
    > presume the database is set
    > for the "H" drive at work and when I copy it to my "D" drive at home the
    > program doesn't recognize the path. I thought I read in a manual somewhere
    > that there was a way of correcting this problem. Am I making myself more
    > clear or is there more information you need.
    > Thanks again.
    > JOhn
    > "Joseph Meehan" wrote:
    >
    >> John wrote:
    >> > I have a problem opening tables on different computers. I always have
    >> > to import them again if I e-mail them between the office and home. Is
    >> > there any way of setting access up so that I do not have to do this
    >> > every time?

    >>
    >> What access do you have to the different computers? Do you share a
    >> LAN?
    >> Give us some idea of what is happening to the data? Does everyone view
    >> and
    >> EDIT the data, or are you just sharing a database where only one source
    >> edits the data?
    >>
    >> --
    >> Joseph Meehan
    >>
    >> Dia duit
    >>
    >>
    >>
     
  7. Ron2006

    Ron2006
    Expand Collapse
    Guest

    It sounds like you have the following setup:
    1) a FE-BE configuration
    2) You are emailing yourself the two mdbs and saving them to you
    harddrive at home and trying to work on them and you have to re-link
    the tables in order to work.

    Here is what we had to do for a similar situation
    1) Create a Clear Link Macro. It should do a deleteobject of all the
    linked tables.
    2) Create a Create-Home-Link Macro. It should do a "TransferDatabase"
    - LINK to ALL of your linked tables and have it point to the harddrive
    at home

    3) Create a Create-Work-Link Macro. It should do a "TransferDatabase"
    - LINK to ALL of your linked tables and have it point to the H drive
    location for the tables.

    Optional
    Create a Setup Home macro that executes macro 1 and 2.
    Create a Setup Work Macro that executes macro 1 and 3.
     
  8. redmond54

    redmond54
    Expand Collapse
    Guest

    No
    I just e-mail the tables not the entire mdb.
    Does that make a difference in the instructions you gave me ?

    Thanks in advance.
    John

    "Ron2006" wrote:

    > It sounds like you have the following setup:
    > 1) a FE-BE configuration
    > 2) You are emailing yourself the two mdbs and saving them to you
    > harddrive at home and trying to work on them and you have to re-link
    > the tables in order to work.
    >
    > Here is what we had to do for a similar situation
    > 1) Create a Clear Link Macro. It should do a deleteobject of all the
    > linked tables.
    > 2) Create a Create-Home-Link Macro. It should do a "TransferDatabase"
    > - LINK to ALL of your linked tables and have it point to the harddrive
    > at home
    >
    > 3) Create a Create-Work-Link Macro. It should do a "TransferDatabase"
    > - LINK to ALL of your linked tables and have it point to the H drive
    > location for the tables.
    >
    > Optional
    > Create a Setup Home macro that executes macro 1 and 2.
    > Create a Setup Work Macro that executes macro 1 and 3.
    >
    >
     
  9. Ron2006

    Ron2006
    Expand Collapse
    Guest

    Yes, it makes a big difference.

    But first of all, is the application split - meaning does it have one
    mdb for the tables and one mdb for the forms, etc.?

    In a sense, if you zipped the mdb and emailed that, all you would have
    to do is unzip/extract the mdb at the receiving location and save the
    mdb on top of the prior one and have a whole lot less to do.
     
  10. redmond54

    redmond54
    Expand Collapse
    Guest

    I enter the data in several Excel tables - because I find it easier to do
    calculatons in that program - and then import them into one mdb so as to
    produce reports. When I e-mail the tables to the other location they must be
    linked each time so as to produce reports.


    "Ron2006" wrote:

    > Yes, it makes a big difference.
    >
    > But first of all, is the application split - meaning does it have one
    > mdb for the tables and one mdb for the forms, etc.?
    >
    > In a sense, if you zipped the mdb and emailed that, all you would have
    > to do is unzip/extract the mdb at the receiving location and save the
    > mdb on top of the prior one and have a whole lot less to do.
    >
    >
     
  11. Ron2006

    Ron2006
    Expand Collapse
    Guest

    Excel Tables ???

    Since the reports are produced from the mdb, IMPORT (not link) the
    excell data into one mdb and then zip and email the mdb. Then all they
    have to do is extract the mdb and put it on top of the previous
    version. No relinking is required. - just replace the mdb.
     

Share This Page