I've created a vb.net application that stores various information for the user in an access database file. This works perfectly. Now, I want the user to be able to use mail merge with this and query for a given field or fields and return a single result as a mail merged document so that they can print out reports with different information but identical formatting. Seems simple enough... and it was... sort of.
On this computer I'm running visual stuido 2000 and on some other machines this software needs to work on they have visual studio 2003. Now, this shouldn't be a problem but it is. My computer can do everything I want exactly as I want it, however when I try to use word 2003 with the access 2000 database file some problems arise. Mainly it can see the database, and can properly merge it with the fields....but only if I make it return merged documents for EVERY row of the database or the first one. Anytime I query for any entry in the DB it returns only the first record in the DB. This, obviously, is of no use to me in this form.
Is there a known issue of compatibility between access 2000 and 2003 software? I've been seraching but have yet uncovered nothing of this sort but the problem occurs on multiple computers in the exact same way. Thanks for any tips or help.
On this computer I'm running visual stuido 2000 and on some other machines this software needs to work on they have visual studio 2003. Now, this shouldn't be a problem but it is. My computer can do everything I want exactly as I want it, however when I try to use word 2003 with the access 2000 database file some problems arise. Mainly it can see the database, and can properly merge it with the fields....but only if I make it return merged documents for EVERY row of the database or the first one. Anytime I query for any entry in the DB it returns only the first record in the DB. This, obviously, is of no use to me in this form.
Is there a known issue of compatibility between access 2000 and 2003 software? I've been seraching but have yet uncovered nothing of this sort but the problem occurs on multiple computers in the exact same way. Thanks for any tips or help.
