Re: How do I backuo and copy Access data

From: Qal (anonymous_at_discussions.microsoft.com)
Date: 05/07/04

  • Next message: Rick B: "Re: Macro to open a specific record"
    Date: Fri, 7 May 2004 12:44:19 -0700
    
    

    Hi Cheryl,
    Many, many thanks for the advice.
    Qal
     
    >-----Original Message-----
    >> Can anyone please
    >> tell me where exctly are those MDB files located
    >
    >Well, we cannot see your computer. Use Windows
    Explorer to find your MDB
    >files. If the files are located on a network drive,
    you will need to
    >access the mapped drive in Windows Explorer or use
    Network Neighborhood to
    >find the server and then drill-down to the folder in
    which the file or files
    >are located.
    >
    >> and if I
    >> can simply copy them and then drop them in a
    corresponding
    >> folder in another computer to work with the same data
    from
    >> two different PCs.
    >
    >Yes. If your databases involve the use of Linked
    Tables, you may need to
    >use Linked Table Manager to re-link the tables from
    their new location.
    >
    >> two different PCs. Also can I copy data from Access 97
    to
    >> use in a later version of Access, say 2003? Many
    thanks.
    >
    >Yes, and you can also convert the data to 2003 format.
    >--
    >
    >Cheryl Fischer, MVP Microsoft Access
    >Law/Sys Associates, Houston, TX
    >
    >
    >"Qal" <anonymous@discussions.microsoft.com> wrote in
    message
    >news:9b2001c4340d$fc45d270$a501280a@phx.gbl...
    >> I need to backup and transfer data from Access 97. I
    was
    >> advised to copy them from MDB files. Can anyone please
    >> tell me where exctly are those MDB files located and
    if I
    >> can simply copy them and then drop them in a
    corresponding
    >> folder in another computer to work with the same data
    from
    >> two different PCs. Also can I copy data from Access 97
    to
    >> use in a later version of Access, say 2003? Many
    thanks.
    >
    >
    >.
    >


  • Next message: Rick B: "Re: Macro to open a specific record"

    Relevant Pages

    • Re: How do I backuo and copy Access data
      ... Use Windows Explorer to find your MDB ... find the server and then drill-down to the folder in which the file or files ... > two different PCs. ... > advised to copy them from MDB files. ...
      (microsoft.public.access.gettingstarted)
    • Re: setting a password
      ... In the search results, just go to Tools, Folder Options. ... Uncheck 'Hide extensions for known file types', then click on Apply to All ... Microsoft Access MVP ... If you can't find the mdb files, you can always use Start, Search, ...
      (microsoft.public.access.security)
    • RE: Append Query Unable To Display Link List Tables
      ... I tested my mdb files on another computer & the append query works. ... All the mdb files I am trying to work with are in the same folder. ... When I browse and open the correct database, there is no list of tables--it ...
      (microsoft.public.access.queries)
    • Re: my doc redirection
      ... with doc redirect. ... A user with a laptop created 3 .mdb files while connected ... files were uploaded to the user folder on the server. ...
      (microsoft.public.windows.server.sbs)
    • Re: File copy for daily backups
      ... I have a folder which contains two files, both access .mdb files. ... Set fso = CreateObject ...
      (microsoft.public.scripting.vbscript)