Share via

ODBC Refresh Interval

Anonymous
2013-02-27T01:38:24+00:00

What are the downsides and what are the advantages in terms of the front end working faster?

And what are some of the ways I can make the front end work faster? It is connected to two BE data files.

Thanks

HNIM2010

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2013-02-27T17:11:04+00:00

If you talking about a split database, then the ODBC setting you mention is not relevant and is not being used.

So, Access does not use ODBC to connect to a linked Access file (in fact you are not allowed to use an ODBC connection in Access to connect to an access database!).

So the setting you mention will not affect a typical split database, unless the back end is an ODBC database such as SQL server.

As for performance in general? That is a wide question. I would check out this really nice list of issues – some of them can dramatic speed things up:

http://www.granite.ab.ca/access/performancefaq.htm

Albert D. Kallal (Access MVP)

Edmonton, Alberta Canada

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest