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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Access tables to Access Project with SQL Server tables 5
CONNECT MICROSOFT ACCESS TO MICROSOFT SQL SERVER 2008 1
SQL 2K5 AND VS.NET 2K3 2
Vista RTM install complaining about Windows SharePoint Services (WSS) 1
Stored Procedure in SQL Server vs MSDE 2005 SQL Server 2
Bit field problems after installing A2003 SP3 1
Access Project connect to SQL Server 7
ODBC SQL Error Bulk Insert - Null values 1

Back
Top