Access as a Front End to SQL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a SQL view that is based on a SQL table and another SQL view that selects distinct records. SQL does not allow me to edit the columns from the first view which are based on the second views distinct records, however I can edit the portion that is based on the table. If I create an access form based on the first SQL view I cannot edit any column. Is there an easy way around this

Thanks
 
Well, the most simple answer here is that the view has to be a updateable
view.

If the view is updatable..then ms-access can link to that view.....and edit
it also.

If you can with the sql tools bring up the view and edit it..then you can
also in ms-access...

However....this root of this problem means you need a updatable view....you
have no choice here...
 
Most views are meant to be snapshots of a particular time for data within SQL Server. Try utilizing select queries instead of views and link them with access...or an updatable view.
 
Back
Top