Running Word 2007 - Locked File Issue

[RichRod]

Hi Everyone. I am using code to do a mail merge in Word 2007. I run a query in Access and it builds a table. Then, I initiate Word 2007 and run the Mail Merge. This has been working fine for over two years.

Now, we just moved to Office 2007 and Vista. So, I converted the Word Document and Access Database running this to Office 2007. When the Word 2007 Mail merge opens and trys to Access the database, it dies telling me the database is locked. Now, the database is shared, so this should not fail. To add insult to ingery, I run this from my desk on users servers, it works like a charm. I go to their site, it fails.

Now, all privilages are the same. I have even signed on as myself at their site and it still fails.

Can anyone help me. I have an entire department waiting to us this thing? It is a super high priority!

Thanks,

RR

 

[SOS]

Welcome to AWF.

You've made sure that everyone has the database location set as a Trusted Location?

 

[RichRod]

How do I do that?

 

[SOS]

How do I do that?

See here for how to do it (needs to be done on EVERY machine which is going to use the Access database).