Link to home
Start Free TrialLog in
Avatar of Bernard Thouin
Bernard ThouinFlag for Switzerland

asked on

MS Access forms bound to SQL Server tables accessed over ADO ?

Hi

Is it possible to replace:
  • an Access form bound to a linked table residing in SQL Server, i.e. using implicitly DAO
  • by an Access form bound to a table using an ADO connection
without having to write a lot of VBA code for:
  • loading the data in the form fields
  • updating fields of existing rows
  • Inserting new rows
  • deleting existing rows
?

I have only:
  • a large experience in using linked tables and ADO in Access
  • experience in using VB.Net with corresponding forms and datasets and datatables

Thanks for help
Bernard
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bernard Thouin

ASKER

Thanks Scott, that solves my problems :)