It is a different issue with mdb's. Those are locked by a file with the same name and extension *.ldb. Deleting that file should release locks.

The 2nd and 3rd select statement omit "ctgparentlvl1". If you add that or a null, the error should be resolved.

On some views I have found you need to refresh the connection to SQL Server.

In the form design open the properties for the combo box, then select the row source. It will allow you to select a table, view, store procedure or function...

I have created views in SQL for the combo boxes. This may work for you too.

If it is MDB Access will create a file with an extention LDB. If a lock does not go away, deleting this file will remove the lock.

The only thing I can think of is the field does not allow nulls.

Is your data is stored in an mdb?

You can create a view or a store procedure to select top 10%. If you are connected via an ODBC you can link the view to Access.

I have both ADP’s and MDB’s. The ADP’s have so many benefits that I have nearly finished converting all of my MDB’s to ADP’s. ...

You could create a view, then query the view or add a derived table.

If you are using an Access adp, you should create your queries as views in the SQL Server Management studio.

I am not sure what you need at this point. If you are looking for a viewer, create an Access adp to connect to your SQL database.

DATEDIFF(yy, DateOfBirth, GETDATE()) - CASE WHEN DATEPART(m, DateOfBirth) >= DATEPART(m, GETDATE()) AND DATEPART(d, DateOfBirth) >= DATEPART(d, GETDATE()) THEN 0 ELSE 1 END

is incorrect, it should be:

DATEDIFF(yy, DateOfBirth, GETDATE()) -...

You should be able to do all of the above in one DTS.

With an ADP you can set the record source of your form to be a stored procedure from the properties menu. From the same menu you can establish the...