Welcome to SPN

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

Sign Up Now!

Put a copy of access in another folder

Discussion in 'Information Technology' started by SA, Nov 4, 2005.

  1. SA

    SA
    Expand Collapse
    Guest

    Hi all,
    I wanted to make a read only copy of an access database every night and put
    it in a different folder. Is this doable from within access or would I just
    have to write a script for this?

    Thanks,
    SA.
     
  2. Loading...


  3. Dean

    Dean
    Expand Collapse
    Guest

    Since Access uses VBA, you can write code that does just about anything you
    want. You won't be able to copy the open database but you can have another
    Access file that contains your maintenance code for working with other DBs.

    "SA" <ece3446atyahoodotcom> wrote in message
    news:eSzoeiI4FHA.3876@TK2MSFTNGP09.phx.gbl...
    > Hi all,
    > I wanted to make a read only copy of an access database every night and
    > put it in a different folder. Is this doable from within access or would
    > I just have to write a script for this?
    >
    > Thanks,
    > SA.
    >
     
  4. SA

    SA
    Expand Collapse
    Guest

    Thanks Dean.

    "Dean" <deanl144@hotmail.com.nospam> wrote in message
    news:%23lQ1koI4FHA.3400@tk2msftngp13.phx.gbl...
    > Since Access uses VBA, you can write code that does just about anything
    > you want. You won't be able to copy the open database but you can have
    > another Access file that contains your maintenance code for working with
    > other DBs.
    >
    > "SA" <ece3446atyahoodotcom> wrote in message
    > news:eSzoeiI4FHA.3876@TK2MSFTNGP09.phx.gbl...
    >> Hi all,
    >> I wanted to make a read only copy of an access database every night and
    >> put it in a different folder. Is this doable from within access or would
    >> I just have to write a script for this?
    >>
    >> Thanks,
    >> SA.
    >>

    >
    >
     

Share This Page