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
9
votes
2 answers

How to use javascript variable in iframe src

how to write javascript variable in iframe src? Like Here ReturnURL() is a javascript function which…
Johnny
  • 1,555
  • 3
  • 14
  • 23
9
votes
2 answers

Setting EditText to single line makes it lose its focus after pressing enter

I use an EditText in my code and compare its content to a string when clicking on a button. Unfortunately doing this with the enter key through onKey causes problems because enter creates a line break. I used: setSingleLine(true); to prevent this.…
user3086884
  • 93
  • 3
7
votes
2 answers

How to convert an ADP to ACCDB using Access 2013?

Access 2013 does not support ADP. Some alternatives to ADPs are given: Convert the ADP to a linked Access Desktop Database. Import objects into an ACCDE file and then create linked tables to the existing data by using an earlier version of…
A_kumar
  • 401
  • 1
  • 4
  • 12
7
votes
1 answer

Where is the database connection information in an ADP file?

A user entered a ticket for an OLD Access database and form project that they use daily. They are saying that the database cannot be found when they use it. I haven't used MS Access to design a database or interface since college so I have no idea…
ProfessionalAmateur
  • 4,447
  • 9
  • 46
  • 63
5
votes
5 answers

Access ADP - For/Against?

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

How do I edit an Access ADP file?

So I have this Access Database Project file that I have been tasked to edit. I have Access 2003 and 2007 installed. The ADP only supports 2003 for some reason. Anyway, the issue I have is that I can't figure out how to get to the VBA code in…
Michael Beck
  • 2,806
  • 3
  • 20
  • 22
4
votes
1 answer

Can't update view with INSTEAD OF trigger

My database is an Access Data Project, tied to a SQL Server 2005 backend. I'm trying to bind a form to a view that uses an INSTEAD OF trigger. Access thinks the view isn't updatable, so it's making the form read-only; apparently it doesn't take the…
Jeff Rosenberg
  • 3,522
  • 1
  • 18
  • 38
3
votes
3 answers

Ahhhhh! Where did the subform go?

I have a form called Group in my MS Access ADP. On it is a tab control, and in each of the tabs there is a subform. The first tab contains the subform Users, and it isn't showing up in form view. Subform Users shows up in design view. Any clue as to…
dmr
  • 21,811
  • 37
  • 100
  • 138
3
votes
2 answers

MS Access ADP Disconnected Recordset Reverts

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…
SLeepdepD
  • 91
  • 1
  • 9
3
votes
1 answer

Access ribbon items execute VBA functions

I have some problems configuring my ribbon. Only macros are working as onAction or getPressed attributes. Functions in standard modules don't work. Callbacks written in standard modules don't work either. How can I use the value of edit box in VBA…
iamx4nd3r
  • 81
  • 1
  • 6
3
votes
3 answers

How to refresh the table list using vba in access 2007

How to refresh the table list using vba in Access 2007. I make table in Sql code using vba: DoCmd.RunSQL "SELECT * INTO table2 FROM table1", True RefreshDatabaseWindow DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\import.mdb", ,…
crywar
  • 73
  • 1
  • 1
  • 6
2
votes
1 answer

2-Microphone Android Phones for ASR purposes?

Is the Nexus One the only Android phone having 2 microphones? I know that the 2nd microphone is intended for helping noise cancellation and I need this feature for my software development project. I am wondering whether the Nexus One is the only…
Android Eve
  • 14,864
  • 26
  • 71
  • 96
2
votes
2 answers

Configure ADP application to use a different database...?

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. Is it just a simple matter of modifying a…
Sambo
  • 1,472
  • 5
  • 21
  • 33
2
votes
1 answer

whats the difference between "getPressed" and "onAction" button properties in xml ribbon code?

Help me please. I am doing adp-project ribbon using xml code. And i don't understand what is the difference between "getPressed" and "onAction" button properties?
iamx4nd3r
  • 81
  • 1
  • 6
2
votes
1 answer

ADP Alter view in sql from access coding

I have unique issue regarding ADP. I successfully linked SQL database to Access, but here are the issues. I want to update current view, I mean alter view with desired settings.... Is there any way, One can Alter SQL View Design from Access-VBA…
user3021685
  • 23
  • 5
1
2 3 4 5 6