How do I implement order entry funcionality with ADO?

  • Thread starter Thread starter Corey-g via AccessMonster.com
  • Start date 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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Daily Entry with multiple entries per field 0
Form design to add data to 3 tables in "Order Entry" style db 1
Form and Subform record issues 5
VBA Child Value 2
Insert order line numbers automatically by code? 14
Thoughts on how and where to keep history data? 2
Appending records: 2 ADO connections 1
Not sure how to achive this... 3

Back
Top