Alter Table Command

[Curry]

I have an Alter Table command followed by a Transfer Database command which transfers the tbale just alterred to another Access Database. The transfer command works fine as does the Altar table independantly however when the transfer follows the Alter table it cannot find the table to transfer

Below is the code in question;

db.Execute "ALTER TABLE Master_File_Temp ALTER COLUMN [CH2 OLD MATCH CODE] DOUBLE;"


DoCmd.TransferDatabase acExport, "Microsoft Access", LinkedPth, acTable, "Master_File_Temp", "tblMASTER FILE"

I think the table is remaining in use and is not available to transfer. IS there a command I can put in between to release it after the change.

Thanks
IC

 

[pbaldy]

This is a shot in the dark, but try adding

DoEvents

between the two lines.

 

[Subcancel]

trying closing the db after the alter.

db.close

 

[Curry]

Thanks for your replies. I had tried db.Close which didn't work. I found a work around which has eleminated the need to Alter the table. Thanks for your help.
IC