473,396 Members | 1,724 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Ms Access Delete queries exceuting but records not deleted

atksamy
91
Hi,

I am running a few delete queries which r getting executed without any error. But the data in tables are not getting deleted. It is as if the queries were not run. I ran them through debugging but they are executing. Any ideas what is wrong?

thanks
May 17 '10 #1
1 1452
patjones
931 Expert 512MB
Hi,

Can you post the code for the queries? If you're running them from Visual Basic post all the relevant VBA code as well. Thanks.

Pat
May 17 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: denilynn | last post by:
Please tell me it's possible to retrieve records deleted from an Access table and how to do it. Thanks!
1
by: b. hotting | last post by:
hi, Does anybody know how to access the queries made and stored in MS Access thru C# Code. thanks, bjorn
1
by: khan | last post by:
I have customer table and it has one to many relation with sales table and sales table has one to many relation with saledetail table. Is it possible if I delete a customer from customer table then...
1
by: b. hotting | last post by:
hi, Does anybody know how to access the queries made and stored in MS Access thru C# Code. thanks, bjorn
1
by: MLH | last post by:
Take the following SQL: DELETE tblPreliminaryVINs.* FROM tblPreliminaryVINs INNER JOIN tblVehicleJobs ON tblPreliminaryVINs.PVIN = tblVehicleJobs.SerialNum; Access 97 consistently disallows me...
1
by: Michael | last post by:
Hi. I am working with classic ASP. I'd like to transfer al my hard coded sql queries to access stored queries and use them with parameters. Actually, I did not find any strong information how to do...
1
by: timn | last post by:
Translating Access SQL queries into SQL subqueries. -------------------------------------------------------------------------------- I have a query in Access that uses a subquery, I would like...
1
by: maikanta | last post by:
Hi Guys, I wrote VBA code to delete the record using DoCmd Command. after that I wrote Select query to select the records from that table and assigned that query to the form recordsource property....
1
by: Sonalk | last post by:
hi everybody............ i have problem in my coding section........... how to delete the remaining records from a specified date(ex:last six date records i want to for a perticular user and...
1
by: andrewst | last post by:
Originally posted by Divya OK:- SQLcreate table parent( parent_id number primary key, parent_name SQLvarchar2(10) ); Table created. SQLcreate table child( child_id number primary key,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.