Access project forms with multiple table recordsource

[DeanWilliams]

Hi,

I am upgrading an Access database to an Access project with a SQL backend. I have a form that is based on 4 tables that works fine with an Access back-end, but I cannot add records in the adp version.

I understand that you can only add records to ADO recordsets that are based on one table. Is that right??!!!??

How can I get around this? Am I gonna have to change them all to unbound forms?? Hope not.

Dean.

 

[Rolliee]

Dean,

When you source a form with a multitable query, it is often does not allow addition of records and is sometimes not even editable. This is becasue the compiler does not have enuf info to go back and do what you want and we do not have DWIM (Do What I Mean) buttons or cards. Since you know what you want, it is easy enough to add the records to the uderlying tables with code - either ADO or DAO.


rollie@bwsys.net

 

[BNPMike]

Iknow nothing about SQL Server but I suspect the first thing you need to do is get an updatable view on the server. It looks as though multi-table views can be updated in some situations. The rules are not going to be identical to Jet.

Read this for example

http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20807492.html