Gary,

 

Why cannot I not just run the cygwin cron jobs under the same account as Apache httpd is using? That ought to fix the problem. Can someone tell me where in the httpd.conf file I specify the account that Apache httpd uses? I thought I saw it in there once.

 

If it is not specified there, what is the account that the web server is running under?

 

Sieg

 


From: Garry Taylor
Sent: Friday, April 14, 2006 8:15 AM
To: users@httpd.apache.org
Subject: RE: [EMAIL PROTECTED] How to populate MSAccess Database while Apache HTTPD Queries it?

 

 

 

-----Original Message-----
From: Siegfried Heintze [mailto:[EMAIL PROTECTED]
Sent: 14 April 2006 15:08
To: users@httpd.apache.org
Subject: [EMAIL PROTECTED] How to populate MSAccess Database while Apache HTTPD Queries it?

 

Sorry if this appears twice. When I did not see it echo I sent it again

-----Original Message-----

From: siegfried [mailto:[EMAIL PROTECTED]]

Sent: Thursday, April 13, 2006 6:16 PM

To: 'users@httpd.apache.org'

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

Reply via email to