performance problem with runtime

[Andreas Wöckl]

hi group!

i want to use the access runtime with an access 2003 ade-file. The problem
is that the application is slower with the runtime if i compare it with the
ade startet with the access full version!

anyone an idea?

best regards

andy

 

[aaron.kempf]

give us more details; how many connections; etc?

are you using MSDE?

 

[Philipp Stiefel]

i want to use the access runtime with an access 2003 ade-file. The problem
is that the application is slower with the runtime if i compare it with the
ade startet with the access full version!

anyone an idea?

Looks like nobody has so far...

Maybe you should supply more information about your
problem.

Are there any specific operations that are slower?
What is the environment you're experiencing the
problems in? (network, operating system, etc.)

Cheers
Phil

 

[Andreas Wöckl]

hi Philip!

It seems that I have more troubles with access 2003 - it often prompts with
the message "the record has changed since.." and gives 3 options - "Save
Record", "Discard own changes" (all translated from german).

I can not really find out why I have this problems - I did not have with
access 2000.

This also causes some performance troubles as I have a lot of data in the
clipboard (and do not even know why).

any known issues about that?

best regards

andy

 

[Philipp Stiefel]

It seems that I have more troubles with access 2003 - it often prompts with
the message "the record has changed since.." and gives 3 options - "Save
Record", "Discard own changes" (all translated from german).

Is the record changed by a trigger upon saving? Access compares
the record before and after saving and if there are any unexpected
changes if deduces another user must have changed the record, which
usually is not true.

It may be possible to workaround this issue by defining an apropriate
ResyncCommand (Form-Property) for the Form you're experiencing the
problem in.

I can not really find out why I have this problems - I did not have with
access 2000.

I haven't enough experience with Acc2003 ADP/ADEs yet to come up with
any possible explanation what's changed there. - However, a really
good approach to analyze problems like this is tracing the whole
session with SQL-Server Profiler.

This also causes some performance troubles as I have a lot of data in the
clipboard (and do not even know why).

any known issues about that?

If you're copying a couple of large records (containing TEXT or
IMAGE data) this may have quite an impact on the performance of
the client application just by consuming a serious amount of
memory.

Best wishes
Phil

 

[aaron.kempf]

MDB is a piece of crap database; use SQL Server or give it to someone
who does

Access Data Projects make it easy and fun to learn SQL.


count on using MSDE 2.0; it's free at www.asp.net i believe or
microsoft.com/sql and look for downloads and SP4; and then MSDE.. you
want to download the latest version since it comes integrated with SP4

 

[Robert Morley]

Yes Aaron, we're all aware of your views on MDB/ADP (and, frankly, many of
us agree with them!), but that's not helping this person with his immediate
problem, and is therefore irrelevant to this thread. If you want to post
your views on MDB/ADP's, why don't you simply start a new thread,
appropriately titled, and we can all debate the matter ad nauseum.


Rob