|
-----Original Message----- Sorry
if this appears twice. When I did not see it echo I sent it again -----Original
Message----- From:
siegfried [mailto:siegfried@xxxxxxxxxxx] Sent:
To:
'users@xxxxxxxxxxxxxxxx' Subject:
Populating Microsoft MDB file and simultaneously querying it I
have some cygwin cron jobs populating a Microsoft Access database while users
are trying to simultaneouly query the database via C#/httpd. I
think my problem is that the cygwin cron jobs are running in the Administrator
account and they create a .mdl file (the lock) under the administrator account
and then, while httpd can open the .mdb file (because I put an access control
list on it), httpd cannot open the mdl file (because the cron job just created
it with the Administrator account). What
account should my cron jobs be running in to be compatible with with httpd? I
think they could all access the database fine if they were all running in the
same account? Thanks, Siegfried I think your
stuffed. You could get the script to make a copy of the database and put all
the new record into that one. Then copy the file over replacing the old one.
You may have you restart Apache with graceful after this, if it changes
anything. Adding records should be ok. Giz |
|