[Lazarus] MS Access file - is it 'accessible' concurrently ?

[Michael Van Canneyt]

On Wed, 7 Sep 2011, Reinier Olislagers wrote:

> On 7-9-2011 18:00, Dimitri Smits wrote:
>>
>> ----- "Lukasz Sokol" <el.es.cr at gmail.com> 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.