Welcome to SPN

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

Sign Up Now!

Access DB on Mapped drive

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

  1. Amit

    Amit
    Expand Collapse
    Guest

    Hello there,

    I have a situation where we need to transfer data from Sqlserver database to
    an Access database on hourly basis.
    These databases have to be on separate machines.
    This access database is used across 3-4 locations as a backend for a
    client-server application.

    I have been able to map the access database drive on the sqlserver machine
    and then made the access database a linked server. I plan to run the queries
    on the sqlserver to copy data to access tables.
    I was just wondering if there is a better solution available for this
    problem and if there are any potential problems that we could face later on
    when we go live.

    Thanks for your advise.

    AJ
     
  2. Loading...


  3. aaron.kempf@gmail.com

    aaron.kempf@gmail.com
    Expand Collapse
    Guest

    use Access Data Projects instead of copying the data around all the
    time.

    much much simpler setup.

    store a user's table on the serverside if you must.

    -Aaron

    Amit wrote:
    > Hello there,
    >
    > I have a situation where we need to transfer data from Sqlserver database to
    > an Access database on hourly basis.
    > These databases have to be on separate machines.
    > This access database is used across 3-4 locations as a backend for a
    > client-server application.
    >
    > I have been able to map the access database drive on the sqlserver machine
    > and then made the access database a linked server. I plan to run the queries
    > on the sqlserver to copy data to access tables.
    > I was just wondering if there is a better solution available for this
    > problem and if there are any potential problems that we could face later on
    > when we go live.
    >
    > Thanks for your advise.
    >
    > AJ
     

Share This Page