Tim Roberts wrote:I know, I know... just imagine that before accepting this job I didn't even know Access *could* be used *like* one, I always thought it was like a toy sqlite with fancy UI for single users.Access is trouble any time you have more than about 2 people using a single database. It just wasn't designed for that environment. Indeed, which is what I'm going to do in the long term, rewrite the application.Surely it would be MUCH less trouble to move the backend to Postgres, SQLite, or even SQL Server Express, all of which are free. It is just a VB without source code which talks to the database through a DNSless connection, which really means I can't do what I was proposing, since that would mean changing the original VB application to use a specific ODBC, and I can't. I'm just asking because I'm curious about this sort of serializing gateway "architecture".Is the original application in Access? Or is it another language that just happens to use the Jet database? What API does it use to talk to the database? In fact, does sqlite run on windows with multiple writers shared through SMB? I know sqlite works with multiple writers, but my experience so far is only under linux, so I would like to know if that works on windows the same way or there are problems like the horror stories I've heard about NFS locking. Any weird suggestions appreciated, not doing anything real here, just toying with the idea of doing something perverse (if using Access wasn't enough!). --
|
_______________________________________________ Python-win32 mailing list Python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32
