Subforms on main form not displaying after Access 2007 to SQL 2005

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

We migrated an Access Database to SQL for various reasons. I now have a form
that has multiple sub forms on it, where when I use the version of the access
applicaiton that is linked to the SQL, the subforms do not appear if there is
no data in the rows selected. However, if I use the Access only application,
then the subforms appear and are able to be manipulated and edited. We have
not changed any of the code or controls in the access application. The only
thing we did was to move the data from access to SQL. Any pointers would be
appreciated.
 
Sean said:
We migrated an Access Database to SQL for various reasons. I now have a
form
that has multiple sub forms on it, where when I use the version of the
access
applicaiton that is linked to the SQL, the subforms do not appear if there
is
no data in the rows selected. However, if I use the Access only
application,
then the subforms appear and are able to be manipulated and edited. We
have
not changed any of the code or controls in the access application. The
only
thing we did was to move the data from access to SQL. Any pointers would
be
appreciated.
Click to expand...


In the cases where there *are* records for the subforms to display, are
those records updatable? My guess is that the linked SQL tables aren't
updatable. Do they have timestamp/rowversion fields? It's been a while
since I last upsized to SQL Server, but IIRC it is recommended to add a
timestamp field to tables to ensure updatability from Access.
 
Dirk Goldgar said:
In the cases where there *are* records for the subforms to display, are
those records updatable? My guess is that the linked SQL tables aren't
updatable. Do they have timestamp/rowversion fields? It's been a while
since I last upsized to SQL Server, but IIRC it is recommended to add a
timestamp field to tables to ensure updatability from Access.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)
Click to expand...

Yes the records are updatable. Some of the tables do not have a
timestamp/autonumber on them. I will update those fields and reply back.

Thanks.

sean.
 
Dirk Goldgar said:
In the cases where there *are* records for the subforms to display, are
those records updatable? My guess is that the linked SQL tables aren't
updatable. Do they have timestamp/rowversion fields? It's been a while
since I last upsized to SQL Server, but IIRC it is recommended to add a
timestamp field to tables to ensure updatability from Access.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)
Click to expand...

Okay, that was successful with one of the two subforms that I am having
issues with. The other one is still no joy.
 
Back
Top