Database Crashes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Just a general question for you.

I have a form that has a picture frame attached to it. When the user
navigates from record to record, the picture frame is updated with a new link
from the current record. (I do not store pictures in the table, just the
path)

Everything works correclty, however, if the user scrolls too quickly through
the records, the database shuts down.

Would this be a result of the code not being able to run as fast as the
navigation of the user? Is there any way to prevent this from happening?

Thanks for your advice!!
 
Yes, you are on the mark. It is the speed of data transfer. Remedy this by
only showing the picture when you click a button.
 
Hi,

TT schreibselte:
Just a general question for you.

I have a form that has a picture frame attached to it. When the user
navigates from record to record, the picture frame is updated with a
new link from the current record. (I do not store pictures in the
table, just the path)

Everything works correclty, however, if the user scrolls too quickly
through the records, the database shuts down.

Would this be a result of the code not being able to run as fast as
the navigation of the user? Is there any way to prevent this from
happening?
Click to expand...

It's the progress-dialog.

You can deactivate it by editing the registry

Enter the specific format (jpg, jpeg, gif...) instead <format>

<=Access 2000:
=Access 2002:
Click to expand...
HKEY_CURRENT_USER\Software\Microsoft\Shared Tools\Graphics Filters\Import\<format>\Options
Key: ShowProgressDialog -> No


Acki
 
Thank you both for your suggestions.

I tried Jorg's suggestion first as it was the easiest and it appears to have
worked. I can whip through the records without having any crash problems.

tynerr, thanks also for your suggestion. I could see when this idea may
also be of value.

Thanks again!
 
Hi Jorg

I have the same problem, and I found your solution is work on single PC.
However, my database will send and share with many users in different
countries, it may not possible for me to edit their registry.

Anyway to edit their registry by the VB code? or we can handle this problem
with other solutions?

Thanks & regards
Eddy
 
Back
Top