N
NKTower
We have an ADP app that behaves just fine on XP platform w/ Access 2003 and
SQL Server 2005. One client recently added a Vista Business desktop w/
Access 2007 on it. On that machine only, when the client asks for any
record, the subform returns #Name? in every field until we hit F5 and then it
is just fine. The form is bound to a SQL statement that is generated on the
fly and put in the RecordSource property. The query will always return one
known-to-exist record.
I have replicated the problem on a Vista Business platform with Access 2007
and SQL Server Express. I've put in request for hotfix kb/936519 but not
gotten the link yet.
And while we are at it, where do they hide the release/SP level in Access
2007? I've yet to find HELP/ABOUT. I presume that on my test machine it is
baseline release straight off of MAPS DVD.
SQL Server 2005. One client recently added a Vista Business desktop w/
Access 2007 on it. On that machine only, when the client asks for any
record, the subform returns #Name? in every field until we hit F5 and then it
is just fine. The form is bound to a SQL statement that is generated on the
fly and put in the RecordSource property. The query will always return one
known-to-exist record.
I have replicated the problem on a Vista Business platform with Access 2007
and SQL Server Express. I've put in request for hotfix kb/936519 but not
gotten the link yet.
And while we are at it, where do they hide the release/SP level in Access
2007? I've yet to find HELP/ABOUT. I presume that on my test machine it is
baseline release straight off of MAPS DVD.