Ms Access on a network unit

zbee

I have to access a MS Access database, but the problem is that the database is in a shared network unit. I'm having trouble accesing the network unit. I can't even open a txt file on the network unit. It outputs:

Warning: fopen(f:\test.txt): failed to open stream: Invalid argument in c:\web\reporte_test_new.php on line 5

but if I change the file to c:\test.txt it does open the file. I'm thinking that since php executes commands as the user SYSTEM, maybe this user doesn't have acces to the network unit.

Any suggestions, anyone?

tunage

Have you tried putting in the full path of the network path (\server\folder\test.txt) in stead of just f: ?

If that doesnt work it may be that web server doesnt have permission to access the nework drive. Do a search on google about the "IUSR" windows account as this is often the problem.

zbee

yes, I did try to use the full path but it gives the same error:

...the Microsoft Jet Engine cannot open the file ('unknown')...it's open on exclusive mode or you need priviledges to open the file.

But the file is not open. Thanks for the advise; I will look that up on google.

cheese

OK,

A quick question for you, are you using a linux box to access the MS Access. If so I would like to know how to do that as well.

If you are using PHP on a Windows box to access the MS Access file, why not set up an ODBC and then use something like this;

	    

$link = odbc_connect("yourodbcaliasforyourdatabase","sa","",""); 
$row = odbc_exec($link,"SELECT * FROM YourTable");

or something like that.

Cheers,

Neil.

zbee

Ok, let me explain thoroughly the situation. I have a windows in which Apache & PHP are running. Then I have a different server, which is a Linux (Red Hat something) in which the mdb file is at. I'm trying to connect, through ODBC, to that database. Since the Linux server has SAMBA, I can connect to that machine through a network drive (F: ). I set up the ODBC in my windows to point to (F:\1\cajpor.mdb), but it refuses to open the network drive. I tried to point the ODBC to the absolute path too (\IP_NUMBER\1\cajpor.mdb) but it won't work. From the tests I've done the SYSTEM user, which is the one who's executing the PHP scripts, can't have access to the network drives. On the Linux machine I did an chmod 777 to the directories and the files I need, but still no luck.

Any suggestions are greatly welcomed. 😕

cheese

OK,

How about this. Just for a test, copy the mdb file to a Windows machine and try setting the ODBC to that machine.

I am guessing that the ODBC doesn't liek working to the Linux box, as this is the problem I have at the moment.

I run Apach / PHP on a windows box with an mdb on another Windows machine with no problems at all!!

Cheers,

Neil.

zbee

Yes, locally it does work normally.

zbee

Problem solved. What I did was to change the user who was starting the apache server. I changed it to a user on my machine that had access to the remote machine. Then the ODBC point it to the absolute path \REMOTE_IP\1\cajext.mdb and "presto".
Hope this helps.