Access Update and Insert

[Sammy]

Hey Guys
I am using Access 2007 and I just noticed something strange.
I have an application built in C#, the app uses access querys and update
statements to update and inserts new records to the database. after the
upgrade to 2007, it completely stopped updating any records, if I install
the app on my laptop "using access 2000" it updates and inserts new records
fine.
is there some sort of security added to access 2007 I am not familar with? I
have already changed the trusted location to the database location to no
effect.

Thanks

 

[Allen Browne]

Sammy, I'm not sure if the 2007 Office System Driver is what you need:
http://www.microsoft.com/downloads/...36-8C28-4598-9B72-EF94E038C891&displaylang=en

It might depend on what References there are in your project, and how you
are executing the statements.