Please can you tell me if, using VBA from Word, it is possible to create a new table in an existing Access database without opening Access? Currently I am using the attached code which, although it works fine, displays a macro security warning when it opens the database. I know that I can set the macro security in Access to low, or digitally sign the code, but am thinking that, if I can achieve this without actually opening Access, then I won't need to do either. Also, would Access need to be installed on a user's machine in order for this code to work? If so, is there a better way to do this so that it doesn't need to be installed?
Any help appreciated as always.
Set objAccess = CreateObject("Access.Application")
Set dBase = objAccess.CurrentDb
Set tdf = dbs.CreateTableDef("Contacts")
Set fld = tdf. _
CreateField("Surname", DB_Text, 50)