ODBC performance

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ticotion - 07 Jan 2008 15:36 GMT

Hi

I have an access (access 97) database that consist of data for labels. These
data are via an external program mixed with the label layout and thereafter
printed on labels.
The external program uses an ODBC driver to access a table in the access db.
The problem is that when an user are editing label data while you try to
start up the external program, the startup time for the external program is
very slow (8min). But if you then close down the access DB it's fairly fast
(20 sek). As an Access newbie it seems as if the problem is allocated to the
ODBC and Access 97 connection, but I don't know how to solve it. Can anyone
help with ideas?

regards
Ticotion

Reply to this Message

Tom van Stiphout - 08 Jan 2008 03:42 GMT

What did the vendor of that external program have to say about this?
-Tom.

>Hi
>
[quoted text clipped - 11 lines]
>regards
>Ticotion

Reply to this Message

david - 09 Jan 2008 06:01 GMT

Probably not much you can do about it: the ODBC app may be just built
that way. However, you can look at Tony's performance FAQ:

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

For an A97 database, you should still have
Subdatasheet Name property set to [Auto] should be [None],
http://support.microsoft.com/?kbid=261000
You will have to run the code from VB, VBS, or A2000+,
but you set the database object to be your A97 database instead.

(david)

> Hi
>
[quoted text clipped - 18 lines]
> regards
> Ticotion

Reply to this Message