Win32.client, DAO.DBEngine and exceeding the file sharing count lock

[Tim Golden]

Iain King wrote:
> On Jul 2, 3:29 pm, Tim Golden <m... at timgolden.me.uk> wrote:
>> Iain King wrote:
>>> Hi.  I'm using the win32 module to access an Access database, but I'm
>>> running into the File Sharing lock count as inhttp://support.microsoft.com/kb/815281
>>> The solution I'd like to use is the one where you can temporarily
>>> override the setting using (if we were in VB):
>>> DAO.DBEngine.SetOption dbmaxlocksperfile,15000
>> Really hurried answer:
>>
>> <code>
>> import win32com.client
>>
>> dao = win32com.client.gencache.EnsureDispatch ("DAO.DBEngine.36")
>> dao.SetOption (Option=win32com.client.constants.dbMaxLocksPerFile, Value=15000)
>>
>> </code>
>> TJG
> 
> Thanks.  I found this: http://blogs.msdn.com/michkap/archive/2007/07/13/3849288.aspx
> which outlines some difference between DAO and ADO, including:
> "Capability to set and change Jet options without making registry
> changes (works in DAO through DBEngine.GetOption and
> DBEngine.SetOption, fails in ADO, which has no such analogue)."
> 
> Now, I'm pretty sure I tried to use DAO before and failed to get it to
> work, but maybe you could look at my code and suggest the DAO
> equivalent?

I'm afraid I don't have the relevant experience myself. I'm
sure I could muddle through a few web pages and work
it out (but I'm sure you could, too!)

Sorry

TJG

> aTdHvAaNnKcSe,

PS - Like the .sig