problem with ms-access -- help needed

rb2_ph

hi guys.

ms-access really is giving me a headache.

i have a script using php / ms-access. it works fine when i ran it in my pc (i am using localhost). but problem arises when i uploaded in our server. it doesn't INSERT records. yap, you can view, search and query the database -- but it can't insert records.

sigh can someone help me?

thanks a lot.

pilyo

cheese

What operating system is the Server using please?

Roger_Ramjet

Post your code EXACTLY as it is, and echo the query string if it contains any substituted variable. Access query syntax is VERY different from mysql, or most other RDBMS for that matter. Date and string delimiters cause many problems through ODBC, as does the correct syntax for table and field names. See the notes in odbc_exec to see what I mean.

Access query syntax

SELECT [table1].[field1], [table1].[field2] FROM table1 WHERE (([table1].[field1])='blah')

is the way it goes.

If you are using Access then you can use query designer to generate the sql and then paste it into your script.

Better yet, save the query and call it by name using ODBC_EXEC. You can even create a parameter query and pass the parameters at run time; though the code for that looks a bit scary.

rb2_ph

Originally posted by cheese
What operating system is the Server using please?

Windows NT
MS-IIS 6.0

Roger_Ramjet

Have you got write privileges on the directory and mdb file on the server. Remember, IIS is going to see you as IUSR_etc and by default the NTFS privileges will be read-only. You need to add the IUSR to the NTFS list with write privileges on the data file.

rb2_ph

Originally posted by Roger Ramjet
Have you got write privileges on the directory and mdb file on the server. Remember, IIS is going to see you as IUSR_etc and by default the NTFS privileges will be read-only. You need to add the IUSR to the NTFS list with write privileges on the data file.

Hi. thanks for the info. but i'm not familiar with n.o.s. stuffs. how do u do that? we are only hosted and subscribed to a paid webhost. anyway, i checked the properties of my .mdb file and it has all the privileges - read, write and execute (777). is this ok?

i also tried some .asp scripts in writing to that database. still the same prob occurs.

sigh

many thanks.

Roger_Ramjet

OK. I forgot that you also need to set the web site properties to Write in IIS as well: well actaually I assumed that they would have been set correctly as soon as you told your host you wanted a databse file in it. But then, that is the sort of common sense thing that one does NOT expect from commercail hosting these days.

The host need to set the IIS 'Web Site Access Permissions' to allow write for the website or subdirectory that your mdb file is in. Otherwise you will never be able to load data into it.