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
0
votes
1 answer

How to link a subform to a combobox on the main form

On a form in an access ADP there is an unbound combobox that displays a list of companies (the name is shown, the id is the bound field). When a company is chosen, I want to display the subscription information in a subform (the datasource for…
dmr
  • 21,811
  • 37
  • 100
  • 138
0
votes
1 answer

How to convert adp to accdb or mdp using Access 2010

I have an access database that is saved as a ADP file and I need to convert it to an ACCDB or MDB file format. The problem is that there are 7 tables (saved as dbo) that are coming from a SQL server 2008 backend. Is there any way to convert this…
Nimish Patil
  • 1
  • 2
0
votes
1 answer

How do linked tables in MS Access works?

Need few inputs on how Linked tables work in MS Access . previously we have MS Access forms as front end and SQL server as backend and we used ADP project. But , now our goal is to convert this ADP to linked tables and accdb project. I have…
Sai Avinash
  • 4,683
  • 17
  • 58
  • 96
0
votes
1 answer

MS Access - Linked tables vs Access Data Project (ADP)? Security?

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…
webworm
  • 10,587
  • 33
  • 120
  • 217
0
votes
2 answers

MS Access: Order of Events in event ApplyFilter (ADP Project)

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…
JAVH
  • 155
  • 1
  • 3
  • 13
0
votes
1 answer

Is MS SQL Server 2014 the best choice for migration of an ADP project from Access 2010 to php?

I have inherited an old MS Access 2010 ".ADP" project that is currently connecting to MS SQL 2005 server. The Access project is mainly a bunch of reports pulled from SQL 2005 Stored Procedures. My plan is migrate to Amazon EC2 and I wondering if I…
iewebguy
  • 316
  • 3
  • 16
0
votes
3 answers

Dynamically create Datasheet from SQL query with VBA in Ms Office Access

I have Access database project connected with Ms SQL Server. Data (tables) is stored in the Ms SQL server and Forms and Reports are stored in the Access .ADP file. It is not possible to create Queries, Tables, Views using Design view but Tables and…
Nikunj Bhatt
  • 188
  • 4
  • 16
0
votes
1 answer

Error after Upgrading access ADP to Access 2013

I'm trying to upgrade my access ADP to Access 2013 Aadc using linked tables. But when running this code Dim cn As ADODB.Connection Dim rstbks As ADODB.Recordset Set cn = CurrentProject.AccessConnection Set rstbks = New ADODB.Recordset Select Case…
Mahag
  • 25
  • 10
0
votes
1 answer

how to create javascript array from tcl array

please assist me in this ,,, I have a tcl array called all_tags ,, but the thing is i need to convert it into a javascript array in my page but i am weak when it comes to javascript . please advise me if below is correct and if not ,,what is the…
sisimh
  • 1,287
  • 3
  • 20
  • 37
0
votes
1 answer

Acess 2007 adp project with SQL Server 2005 Express database

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…
user202627
0
votes
1 answer

How to dynamically position a text box in Access 2003 report?

I have an Access 2003 project (.ADP) which is a front end to a SQL Server 2005 database. In this ADP, I have a report, which is a set of 8 unbound text boxes, stacked on top of each other each with their own labels. Each text box is for…
FMFF
  • 1,652
  • 4
  • 32
  • 62
0
votes
1 answer

Can't make changes to SQL backend from an MS Access Data Project

I have a MS Access 2010 Data Project (adp) connected to MS SQL Server 2008. Based on Microsoft's website, I should be able to modify the SQL backend from within the MS Access 2010 Data Project. Once you connect to an SQL Server database, you can…
TTT
  • 21
  • 3
0
votes
3 answers

"Silent" errors in .ADP with SQL Server

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…
knittl
  • 246,190
  • 53
  • 318
  • 364
0
votes
5 answers

Microsoft Access ADP UPDATE Query does NOT update

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…
joedotnot
  • 4,810
  • 8
  • 59
  • 91
0
votes
1 answer

Using Access 2003 ADP/Project files to access SQL Server 2005 database

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…
Phil
  • 265
  • 2
  • 4
  • 11
1 2 3 4
5
6