472,980 Members | 1,520 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,980 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 2243
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

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

Similar topics

by: Gerben van Loon | last post by:
Hi there, hope someone can help me on this: I'm planning to deploy several ASP.NET projects to a production server. Normally I used the "Project / Copy project" option in VS.NET, but to this...
by: John Kotuby | last post by:
Hello all, Note: This is the full version of a Post that I inadvertently sent before it was complete. About a year ago I wrote a VB.NET 2003 solution that consists of a number of assemblies...
by: Al Christoph | last post by:
I posted this last week end in the MSDN forums. No luck there. Let's see what the experts here have to say:-)))) I have a rather convoluted project. The distributable will come in eight...
by: pooba53 | last post by:
I have a VB .NET 2003 application that communicates with an Access db. I am deploying the application using the Wizard that creates an install package and it IS properly grabbing the Access db and...
by: David Jackson | last post by:
Hello, I'm looking for some best practice advice on deploying a 32-bit WinForms app on 32-bit Vista as regards file locations. The app will be written in Visual Studio.NET 2005 and will be...
by: daokfella | last post by:
I'm still stuck on the .dll and bin folder mentality in 1.1. When deploying a 2.0 web application, there is no web .dll to deploy? So is this how we deploy in 2.0? 1. Copy the app_code folder...
by: dbuchanan | last post by:
Hello, (Is this the proper newsgroup?) === Background === I am building a solution with two projects. One project is my data access layer which contains my DataSet as an xsd file. The XSD...
by: ARC | last post by:
Hello again, I'm close to the end of converting a large app from access 97 to 2007. I have many users on the old system, with the db's in Access 97, and here's what I'm thinking of doing to...
by: =?Utf-8?B?UmljaGFyZA==?= | last post by:
Hi, I usually deploy my ASP .NET application to the server by publishing, using Visual Studio 2005 publish feature. This creates the Bin folder on the server, with the compiled DLLs. I've...
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

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.