|
|
When I try to do a mail merge using an Access 2007 Query that contains
parameters, the import fails. I get a dialogue box in word (2007) titled
"ODBC Microsoft Access Driver Login Failed" with the information "Could not
find file 'blah, blah, blah.mdb' contained in the body of the dialogue box.
The file referenced in the
dialogue box IS NOT the database I'm pulling the data from. I migrated
this db from Access 95 to Access 2007....it's looking for the old db???? Is
there something I can do about this?
This does not occur when I import queries that don't contain parameters.
|
|
To use a parameter query as a data source, use the old DDE connection method
to connect to Access. If you were using any version of Word prior to XP/2002
previously, that would have been the default method. To use DDE in Word
2007, clcik the Office button, Word Options, Advanced, General and check
"Confirm file format conversion on open". Then go through the process of
selecting your database again and select the DDE option in the extra dialog
box you see.
I think that is the problem in this case, anyway.
[Quoted Text] > The file referenced in the
> dialogue box IS NOT the database I'm pulling the data from
FWIW, Word 2007 seems to use temp files when dealing with data source rather
more than previous versions did, and I'm wondering whether that is why you
are seeing a different file name.
Peter Jamieson
"klkmsna" <klkmsna[ at ]discussions.microsoft.com> wrote in message
news:57F1A25D-24DD-4141-BDCE-A15FD607580F[ at ]microsoft.com...
> When I try to do a mail merge using an Access 2007 Query that contains
> parameters, the import fails. I get a dialogue box in word (2007) titled
> "ODBC Microsoft Access Driver Login Failed" with the information "Could
> not
> find file 'blah, blah, blah.mdb' contained in the body of the dialogue
> box.
> The file referenced in the
> dialogue box IS NOT the database I'm pulling the data from. I migrated
> this db from Access 95 to Access 2007....it's looking for the old db????
> Is
> there something I can do about this?
>
> This does not occur when I import queries that don't contain parameters.
|
|
Thanks for the suggestion. I tried it, and I'm still stuck. Had no
problems finding teh "Confirm file format conversion on open." checked it --
never saw the extra dialog box that would allow me to select the DDE option.
I got a dialog box titled "confirm data source" with the body text "Open Data
Source: OLE DB Database Files" (ok or cancel). When I click ok, I see many
of the tables and queries from my db -- but none of the queries that have
parameters.
"Peter Jamieson" wrote:
[Quoted Text] > To use a parameter query as a data source, use the old DDE connection method
> to connect to Access. If you were using any version of Word prior to XP/2002
> previously, that would have been the default method. To use DDE in Word
> 2007, clcik the Office button, Word Options, Advanced, General and check
> "Confirm file format conversion on open". Then go through the process of
> selecting your database again and select the DDE option in the extra dialog
> box you see.
>
> I think that is the problem in this case, anyway.
>
> > The file referenced in the
> > dialogue box IS NOT the database I'm pulling the data from
>
> FWIW, Word 2007 seems to use temp files when dealing with data source rather
> more than previous versions did, and I'm wondering whether that is why you
> are seeing a different file name.
>
> Peter Jamieson
>
> "klkmsna" <klkmsna[ at ]discussions.microsoft.com> wrote in message
> news:57F1A25D-24DD-4141-BDCE-A15FD607580F[ at ]microsoft.com...
> > When I try to do a mail merge using an Access 2007 Query that contains
> > parameters, the import fails. I get a dialogue box in word (2007) titled
> > "ODBC Microsoft Access Driver Login Failed" with the information "Could
> > not
> > find file 'blah, blah, blah.mdb' contained in the body of the dialogue
> > box.
> > The file referenced in the
> > dialogue box IS NOT the database I'm pulling the data from. I migrated
> > this db from Access 95 to Access 2007....it's looking for the old db????
> > Is
> > there something I can do about this?
> >
> > This does not occur when I import queries that don't contain parameters.
>
>
|
|
OK, at this point
[Quoted Text] > I got a dialog box titled "confirm data source"
you probably also need to check the "show all" box and look for "MS Access
Databases via DDE"
Peter Jamieson
"klkmsna" <klkmsna[ at ]discussions.microsoft.com> wrote in message
news:ADCB35E9-E47B-4657-88B9-7A93304256F1[ at ]microsoft.com...
>
> Thanks for the suggestion. I tried it, and I'm still stuck. Had no
> problems finding teh "Confirm file format conversion on open." checked
> it --
> never saw the extra dialog box that would allow me to select the DDE
> option.
> I got a dialog box titled "confirm data source" with the body text "Open
> Data
> Source: OLE DB Database Files" (ok or cancel). When I click ok, I see
> many
> of the tables and queries from my db -- but none of the queries that have
> parameters.
>
> "Peter Jamieson" wrote:
>
>> To use a parameter query as a data source, use the old DDE connection
>> method
>> to connect to Access. If you were using any version of Word prior to
>> XP/2002
>> previously, that would have been the default method. To use DDE in Word
>> 2007, clcik the Office button, Word Options, Advanced, General and check
>> "Confirm file format conversion on open". Then go through the process of
>> selecting your database again and select the DDE option in the extra
>> dialog
>> box you see.
>>
>> I think that is the problem in this case, anyway.
>>
>> > The file referenced in the
>> > dialogue box IS NOT the database I'm pulling the data from
>>
>> FWIW, Word 2007 seems to use temp files when dealing with data source
>> rather
>> more than previous versions did, and I'm wondering whether that is why
>> you
>> are seeing a different file name.
>>
>> Peter Jamieson
>>
>> "klkmsna" <klkmsna[ at ]discussions.microsoft.com> wrote in message
>> news:57F1A25D-24DD-4141-BDCE-A15FD607580F[ at ]microsoft.com...
>> > When I try to do a mail merge using an Access 2007 Query that contains
>> > parameters, the import fails. I get a dialogue box in word (2007)
>> > titled
>> > "ODBC Microsoft Access Driver Login Failed" with the information "Could
>> > not
>> > find file 'blah, blah, blah.mdb' contained in the body of the dialogue
>> > box.
>> > The file referenced in the
>> > dialogue box IS NOT the database I'm pulling the data from. I migrated
>> > this db from Access 95 to Access 2007....it's looking for the old
>> > db????
>> > Is
>> > there something I can do about this?
>> >
>> > This does not occur when I import queries that don't contain
>> > parameters.
>>
>>
|
|
OK, found the "MS Access Databases via DDE" selected it, and clicked ok. Got
the same dialog box "ODBC Microsoft Access Driver Login Failed" Could not
find file C\Users\MicheleSwitzer\Documents\MSNA\Database.mdb." FYI, the file
referenced in the dialog box is NOT the Access 95 db I migrated to Access
2000.
"Peter Jamieson" wrote:
[Quoted Text] > OK, at this point
>
> > I got a dialog box titled "confirm data source"
>
> you probably also need to check the "show all" box and look for "MS Access
> Databases via DDE"
>
> Peter Jamieson
> "klkmsna" <klkmsna[ at ]discussions.microsoft.com> wrote in message
> news:ADCB35E9-E47B-4657-88B9-7A93304256F1[ at ]microsoft.com...
> >
> > Thanks for the suggestion. I tried it, and I'm still stuck. Had no
> > problems finding teh "Confirm file format conversion on open." checked
> > it --
> > never saw the extra dialog box that would allow me to select the DDE
> > option.
> > I got a dialog box titled "confirm data source" with the body text "Open
> > Data
> > Source: OLE DB Database Files" (ok or cancel). When I click ok, I see
> > many
> > of the tables and queries from my db -- but none of the queries that have
> > parameters.
> >
> > "Peter Jamieson" wrote:
> >
> >> To use a parameter query as a data source, use the old DDE connection
> >> method
> >> to connect to Access. If you were using any version of Word prior to
> >> XP/2002
> >> previously, that would have been the default method. To use DDE in Word
> >> 2007, clcik the Office button, Word Options, Advanced, General and check
> >> "Confirm file format conversion on open". Then go through the process of
> >> selecting your database again and select the DDE option in the extra
> >> dialog
> >> box you see.
> >>
> >> I think that is the problem in this case, anyway.
> >>
> >> > The file referenced in the
> >> > dialogue box IS NOT the database I'm pulling the data from
> >>
> >> FWIW, Word 2007 seems to use temp files when dealing with data source
> >> rather
> >> more than previous versions did, and I'm wondering whether that is why
> >> you
> >> are seeing a different file name.
> >>
> >> Peter Jamieson
> >>
> >> "klkmsna" <klkmsna[ at ]discussions.microsoft.com> wrote in message
> >> news:57F1A25D-24DD-4141-BDCE-A15FD607580F[ at ]microsoft.com...
> >> > When I try to do a mail merge using an Access 2007 Query that contains
> >> > parameters, the import fails. I get a dialogue box in word (2007)
> >> > titled
> >> > "ODBC Microsoft Access Driver Login Failed" with the information "Could
> >> > not
> >> > find file 'blah, blah, blah.mdb' contained in the body of the dialogue
> >> > box.
> >> > The file referenced in the
> >> > dialogue box IS NOT the database I'm pulling the data from. I migrated
> >> > this db from Access 95 to Access 2007....it's looking for the old
> >> > db????
> >> > Is
> >> > there something I can do about this?
> >> >
> >> > This does not occur when I import queries that don't contain
> >> > parameters.
> >>
> >>
>
>
|
|
Just to be sure:
a. what is the pathname of the file you /are/ trying to use
b. are you definitely selecting it in the step before you see the Confirm
data source dialog box?
I will have to take another look at this as well.
Peter Jamieson
"klkmsna" <klkmsna[ at ]discussions.microsoft.com> wrote in message
news:24336233-3CD5-44DB-844E-316B95F87F2A[ at ]microsoft.com...
[Quoted Text] > OK, found the "MS Access Databases via DDE" selected it, and clicked ok.
> Got
> the same dialog box "ODBC Microsoft Access Driver Login Failed" Could not
> find file C\Users\MicheleSwitzer\Documents\MSNA\Database.mdb." FYI, the
> file
> referenced in the dialog box is NOT the Access 95 db I migrated to Access
> 2000.
>
> "Peter Jamieson" wrote:
>
>> OK, at this point
>>
>> > I got a dialog box titled "confirm data source"
>>
>> you probably also need to check the "show all" box and look for "MS
>> Access
>> Databases via DDE"
>>
>> Peter Jamieson
>> "klkmsna" <klkmsna[ at ]discussions.microsoft.com> wrote in message
>> news:ADCB35E9-E47B-4657-88B9-7A93304256F1[ at ]microsoft.com...
>> >
>> > Thanks for the suggestion. I tried it, and I'm still stuck. Had no
>> > problems finding teh "Confirm file format conversion on open." checked
>> > it --
>> > never saw the extra dialog box that would allow me to select the DDE
>> > option.
>> > I got a dialog box titled "confirm data source" with the body text
>> > "Open
>> > Data
>> > Source: OLE DB Database Files" (ok or cancel). When I click ok, I see
>> > many
>> > of the tables and queries from my db -- but none of the queries that
>> > have
>> > parameters.
>> >
>> > "Peter Jamieson" wrote:
>> >
>> >> To use a parameter query as a data source, use the old DDE connection
>> >> method
>> >> to connect to Access. If you were using any version of Word prior to
>> >> XP/2002
>> >> previously, that would have been the default method. To use DDE in
>> >> Word
>> >> 2007, clcik the Office button, Word Options, Advanced, General and
>> >> check
>> >> "Confirm file format conversion on open". Then go through the process
>> >> of
>> >> selecting your database again and select the DDE option in the extra
>> >> dialog
>> >> box you see.
>> >>
>> >> I think that is the problem in this case, anyway.
>> >>
>> >> > The file referenced in the
>> >> > dialogue box IS NOT the database I'm pulling the data from
>> >>
>> >> FWIW, Word 2007 seems to use temp files when dealing with data source
>> >> rather
>> >> more than previous versions did, and I'm wondering whether that is why
>> >> you
>> >> are seeing a different file name.
>> >>
>> >> Peter Jamieson
>> >>
>> >> "klkmsna" <klkmsna[ at ]discussions.microsoft.com> wrote in message
>> >> news:57F1A25D-24DD-4141-BDCE-A15FD607580F[ at ]microsoft.com...
>> >> > When I try to do a mail merge using an Access 2007 Query that
>> >> > contains
>> >> > parameters, the import fails. I get a dialogue box in word (2007)
>> >> > titled
>> >> > "ODBC Microsoft Access Driver Login Failed" with the information
>> >> > "Could
>> >> > not
>> >> > find file 'blah, blah, blah.mdb' contained in the body of the
>> >> > dialogue
>> >> > box.
>> >> > The file referenced in the
>> >> > dialogue box IS NOT the database I'm pulling the data from. I
>> >> > migrated
>> >> > this db from Access 95 to Access 2007....it's looking for the old
>> >> > db????
>> >> > Is
>> >> > there something I can do about this?
>> >> >
>> >> > This does not occur when I import queries that don't contain
>> >> > parameters.
>> >>
>> >>
>>
>>
|
|
|