The setup: Multiple computers using an adp file to access a sql 2005 database. Most don't have a pdf distiller. An access form (plain form, not crystal) is created that needs to be saved as a pdf. The only way I can think of is send a request from access to the sql server for a web page. Something like: "http://sqlserver/generatepdf.ph...
Sorry if this is a noob question, but I have been given the dubious honour of supporting an ancient legacy Access 2000 .adp application, written badly by someone years ago who is no longer around, when i have little experience with Access or VB myself :) I have set up a WinXP dev machine with Access 2000 (it's an Access 2000 project) to...
We use Access Project files to connect with SQL Server. Our SQL Server 2000 has been upgraded to SQL Server 2005 and now my project files are reporting an incompatibility and the error "This recordset is not updatable" when trying to modify data. So: 1) Will upgrading to Access 2007 and then creating project files solve this problem? ...
Hello- I have a situation that really has me stumped. I have a form used to display contacts. When a command button is clicked another form pops up for viewing and inputting call information made to that contact. This form includes two subforms. One that lists the calls in datasheet view and displays call date, call time, and the call ...
I have a (very simple and standard) UPDATE statement which works fine either directly in Query Analyser, or executed as a stored procedure in Query Analyser. UPDATE A SET A.field1 = B.col1 , A.field2 = B.col2 FROM tblA AS A INNER JOIN tblB AS B ON A.pk1 = B.pk1 AND A.pk2 = B.pk2 Problem is when i execute the same st...
I have an adp project in MS Access 2003 with an SQL Server Express 2008 as backend. Everything works fine, except when there is an error on the SQL side, e.g. duplicate indices. the current dataset just doesn’t get updated/inserted, no error message whats-o-ever, but I know it’s not updated, because if I do a select on the server I stil...
Hello Everyone, I have a strange problem with an Access adp project. There is a main form with a header and a details sections on a page. The detaisl section is made up of a tab control that has 7 tabs to it. Only the 1st tab shows up if I connect the project to a REMOTE SQL Server 2005 Express database. The same details section w...
First some context: I have a Microsoft Access 2000 project (ADP file) accessing a SQL Server 2000 Database. The main form of that application has a lot of controls and subforms. On one of the subforms which contain a summary of some information about companies, each record has two buttons that lead to a search form that access a web ser...
I have an Microsoft Access 2003 ADP, which uses a bound "main" form with several bound continuous-style subforms. They all utilize disconnected Recordsets via a helper class. Several users have noticed the same strange behavior: they add/edit a record in the continuous subform, they leave the record (committing the edit to the Recordse...
I'm using SQL Server 2008 and Access 2010 beta - but this problem occured with SQL Server 2005 and Access 2007 as well. I have an Access adp connection to the SQL Server. I create a view that does a group by and sums a column which is type numeric(7,2). The result of the sum expression is inexplicably treated as text by Access. In SQ...
I am working on an Access adp that has its data stored in sql-server. I have a sql statement that inserts the date part of a dateTime object into a datetime field of a table. INSERT INTO...DateValue(myDateTimeVariable) What is the time defaulted to? (I am hoping that it defaults to 12:00 AM) ...
Simple question...can the adp2 that I just bought through the Android Market be flashed with Android 2.0? I can't find anything anywhere. The HTC developer support only has system images for the adp1 and adp2 phones up to 1.6. If it can't I will be sending the phone back for a full refund. Thanks. ...
I have been tasked with moving an existing MS Access application (mdb) over to an Access Data Project (adp). Basically the Access forms will remain the same but the data will be migrated over to SQL Server. I am not too familiar with Access Data Projects so I was hoping I could get some opinions on the pros and cons of using them. My f...
I'm having problems with the execution of ServerFilterByForm in Access 2003 When I apply the entered filter it returns the requested data but after it appear on screen (Form) it disappears. Don't know why this is happening Does anyone had the same problem? How can it be solved? Heris is part of the code Private Sub Form_ApplyFilter(Can...
I have been tasked with taking an Access 97 application and moving the back-end data to SQL Server while moving the front end to Access 2003 (using Access Data Projects). In the process of this migration the back-end data structures will be changed significantly to support new functionality. If I had my wish we would not be using Access...
I have been tasked with writing an ADP application using Access. The back-end data will be stored in SQL Server. We have SQL Server 2000, 2005, and 2008 available to us. Requirements dictate that Access must be used but I may have a choice of using Access 2003 or Access 2007. My first thought was to push for Access 2007, because it was n...
I am trying to determine the best approach when designing a new Access based application. Due to decisions made by others I have to use Access 2003 as my front end and SQL Server as my back-end data store (I would have preferred to use Winforms/WPF and SQL Server 2008 but that is another story). Originally I was thinking of using Access...
I have an Android Developer Phone with Android 1.6 installed, sometimes it will take 30 seconds for the home screen to appear after a call or exiting from an application. Why is my phone so slow? Should I replace the memory card? Also, when is the 2.0 coming out for the ADP2? How do I install it? ...
Hi This never happened before, the apd doesnt return any error messsages, just calls the stored proc (delete statement) but doesn't complete, no error message. This only happens when calling the sp on SQL Server 2005, it's fine with the same query in SQL Server 2000. It doesnt make any sense! Please Help!! I've run out of ideas, I wi...
I have an Access Project (ADP) that is currently configured to connect to an SQL Server 2000 database on one server. I now need to migrate that server to SQL Server 2008 that will be on a different server. I've not developed in Access for a while and have not done anything like this before... Is it just a simple matter of modifying a ...