Active Database

[Nedan Nedzatra]

Hia!

Good Morning Friends!

I have checked on appending fields to tables on databases that are not
active but how to do it for the ones that are already open?

 

[BruceS]

Nedan,

See http://www.w3schools.com/SQl/sql_alter.asp

Best,
Bruce

 

[Nedan Nedzatra]

Hia!

Thanks.

I did it as shown below;

Sub AppendField()

DoCmd.RunSQL " ALTER TABLE [NewTable]ADD column_nam char"

End Sub

So I am going through SQL to do it. Is it possible to do it through VBA
only? Is there something in Access VBA like ActiveDocument or ActiveWorkbook
in Word and Excel VBA?

 

[Jack Leach]

Read up on the TableDefs collection. This model should provide the means.
Although, I would think SQL an easier solution.

hth
--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)

Hia!

Thanks.

I did it as shown below;

Sub AppendField()

DoCmd.RunSQL " ALTER TABLE [NewTable]ADD column_nam char"

End Sub

So I am going through SQL to do it. Is it possible to do it through VBA
only? Is there something in Access VBA like ActiveDocument or ActiveWorkbook
in Word and Excel VBA?

Nedan,

See http://www.w3schools.com/SQl/sql_alter.asp

Best,
Bruce

 

[Nedan Nedzatra]

Hia!

Thanks.

I have checked on Tabledefs on closed databases. It works. The problem is
referring to an open database; error occurs saying 'opening prohibited by
admin' because the file is open.

I thought there should be a way to refer to an open database!

Read up on the TableDefs collection. This model should provide the means.
Although, I would think SQL an easier solution.

hth
--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)

Hia!

Thanks.

I did it as shown below;

Sub AppendField()

DoCmd.RunSQL " ALTER TABLE [NewTable]ADD column_nam char"

End Sub

So I am going through SQL to do it. Is it possible to do it through VBA
only? Is there something in Access VBA like ActiveDocument or ActiveWorkbook
in Word and Excel VBA?

Nedan,

See http://www.w3schools.com/SQl/sql_alter.asp

Best,
Bruce

:

Hia!

Good Morning Friends!

I have checked on appending fields to tables on databases that are not
active but how to do it for the ones that are already open?