Re: Win32.client, DAO.DBEngine and exceeding the file sharing count lock
- From: Iain King <iainking@xxxxxxxxx>
- Date: Thu, 3 Jul 2008 02:01:08 -0700 (PDT)
On Jul 2, 8:13 pm, Tim Golden <m...@xxxxxxxxxxxxxxx> wrote:
In case it helps, there's a recipe just shown up
on the Python Cookbook which at least illustrates
DAO use:
http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/572165
TJG
On Jul 2, 6:30 pm, "M.-A. Lemburg" <m...@xxxxxxxxxx> wrote:
You could try to use the Access ODBC driver and access the database
that way via mxODBC. That would be faster as well:
http://www.microsoft.com/technet/prodtechnol/windows2000serv/technolo...
(scroll down to table 7.1)
Apart from that option and if you are really in need for larger
transactions, I'd suggest that you move to SQL Server for processing
(if you can). Access is not really made for heavy-lifting and big
transactions.
Thanks for the help. I'll check those out, in case there's a
performance gain to be had, but I found that ADO can in fact do
exactly what I want; on the comments of the page I previously linked
to which said ADO couldn't was a posting which refuted some of the
OP's claims; ADO can set some options on it's open connection,
including Max Locks Per Record. My code now looks like this:
self._connection.Open(self._DSN)
if MAX_LOCKS != None:
self._connection.Properties("Jet OLEDB:Max Locks Per File").Value
= MAX_LOCKS
rs = win32com.client.Dispatch(r'ADODB.Recordset')
N.B. I'm writing tools software for a 3rd party app which uses an
Access db as it's output format, so I'm locked in. No way to switch
to SQL server.
Thanks both!
Iain
.
- References:
- Win32.client, DAO.DBEngine and exceeding the file sharing count lock
- From: Iain King
- Re: Win32.client, DAO.DBEngine and exceeding the file sharing count lock
- From: Tim Golden
- Re: Win32.client, DAO.DBEngine and exceeding the file sharing count lock
- From: Iain King
- Re: Win32.client, DAO.DBEngine and exceeding the file sharing count lock
- From: Tim Golden
- Win32.client, DAO.DBEngine and exceeding the file sharing count lock
- Prev by Date: Creating an .exe with Tkinter involved
- Next by Date: PIL(Py Image lib), show() not showing picture...
- Previous by thread: Re: Win32.client, DAO.DBEngine and exceeding the file sharing count lock
- Next by thread: Spell suggest for locations
- Index(es):
Relevant Pages
|
