Access Front / SQL Back - create view
Posted on 2014-07-27
I have an access front end and a SQL back end.
I have a MailMerge that uses a dynamically Query from the access database
I want to create a button to open the mailmerge document and run it, but so far, when I do, it tells me it cannot run it because the access database is locked.
I figure I can get around this by having the Access front end create a view and run the mailmerge against the view instead of the query.
But I don't know how to create a new view via VBA code in the access database. Can anyone guide me?