Unable to merge after sharing database James 11.07.2006 19:07:01 What did I leave out? Added security in access 2003 and lost the abbility to merge with word 2003!

Re: Unable to merge after sharing database "Joan Wild" <jwild[ at ]nospamtyenet.com> 13.07.2006 13:23:40 Could you provide more details? What error message are you getting? Are you merging from within Access, or from Word? What steps did you take? -- Joan Wild Microsoft Access MVP James wrote: [Quoted Text] > What did I leave out? > > Added security in access 2003 and lost the abbility to merge with > word 2003!

Re: Unable to merge after sharing database James 14.07.2006 19:31:02 Please read the info next to your questions James "Joan Wild" wrote: [Quoted Text] > Could you provide more details? > > What error message are you getting? Word was unable to open data source > > Are you merging from within Access, or from Word? word > > What steps did you take? Tryed to Querie the acces data file as we have in the past. also we are using access security > > > -- > Joan Wild > Microsoft Access MVP > > James wrote: > > What did I leave out? > > > > Added security in access 2003 and lost the abbility to merge with > > word 2003! > > >

Re: Unable to merge after sharing database "Joan Wild" <jwild[ at ]nospamtyenet.com> 16.07.2006 15:14:02 If you want to do it from within Word, you'll need to be joined by default to your secure workgroup file. I would also suggest you open Word, Tools, Options, General tab and ensure that 'Confirm conversion on open' is checked. Start the merge, and when you select the data source, choose your secure mdb file. In the 'Confirm Data Source' dialog choose 'via DDE' and you'll be prompted for the Access username/password to open the data source. This is the only way I've found to succeed from within Word. You could, instead, do the merge from within Access. Since you would have already signed in to the Access database, you're already authenticated for the Access security. Use Tools, Office Links, Merge it with Word and proceed from there. -- Joan Wild Microsoft Access MVP James wrote: [Quoted Text] > Please read the info next to your questions > > James > > "Joan Wild" wrote: > >> Could you provide more details? >> >> What error message are you getting? Word was unable to open data >> source >> >> Are you merging from within Access, or from Word? word >> >> What steps did you take? Tryed to Querie the acces data file as we >> have in the past. also we are using access security >> >> >> -- >> Joan Wild >> Microsoft Access MVP >> >> James wrote: >>> What did I leave out? >>> >>> Added security in access 2003 and lost the abbility to merge with >>> word 2003!