Stack Overflow
Stack Overflow

Questions tagged [adp]

Access Data Projects provided a lightweight front end to Microsoft SQL Server with Access versions from 2000 to 2010. Note ADP was deprecated in Access 2010 and is unsupported as of Access 2013.

Access Data Projects (introduced with Microsoft Access 2000) provide a lightweight front end to to Microsoft SQL Server.

An ADP can only connect with one database on one server, but the full range of SQL queries is made available by the ADP's ability to create views and stored procedures that are stored on the server.

Bugs can occur when connecting with schemas other than dbo, such as support for extended properties (where the ADP stores settings such as combo box data source and column widths).

ADP was deprecated in Access 2010 and is no longer supported as of MS Access 2013. Because of this, some functionality is lost when connecting to SQL Server 2012 and later, as the ADP no longer supports altering the date/views/stored procedures.

77 questions
1
vote
1 answer

Error when adding values to an Access ADP form bound to a SQL stored procedure with a join

I have an Access 2003 ADP project that connects to SQL Server 2008 Express Edition. When I try adding values to a form that has as it's RecordSource a SQL Strored Procedure that uses a JOIN, I get the following error: You can't update the record…
user1202134
  • 233
  • 2
  • 10
1
vote
2 answers

Wrong number of arguments for DoCmd.OpenReport in MS Access

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…
James Allen
  • 6,406
  • 8
  • 50
  • 83
0
votes
3 answers

Method to generate pdf from access+vb6 or just sql 2005?

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…
Paulj
  • 3,096
  • 3
  • 25
  • 30
0
votes
1 answer

Query parameters not working with MS Access ADP project

I want to create two linked subforms on a form. For this I need to set query parameter into the record source of the second subform like this: select col1, col2 from my_table where col3=[Forms]![MyForm]![subform1]![MyField] This works with .accdb…
Oliv
  • 10,221
  • 3
  • 55
  • 76
0
votes
1 answer

installing the app in the emulator, keeps installing

I have this app. It works fine on my phone and it used to work fine on the emulator. But when I did an update of Eclipse to Android API 15, the trouble started. If I want to run my app on the emulator i get the following output in my Console …
Steven Straatemans
  • 61
  • 1
  • 10
0
votes
1 answer

Problems with Access 2007 Project Form filters

I am in the process of moving several Access databases into a SQL 2008 R2 server using Access 2007 Projects as the frontends and we're running into problems when users are trying to filter data from the forms. Example: I have one project file…
ByerRA
  • 1
  • 2
  • 3
0
votes
1 answer

Problems with Access 2007 Project Forms not allowing input/update data

It's been a while since I had to do anything with an Access Project so forgive me if this something easy. I have an Access 2007 database which I have converted into an Access 2007 Project. I've created all the tables & views on a SQL 2008 server,…
ByerRA
  • 1
  • 2
  • 3
0
votes
1 answer

Find not behaving consistently in .ADP form

Is there something wrong with the following code (in an ADP form) ? Private Sub cmbSearchCode_AfterUpdate() Me.Recordset.Find "usr_cde = '" & ctl & "'"` ctl = null end sub It behaves erratically: the first times after opening the form, it…
iDevlop
  • 24,841
  • 11
  • 90
  • 149
0
votes
1 answer

An unhandled win32 exception occurred in MSACCCESS.EXE

I'm a web developer who's taken over an ADP project and needs help with the Windows and Access Environments. I was coding in VBA in Access 2007, and would at times need to rebuild the project by importing forms, reports, and modules due to…
AccessCorruption
  • 1
  • 1
  • 1
0
votes
0 answers

Microsoft Access 2010 ADP cannot add new records to Updateable Snapshot, only when connecting to Amazon RDS for SQL Server 2019

We have a Microsoft Access 2010 ADP file, which is currently working perfectly with a Microsoft SQL Server 2019 (on-premises) database in the back end. As part of a project, we are trying to migrate the backend to Amazon RDS for SQL Server. After a…
DRVR
  • 163
  • 2
  • 12
0
votes
1 answer

Customize error messages in adp project - SQL 2005

Hi I have a adp/SQL project running with my db. Everything is ok but is there a way to customize error messages. Example: read user cannot update one field so he receives the standard SQL error msg. Is there a way to make it more user friendly?
Tony
  • 51
  • 9
0
votes
1 answer

Can't find ADP login page password box by webdriver

I want to download report from ADP platform through webdriver, but I can't locate the login page password box. Can anyone help me, thanks a lot! Blow is my part code: print("start to…
Phenix
  • 1
  • 1
0
votes
1 answer

ADP API Update Worker Information

I am trying to make updates within the ADP Worker API, though I keep getting "403: Invalid Scope" for the error. I am using this reference guide, specifically the People > Personal Information > Personal Profile > Contact > Add Home Phone section. I…
Kyle Durigan
  • 43
  • 2
  • 9
0
votes
0 answers

What a reason that Filter in MS Access doesn't work the same on different computers

I have an old MS Access 2013 .adp project connected to SQL2019 database. In project I have the forms based on queries from SQL Server. On this forms user can choose an employee ID from the combobox "EmpId" and get rows related to choosed employee…
Mich39
  • 1
0
votes
2 answers

Powershell ADP API Token

I am running the following in Powershell. I am getting an error returned that "The given client credentials were not valid". I am trying to do the first step of using the API, generating the access token. I have confirmed that I have a valid…
Kenny
  • 3
  • 2
1 2
3
4 5 6