How do I implement order entry funcionality with ADO?

  • Thread starter Corey-g via AccessMonster.com
  • Start date
C

Corey-g via AccessMonster.com

Hi All,

I have an Oracle BE and Access 2K3 for the FE connecting via DSN-Less
connection string. I am trying to build a order entry form, with the order
info in the main form, and the ordered items in a subform (preferably
datasheet style).

I just don't understand how I can capture the data and insert it into the
underlying tables using unbound forms?

Any help would be greatly appreciated.

Corey
 
R

Rod Plastow

Hi Corey,

Are you wedded to the connection string? I have read data with connection
object sbut never tried to update this way.

What I would consider is linking your Oracle tables via ODBC Data Sources
and then using the local linked table just as if it's an Access table. When
you link you must define the primary key of the Oracle table otherwise it
will be read only.

Regards,

Rod
 
Top