471,108 Members | 1,426 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

Deploying an ade (compiled access data project) in 2007

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
2 2068
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
1,384 Expert 1GB
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: http://allenbrowne.com/Access2007.html

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.

Similar topics

10 posts views Thread by Gerben van Loon | last post: by
1 post views Thread by David Jackson | last post: by
5 posts views Thread by daokfella | last post: by
10 posts views Thread by =?Utf-8?B?UmljaGFyZA==?= | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.