PC Review


Reply
Thread Tools Rate Thread

Access Update and Insert

 
 
Sammy
Guest
Posts: n/a
 
      21st Jan 2007
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


 
Reply With Quote
 
 
 
 
Allen Browne
Guest
Posts: n/a
 
      21st Jan 2007
Sammy, I'm not sure if the 2007 Office System Driver is what you need:
http://www.microsoft.com/downloads/d...displaylang=en

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Sammy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
insert data in an access db with C# (update) Jordi Maicas Microsoft ADO .NET 1 5th Jun 2008 08:51 PM
Need VBA Codes for Update or Insert statement in MS Access FA Microsoft Access Queries 6 1st Mar 2006 07:08 AM
Can't do any Delete/Insert/Update in Access Joe Tsang Microsoft ADO .NET 6 22nd Sep 2004 01:02 PM
Problem in MS-Access Update / Insert P.R.C.Reddy Windows XP General 0 5th Apr 2004 11:53 AM
INSERT/UPDATE Date in Access problem... DraguVaso Microsoft VB .NET 1 3rd Dec 2003 11:54 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:40 PM.