Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Location
    Edmonton, Canada
    Posts
    72

    Unanswered: Refresh Access Client

    Is there a way to update data on a MS Access 2000 client from SQL Server without polling a table using the form's onTimer event?

    It would be much more elegant if I could push the data to the clients every 15-30 minutes when the data on SQL Server gets refreshed.

    Can DTS do this? The forms I'm talking about are select only, no editing.

    I know I can do this with java and multicasting, should work with MM Flash as well with listeners. I would really like to take this app to Flash, but we have a 1 month timeline to port from Access to SQL Server.

    Thanks,
    Carl

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Yes, without using a timer, its just a bit trickier.

    Run it as a batch process, controlled by the windows scheduler. Create a macro / VBA function(s) to do the upload using a mix of queries.

    Or link direct to your SQL server tables (preferably through ODBC and you have instantaneous updates.

    HTH

  3. #3
    Join Date
    Jul 2004
    Location
    Edmonton, Canada
    Posts
    72
    I am actually using SQL Server stored procedures as the recordSource for the forms, so i don'tthink that will work.

    In the DTS documentation, it mentions it can be used to synchronize distributed data, it doens't really say how tho, they talk about server to server, no mentionof client that Ican find.

    Carl

Posting Permissions

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