How to do ALTER TABLE after a DML sentece in the same transaction.

[NKN]

Hi all,

Does anybody know how could I manage to do a sentence like this...

ALTER TABLE Table1 DROP COLUMN Col1

after doing a DML sentence like and UPDATE, INSERT or DELETE.

I'm using ADO commands to execute all thiis sentene from VB.

The problem is that if all this is in the same transaction when I try
droping the column in the same table that I've updated before I get an
error. The object is locked and I can't drop the column.

Thanks in advance for your suggestions,

Naiara.

 

[Arvin Meyer]

Until you release the lock (commit the transaction) you won't be able to
drop the column.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[NKN]

Thankx Arvin, but then, there's no way to do that? No property on connection
object for Access, anything that allows update sentences not to lock the
table?

If I use SQL Server it works, it doesn't lock the table and I'm able to make
a DML sentence after an update, delete or inserta in the same table.

Thank you very much for your help.

Naiara.