On Wed, 7 Sep 2011, Reinier Olislagers wrote:
On 7-9-2011 18:00, Dimitri Smits wrote:
----- "Lukasz Sokol" <[email protected]> schreef:
Hi Group,
http://wiki.lazarus.freepascal.org/ODBCConn
http://wiki.lazarus.freepascal.org/MS_Access
do not contain this information :
Can I open the same database and access (read/write)
the same (few) table(s) from 2 or more concurrently
running programs (written in Lazarus of course) using
the MDB (MS Office Access) as the underlying file?
Or will I need (MS) (SQL) Server?
Pointers welcome :)
Access ALWAYS was intended for non-concurrent access (pun intended :-))!
When you want to use concurrent access, you should use MS SQL if you want to
stay in the same/similar dialect/syntax realm.
The problem stems in part from the fact that it is an embedded DB engine (even
if over ODBC) as opposed to a dedicated, dispatching and mitigating server in a
client/server setting that handles the concurrency issues.
Eeehm, yes, it is a file-based database system.
Still, Access developers have succesfully (and cheaply) been developing
quite reliable, split Access front-end (GUI)/back end (data) solutions
for department-level use.
I forwarded this answer to our helpdesk.
They're now all in the reanimation section of the nearest hospital,
after which they'll be held for 6 months of treatment in the local
psychiatric ward.
"Concurrent", "MS-Access" and "reliable" in one sentence was just too
much for them...
Michael.
--
_______________________________________________
Lazarus mailing list
[email protected]
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
