By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,530 Members | 2,181 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,530 IT Pros & Developers. It's quick & easy.

Deploying an ade (compiled access data project) in 2007

P: 2
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,
Aug 16 '07 #1
Share this Question
Share on Google+
2 Replies

P: 2
I have found some further information about this. I am trying to deploy this with the runtime version of Access 2007. It is the Runtime version that is the problem, I think, since I am able to run it on another machine that has a full blown version of Access 2007 installed.
Aug 16 '07 #2

Scott Price
Expert 100+
P: 1,384
Being a skeptic :-) I'm waiting for the second service pack to fix A2007 bugs before upgrading myself, however, I've been reading a few sites to get a general handle on the issues... Have a look here:

The whole page contains some very good information, but especially look at the links section at the bottom of the page.

Sorry to not be able to offer you any specific help on your issue.

Aug 27 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.