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

Subform data not updating table

I am running MS Access 2010 as a front end to SQL Server Express 2008 R2 using an Access Data Project. I have two tables: "Individuals" and "Researchers". The "Individuals" table has primary key "Individual_ID". A foreign key in the "Researchers"…
Brash Equilibrium
  • 1,357
  • 4
  • 14
  • 35
1
vote
0 answers

"proper client ssl certificate was not presented" postman error

My postman request errors-out with status: 401 Unauthorized and "error_description": "proper client ssl certificate was not presented". I have confirmed in both MMC and MS Edge that ADP certificate is installed - it shows-up in a list of…
Sasha
  • 11
  • 1
  • 3
1
vote
3 answers

How do I open an old Microsoft Access adp file with invalid connection strings?

We have moved our SQL Server instance to a new hosting company. Months later (after the overlapping migration period), front office have dug up an old adp file (old-school access data project) which connects to our (now non-existing) SQL Server. I…
Hansjp
  • 66
  • 1
  • 6
1
vote
2 answers

Filter subform based on what is typed in a textbox on the subform

I'm trying to filter the records shown on a subform based on what is typed in a textbox on the subform. The subform is called Users, and it is on the Group form. On the Users subform there is a textbox called txtFilter. If I type "W" in txtFilter, I…
dmr
  • 21,811
  • 37
  • 100
  • 138
1
vote
1 answer

Recordsource vs Recordset for Unbound Forms

I am creating a application which uses Access ADP (Access Data Project). as the front-end and SQL Server as the back end. I am using ADODB for the connection. I have been doing some research as to whether to use the RecordSource property or…
Adib Akale
  • 105
  • 9
1
vote
1 answer

Force MS Access to update through view

I use MS Access 2010 with ADP to update sql database. I wanted to partition some table using views and provide update permissions on each part to different user. Problem I have is that even when Access is set to work on a view it issues update on…
Kodak
  • 1,779
  • 2
  • 18
  • 29
1
vote
1 answer

ms access adp calls a stored proc (SQL Server ) but just hangs in 2005 but ok in 2000

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…
Joscion
  • 13
  • 4
1
vote
1 answer

Access Data Project (ADP) - Access 2007 or 2003?

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…
webworm
  • 10,587
  • 33
  • 120
  • 217
1
vote
1 answer

Eliminate "dbo_" for view and tables names in Access 2003 ADP linking to SQLSRV 2008 R2?

I'm having an issue where I've created an Access 2003 ADP and connected to a database on SQL Server 2008 R2. On my PC, the table and view names are the same as in the SQL db (e.g., Table1, View1, etc), and I linked the report forms I built to these…
Clint Finch
  • 101
  • 1
  • 2
  • 8
1
vote
4 answers

What is the time of a datetime field in a database if only the date is entered?

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…
dmr
  • 21,811
  • 37
  • 100
  • 138
1
vote
0 answers

When Converting ADP files to ACCDB do server based Stored Procs get converted?

When updating an Access 2003 ADP file to an Access 2010 AccDB file are SQL server linked tables, views and specifically stored procs "updated"? I am finding that I need to redo a fair amount of code around calling parameterized stored procs.
John S
  • 7,909
  • 21
  • 77
  • 145
1
vote
1 answer

Microsoft Access ADP view designer always adds _1 to tables and does not show the fields inside each table

The view designer inside Microsoft Access ADP always adds _1 to all table names, also all table fields are not shown. The only thing that shows inside the table is *(All Columns) I have tried access 2007 and access 2010 and both have the same…
DFAD
  • 41
  • 4
1
vote
1 answer

The multi-part identifier "System.Data.DataRowView" could not be bound." SQL SERVER + VB.NET

I am making a small database using SQL Server as the back and VB as the front end, I have nearly made it work however I have stumbled across this error: "An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in…
user2520014
  • 73
  • 2
  • 11
1
vote
1 answer

Access 2003 ADP + SQL server migrated to 2008: The Data Was Added to the Database But the Data Won't Be Displayed

I have migrated a SQL server 2000 database to SQL Express 2008. Once reassignd roles and permissions, it seems working, however in a form (+subform) when adding new records to the subform, the following error message is given, although the record is…
Riccardo
  • 2,054
  • 6
  • 33
  • 51
1
vote
1 answer

Access 2010 ADP appending a 1 to the end of object names

I've managed to break Access on my laptop. I had Office 2010 installed, then decided to upgrade to Office 2013 after going to an MS presentation. This wasn't the best move for me. I realised after installation that Access 2013 doesn't support…
Mike
  • 105
  • 3
  • 10
1
2
3 4 5 6