When in doubt - cheat!
Quite!
I am now facing a new problem - how to point Jet OLEDB:System Database
at the PC that acts as server for other PCs.
Not sure why you would need this for /Word/ if you have removed the need
to connect to Access data sources, but if it's so that users can
generally speaking get at Access databases, then I think you have to put
the path in the registry. Probably better to google that and ask in an
Access group if you don't find the necessary, although I can probably
dig it out for you if necessary.
Peter Jamieson
http://tips.pjmsn.me.uk
Murray Muspratt-Rouse wrote:
Peter, I have solved the problem of setting up mail merge documents by
exporting MergeTable as an Excel spreadsheet. When in doubt - cheat!
I am now facing a new problem - how to point Jet OLEDB:System Database
at the PC that acts as server for other PCs.
Murray
Peter Jamieson;394769 Wrote:
Hi Murray,
as it stands, you need to terminate the connection string:
Connection:="Provider=Microsoft.Jet.OLEDB.4.0;Pass word=""pixie7826"";User
ID=Murray
M-R;
Data Source=C:\Documents and Settings\All Users\Documents\Age Concern
Databases\clients2002.mdb;
Mode=Read;Jet OLEDB:System database=C:\Documents and Settings\All
Users\Documents\Age Concern Databases\Secured.mdw;"
It's possible that you may need to quotes various things such as the
User ID and paths (two sets of double quotes at either end, like the
Password) but I don't think so.
The quotes in your SELECT probably need to be backquotes, like this:
SQLStatement:="SELECT * FROM `mergetable`"
rather than straight quotes, like this
SQLStatement="SELECT * FROM 'MergeTable'"
I tend to use [ ] instead to make this clearer:
SQLStatement:="SELECT * FROM [mergetable]"
You don't need SQLStatement1 or subtype, but neither of them should
cause any problems as they stand.
Peter Jamieson
http://tips.pjmsn.me.uk