<div>
Is this Table involved in an Relationships ? &nbsp;If so, this is likely the cause of the problem .... Referential Integrity may be preventing deleting of records.<br />
<br />
mx
</div>


<div>
50/50 split seems only fair!<br />
<br />
thanks
</div>


<div>
Well, what do you mean 'worked'. &nbsp;Was a error exposed ? If so what error ... just curious ...<br />
<br />
mx
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I'm experiencing an issue with deleting records on the Linked Table (Oracle) from MS Access 2007. &nbsp;I'm executing the following in VBA:<br />
<br />

<div class="indent"></div>
CurrentDb.execute Delete TableName.* FROM TableName<br />
<br />
I expect this would delete all records, however it's just deleting 1 record.<br />
<br />
Any help would be appreciated.<br />
<br />
Thanks<br />
<br />
Mark
</div>
</div>


Hi Experts,

I'm experiencing an issue with deleting records on the Linked Table (Oracle) from MS Access 2007.  I'm executing the following in VBA:

CurrentDb.execute Delete TableName.* FROM TableName

I expect this would delete all records, however it's just deleting 1 record.

Any help would be appreciated.

Thanks

Mark

Is this Table involved in an Relationships ?  If so, this is likely the cause of the problem .... Referential Integrity may be preventing deleting of records.

mx

Well, what do you mean &#39;worked&#39;.  Was a error exposed ? If so what error ... just curious ...

mx

SQL Delete * Only Deleting a Single Record on Linked Table

Hi Experts,

I&#39;m experiencing an issue with deleting records on the Linked Table (Oracle) from MS Access 2007.  I&#39;m executing the following in VBA:

CurrentDb.execute Delete TableName.* FROM TableName

I expect this would delete all records, however it&#39;s just deleting 1 record.

Any help would be appreciated.

Thanks

Mark

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.