RE: FN-FORUM: Access - how it works..

date posted 21st January 2005 15:17


> -----Original Message-----
> From: Nicola Dunn [EMAIL REMOVED]
> Sent: 21 January 2005 14:59
> To: FN-FORUM / [EMAIL REMOVED]
> Subject: FN-FORUM: Access - how it works..
>
> This may be a bit of an odd question, but I'll ask it anyway.
>
> I've used MySQL quite a bit, but I'm not really a DB whizz.
> MySQL, though, sits back and runs itself, whatever you're
> doing otherwise. You could be completely ignoring it, but
> it'll run. And if someone does something to it, it's there,
> updated, still running. You can code things to tell you if
> something has changed (I believe...), and it will do it
> because it's always running.
>
> Access though... is it just like a word document?
> I open the access database and do whatever work I need to do,
> and then I close it.
>
> Is the DB actually running in the background somewhere? Or is
> it just like any other MS file? Can I make it tell me if
> something is changed?
>
> Not sure if this makes any sense...
>
> Nicola

Makes perfect sense.

Yes it is purely file based, so it only opens it while accessing it,
though depending on how the code to access it is written it may hold the
file open over successive operations.

MySQL, Microsoft SQL Server, Oracle, PostGresSQL etc. all have an
'executable' (for want of better word) that runs and controls
(practically) all access to the database file(s).

HTH,

Dai

TechnologyAngel
http://www.technologyangel.co.uk/