Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Automatically Update Linked Tables

Automatically Update Linked Tables

Automatically Update Linked Tables

I'm trying to set up an automated procedure that runs a Crystal report against an Access database.  The tables in Access are ODBC linked to an AS400 database.  I need the linked tables to refresh when Access opens the database.  Is there a script, macro, or command line option I can use to do this?  Thanks.

RE: Automatically Update Linked Tables

I'm not sure what you mean by "refresh". Linked tables display live/current data from the source.  

Hook'D on Access
MS Access MVP

RE: Automatically Update Linked Tables

I created an MDB linking to some tables on an AS400.  I thought the data was stored in the MDB and needed to be refresed by updating them using the linked table manager. No?


RE: Automatically Update Linked Tables

If the tables are linked rather than imported, the data should be "fresh".  

Hook'D on Access
MS Access MVP

RE: Automatically Update Linked Tables

OK. I figure this out:  I couldn't understand how a 1/2 gig database could be "live" constantly and didn't need to be refreshed.  

So I ran a query, changed a record in the database, ran the query again and the data was updated. I was surprised.

What happened was when I originally created the database I had imported the data, then ended up doing some research and creating linked tables instead and deleting the original tables.

I did a compact and repair and now the MDB file is small.

One thing I don't understand is why running a Crystal Report against an AS400 database is slow, but running the same Crystal Report against Access tables that are linked to the same AS400 database is lightning fast.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close