I have several in-house applications that I have developed over the years using vba in Access Data Projects. When we converted the SQL server over to 2005, some of the sorts no longer functioned properly, as well as a few other annoying little things that we have learned to live with.
However, at this point in time, I am looking at converting over to Access 2007. At first I thought that adp's were no longer supported, but then I found out that it is possible to still create adp's. So I opened a blank adp, and then created a project using Visual Source Safe to move it from 2003 to 2007. Everything is fine, but when I create the ade and open it on any other machine, the forms that have stored procedures as the data source are blank. Forms that may have a view as the data source are fine.
It is not user dependent. The operating system on the machines I have tested is XPsp2. Another person can log in to my machine and open the ade and display data fine, but when they or I log in to the other machine, the majority of the forms are blank (data source is a stored procedure).
I don't get any error message, though when I tried to open the adp on the other machine, I did get a reference missing error, which I corrected. I thought that the ade might work then (after recompiling it), but it made no difference.
The forms are Continuous forms, and I programmatically set the data source on the sub forms when the main form loads.
Any help you can give me would be appreciated,
Thanks,
Carla