I have a Word document that is filled with data. I set up a button on the document where the user is supposed to click on the button and run VBA code. The code is supposed to open an access database and run a select query and then insert new data into the access database. The database is in the same directory as the document. I am limited to starting it from Word with the button. The button works and runs the VBA. I just don't know what to use to get the database open and queried. Help would be greatly appreciated. thanks.

The solution is not trivial unfortunately.

What I would do is add a reference to the Microsoft Access Object Library within your VBA code in Word, and then open an instance of Microsoft Access, then use commands such as OpenDatabase(), etc. to do your stuff. From there, you would populate tables, run queries, etc.

Hope this gives you some direction.