No data appears in Access

[seengee]

I'm sending some basic form data to Access using PHP, when i echo back the results to the page it displays the records i have entered. the problem is that when i open the table in Access it doesnt display any data. I'm pretty new to access, always used mysql before, anyone got any ideas whats going on?.

 

[WayneRyan]

seengee,

I don't know PHP.

Within Access, if you do inserts via SQL, you can have problems
like that and not be aware of it.

If you insert data into a table and a required field is missing,
or a data type mismatch or a duplicate primary key then the
insert operation will fail. There is no error flag or message
and your code is blissfully unaware that there is a problem.

The solution in the above scenario is to compare each data
element to be inserted with the definition in the table and
manually look for conflicts.

This may have nothing to do with your situation, but it may
get you started while you wait.

Wayne

 

[seengee]

i am using sql to access MS Access. Within my php script i connect to Access using ODBC and return an array of results. If there was nothing in the database this wouldnt return anything but its returning everything i've entered.