Thank you Peter for trying to help me...
But it still does not work...
1. I can open my dbf file with Excel... when I double click on the dbf file
and choose Excel as the opening application, it works and I can see very
well all the columns.
2. The article you ask me to look at is to get rid of the little window when
opening my Word document... I do not have a problem with this window... I
just answer "no" and then I try to open the database manually.
3. I have tried using VBA in a Macro to open the data source and it still
does not work...
I am really at my wit's end... And the worst of it all is that it works fine
on other computers with different OS but same Office version.
If I can't find a solution... I will have to forgo the DBF file as a
datasource...
Please help.
H. Dumas
Hello HD,
> 1. I can open my dbf file with Excel... when I double click on the dbf
> file
> and choose Excel as the opening application, it works and I can see very
> well all the columns.
That's a good sign, but if you can find out what Excel is using to open the
DBF, it might help. For example, can you see if it is using the FoxPro
driver, or the Jet driver? (I wish I could be more helpful: this area is
unfamiliar for me - if you can't see anything, I can have a closer look).
> 2. The article you ask me to look at is to get rid of the little window
> when
> opening my Word document... I do not have a problem with this window... I
> just answer "no" and then I try to open the database manually.
The problem is that when you open the data source using VBA, you /must/
apply the change described in the article I mentioned. Otherwise, the
OpenDataSource call will always raise an error. So, you have to do that...
> 3. I have tried using VBA in a Macro to open the data source and it still
> does not work...
...even to make that have a chance of working.
> I am really at my wit's end... And the worst of it all is that it works
> fine
> on other computers with different OS but same Office version.
Understood.
> If I can't find a solution... I will have to forgo the DBF file as a
> datasource...
What options do you have? (FWIW the free SQL Server 2005 Express is now a
released product, and has many advantages. But it's a "heavyweight" product
that may not be appropriate for you)
Peter Jamieson
> Thank you Peter for trying to help me...
> But it still does not work...
[quoted text clipped - 107 lines]
>> >
>> > H. Dumas
HD - 23 Feb 2006 14:07 GMT
Hi there,
Thanks a lot but I finally found part of the problem... When I installed the
VFPODBC.msi, it installed it in the System DSN tab of the ODBC
Administrator... They had to be installed in the User DSN... which is what I
did... I added them in the User DSN tab using exactly the same names and
driver... and now it works...
BUT (yes there is a but....) the merge works with DBF files that do NOT have
memo fields... As soon as my DBF file has a memo field, I'm back where I
started again...
Two steps forward... one step back...
If you or anybody has any idea as to why it does that... I REALLY would
appreciate the input.
Hélène
> Hello HD,
>
[quoted text clipped - 147 lines]
> >> >
> >> > H. Dumas