I'm glad I'm not alone in this. It's strange that it only occurs in certain situations, but ours are quite different (I'm using Windows Networking). The main similarities seem to be: win32 platform php4.0.x (CGI) using access over odbc and shared drive I remember trying all sorts of changes to the query, I made it as basic as possible, and it still only returned a few of the results. I think I'll have to try querying a different table and see if that makes a difference. Just a thought: did your mdb file have a password protected .mdw file with it? That's the main difference I can think of mine in the working vs non-working versions. Basically I have two machines, one (machine d) is the database server, the other is the web server (machine w). Php runs on w and queries the database on w for normal web operation. the database on w is updated with a script that runs on w, synchronising data between d and w (I have two DSNs, one to connect to the main database on d and the other to the web database on w). the update script is run by the windows scheduler from php on the command line and works (but only when a user is logged on; if no user is logged on then the script runs, but it can only delete fields, it won't insert new ones - but that's another bug I have yet to trace). What I had tried to do (and this is the bit that doesn't work properly) was connect directly to the database on d from php running on w. and it was this bit that wouldn't report all the results. I wonder if it may be user permissions on the web server, but why make the results sparse, rather than just stop it from working completely? -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
