RE: Select statement not working

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?