Access Startup Options & Mail Merge

[briandh]

I have a problem with using my Access2000 database in a mailmerge with MS Word. I have secured my database so users cannot tamper with the design: the database window is not shown on startup, and on startup a login form is displayed (popup & modal) so the user must log in. The database has been working fine.
Now when I want to use the data in the database in a MailMerge, everytime you do anything with the mail merge document, it pops up my Access login form (You aren't required to login though, to use the mail merge) but every little thing you do in Word pops up my login form. Very annoying!
Is there a way to disable that form from being displayed when accessing my database from MS word? The database works fine outside of trying to do mail merges. And mail merges work fine also, if you can put up with the login form popping up all the time.

Any suggestions?

Thanks in advance!

Brian

 

[Maquis]

How about splitting the database. Move the tables out of the "login" database and into a backend. You can then link the tables back into the "login" database and your mail merge application can just link to the database with the tables directly rather than going through the login.

I've never used Access 2000 (I'm still on Access 97), but I believe there is a split option in 2000 which will do this for you. Maq
<insert witty signature here>