Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.

TOPIC: File sharing lock count exceeded

File sharing lock count exceeded 6 years 4 months ago #2011

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 239
Translated submission in the German forum. You can read the original entry here.

Hello,

When running a relatively simple Definition with an admittedly very large database (Access), I get the following error reported: File sharing lock count exceeded (error 3052).

What does this error signify and how can I get my data conversion to complete?

With the same database I have already run some complex conversions, so I think it cannot be due to the size of the database, or am I wrong?

Greetings from Berlin

Heiko Halaschka
www.gartec.net
Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
The administrator has disabled public write access.

Re:File sharing lock count exceeded 6 years 4 months ago #2012

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 239
Dear Mr Halaschka,

Is it the case that many tables in the Access database are actually linked external references (e.g. dBASE or Excel)? Another possibility is that several users have the database open at the same time. For both cases you can solve the problem by making a simple change in the registry.

Open the program regedit.exe (using Start->Run) and navigate through HKEY_LOCAL_MACHINE to

SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0

Increase the value here for the entry MaxLocksPerFile to a number that is twice or three times (maybe even more) the current value. Thereafter the FlowHeater Definition will function properly.
Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.083 seconds