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,
Thanks,
Carla

Aug 16 '07 #1

Subscribe Post Reply

2243

Carla Hepker

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.

Regards,
Scott

Aug 27 '07 #3

Similar topics

Deploying ASP.NET projects

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...

ASP.NET

Security Exception when deploying a VB.NET 2003 solution.

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...

Visual Basic .NET

Deploying multiple EXE's using the basic publish mechanism of the

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...

.NET Framework

Deploying VS 2003 Application w/Access Database

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...

Visual Basic .NET

Deploying a WinForms app on Vista

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...

C# / C Sharp

Deploying 2.0 WebSites

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...

ASP.NET

Wiring up an App.Config file - deploying the App.Config file

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...

.NET Framework

Deploying new app. Upgrade theory

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...

Microsoft Access / VBA

ASP .NET 2.0 Visual Studio 2005 - deploying - no DLLs

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...

ASP.NET

Windows 11 and Access Combo Box Issue

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...

Microsoft Access / VBA

Can faster file sharing be achieved by connecting computers simultaneously via WiFi and LAN cables

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...

Networking - Hardware / Configuration

Energy Model code modification to account for year dependent interest rate

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...

Python

Send Current Object to PDF

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 :...

Microsoft Access / VBA

VBA Class Basics

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...

Microsoft Access / VBA

Report value list

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...

Microsoft Access / VBA

Access Europe Meeting - Wed 1 Nov - Using SQL Server skills to extend Access

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...

Microsoft Access / VBA

VBA Class Basics (Report Class)

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...

Microsoft Access / VBA

Take a Database to the Next Level

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...

Microsoft Access / VBA