Saving Data

[JB]

I recently upgraded to Office 2007 Pro. I use a mail merge of word and
access for invoices and customer lists. When I open the word document it is
linked to the access database via dde so they both open together. This
allows me to enter info in the database and then merge it with the word
document, filtered, so I can print each day's invoices. In office 2003 once
I was finished and closed the work document, i didn't need to save anything
and used that so each time I open the document I start with no records
filtered. Since I upgraded to 2007 any info I enter to the access database
isn't saved. When I open the next day anything I did the day before doesn't
exist. With 2003 all I had to do was close word, click not to save, and
whatever I entered to access was saved because when access closed is saved
without question. It seems access doesn't \do this anymore if it closed when
closing the document it is linked to. both files are saved in 2007 format.

Am I missing something?

JB

 

[Arvin Meyer [MVP]]

Data which is bound to forms or is entered to tables is automatically saved.
If you are using a form to enter your data, make sure it is bound to the
underlying table.

 

[JB]

I'm not sure what you mean. The form was created from the table many years
ago. Would this change when saved in the new access format? My problem is
if i open the database on its own enter data, and then close it, it saves
everything. If I open the database when I open the word document via the dde
link, then it does not save any changes to the database. This wasn't an
issue with any previous versions of office.

JB

 

[De Jager]

I recently upgraded to Office 2007 Pro. I use a mail merge of word and
access for invoices and customer lists. When I open the word document it
is
linked to the access database via dde so they both open together. This
allows me to enter info in the database and then merge it with the word
document, filtered, so I can print each day's invoices. In office 2003
once
I was finished and closed the work document, i didn't need to save
anything
and used that so each time I open the document I start with no records
filtered. Since I upgraded to 2007 any info I enter to the access
database
isn't saved. When I open the next day anything I did the day before
doesn't
exist. With 2003 all I had to do was close word, click not to save, and
whatever I entered to access was saved because when access closed is saved
without question. It seems access doesn't \do this anymore if it closed
when
closing the document it is linked to. both files are saved in 2007
format.

Am I missing something?

JB

 

[Arvin Meyer [MVP]]

I think the current version of Office uses an ODBC link, not a DDE link.
That may be part of your problem. DDE should still work, but there may be
some problems. There are all sorts of variables here including versions and
service packs. Go to the Microsoft Knowledge Base:

http://support.microsoft.com

and search on something like:

DDE link problems in Access and Word 2007

and you may find an answer to your specific problem.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access