My only connection issues with ADP's was this issue http://support.microsoft.com/kb/843248/en-us .

Is there a reason you are not using DTS?

I have found that ADP's are more transportable than ODBC's.  I cant explain what is happening with the ODBCs but the problem may go away using an ADP. 

That eliminates my only suggestion.  If nothing else works, I have a very low tech approach.  If you can create an mdb to mimic your ADP, the mdb has better...

Is  Forms![frmclass]![subfrmClassStudent] open to a specific record?

No, I have not.  But sounds like a good approach.   Let me know if it works.

For my users I set up the data connection and stored the excel file at a Sharepoint site.  The only training I had to do was teach the users to...

If you are using an ADP then your queries would be views on SQL.   From Excel you can connect directly to the view by importing external data.   That may be...

If you are using an ADP you can execute an SP in Access using VB to establish the parameter.

Is the report using a view or stored procedure?

Perry

You may  try to the insert the first set of results into a temp table them multiple from the temp table.

I am not using functions.  I am using a view.  

In my access project I go to queries where I can open views.  In SQL Server 2000 the sort for those...

Hi Yelena,

The SQL view is:

SELECT     TOP (100) PERCENT dbo.DirectoryRights.DirectoryListID, dbo.DirectoryList.FileName

FROM         dbo.DirectoryList INNER JOIN

                      dbo.DirectoryRights ON dbo.DirectoryList.FileID = dbo.DirectoryRights.DirectoryListID

ORDER BY dbo.DirectoryList.FileName

When executed from the Management Studio the FileName is sorted correctly.

When...

Is your macro security set for low?

You can't do it from the wizard, that I know of.  What you could do is save what you have from the wizard as a DTS, then go to the...