Access Project 2003 - SQL Server 2K5

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

Guest

I've added records to a SQL 2K5 database through an Access Project form.
However, when I'm done the records I've added are only visible through
Management Studio. If I try to view the same new records in the Access
Project...they are not there. I've tried closing and reopening the Access
project...doesn't help.

How is this possible?
 
I found the problem. The Access Project (whether in Access 2003 or 2007)
does not respect the "Order By" property of the form. The new records were
'disappearing' because records are being returned in random order. So now
the question is, how do I get the "Order By" property to be obeyed?
 
Back
Top