By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,659 Members | 1,750 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,659 IT Pros & Developers. It's quick & easy.

Automatic update of linked ODBC tables

P: n/a
I have a network server with MySQL on it and I am trying to make
access update the information it has in its linked table on startup or
command. I know nearly nothing about macros or modules. I am
basically wanting to make sure that the data access is displaying is
the most current data on the server.

Thanks.
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On 6 Jun 2004 10:45:55 -0700, ky**@kylearrington.com (Kyle Arrington)
wrote:

As opposed to what? Do you think Access would surreptitiously cache
some data from a few days ago and show that to you instead? Please
explain what you are concerned about.

-Tom.
I have a network server with MySQL on it and I am trying to make
access update the information it has in its linked table on startup or
command. I know nearly nothing about macros or modules. I am
basically wanting to make sure that the data access is displaying is
the most current data on the server.

Thanks.


Nov 13 '05 #2

P: n/a
Nevermind. I am an idiot.

Tom van Stiphout <to*****@no.spam.cox.net> wrote in message news:<p5********************************@4ax.com>. ..
On 6 Jun 2004 10:45:55 -0700, ky**@kylearrington.com (Kyle Arrington)
wrote:

As opposed to what? Do you think Access would surreptitiously cache
some data from a few days ago and show that to you instead? Please
explain what you are concerned about.

-Tom.
I have a network server with MySQL on it and I am trying to make
access update the information it has in its linked table on startup or
command. I know nearly nothing about macros or modules. I am
basically wanting to make sure that the data access is displaying is
the most current data on the server.

Thanks.

Nov 13 '05 #3

P: n/a

"Kyle Arrington" <ky**@kylearrington.com> wrote in message
news:12**************************@posting.google.c om...
Nevermind. I am an idiot.


Not really, although you will probably still feel at home here in CDMA.

ODBC data are one thing. ODBC properties are another.

In a multi-user environment you only see new data when your application
specifically asks for it or when ODBC refresh is triggered, usually every
1500 seconds by default.

Changes to ODBC properties, such as a new field being created in an ODBC
table, may not show up at all in your Access front end until the ODBC links
are refreshed.
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.