Creating a new record in an Access 2007 table from another Office program

[LA Lawyer]

I want to use another Office program (Word, in this case) to create a new
record in a table (called "Data") in the Access database (called "Cases")
and then add values to a series of fields in that record, save and close the
record.

How is that done?

 

[CompGeek78]

I want to use another Office program (Word, in this case) to create a new
record in a table (called "Data") in the Access database (called "Cases")
and then add values to a series of fields in that record, save and close the
record.

How is that done?

I think if it's possible, it's going to be very complicated. It's not
really how the Office products are meant to be used. Word isn't a
front-end for Access. If you want your users to input data into your
Access database, use a form in Access.

Keven Denen

 

[CompGeek78]

I want to use another Office program (Word, in this case) to create a new
record in a table (called "Data") in the Access database (called "Cases")
and then add values to a series of fields in that record, save and close the
record.

How is that done?

I think if it's possible, it's going to be very complicated. It's not
really how the Office products are meant to be used. Word isn't a
front-end for Access. If you want your users to input data into your
Access database, use a form in Access.

The only way I can think of to accomplish it is with ActiveX controls.
There may be something I'm missing, but I'd start there.

Keven Denen

 

[Larry Linson]

I want to use another Office program (Word, in this case) to create a new
record in a table (called "Data") in the Access database (called "Cases")
and then add values to a series of fields in that record, save and close
the record.

How is that done?

If the Word program has access to the Access (actually Jet or ACCDB)
database, and you have or can get help from someone who can write VBA code
(in the world of Word, often referred to as 'macro'), that shouldn't be very
difficult. The VBA language is similar, but the object model of the Office
products differ, so you need someone who's skilled in the Word Object Model
and has a basic knowledge of using DAO (Data Access Objects) or ADO (Access
Data Objects) code.

Because Access provides more of a development environment than most Office
products, it is more common to find Access applications using the other
products via the Component Object Model architecture with which they are all
compliant. In your case, you won't need to manipulate objects in Access,
just use the coding language to write to the database.

Larry Linson
Microsoft Office Access MVP