Solved

ADP1.ADP - ADP2.ADP - ADP3.ADP

Posted on 2006-06-15
3
663 Views
Last Modified: 2008-01-09
We are using multiple ADP's to access SQL 2000. (one for ea. user) User A's ADP got stuck on a filter and was unable to see any other items. This user didn't set the filter. It appears that no one did. We noted that this user started with 1 ADP and now has about 27 or more in her personal folder. They are sequential; adp1.adp; adp2.adp, etc. an are dated several days apart from each other beginning May 10, 2006 and continuing till the current date.  We didn't create these. How is this happening? Thanks very much for any insites.

Alan
0
Comment
Question by:apij
  • 2
3 Comments
 
LVL 44

Expert Comment

by:Leigh Purvis
ID: 16917381
Can't recall is Access 2002 does it, but 2003 certainly can perform these automatic backups after an unexpected termination of the application.  (A crash).
They're annoying often.
You normally get a dialog informing you that a crash happened and one will be created (where upon you can chose *not* to).

You might have a bug in your code - or there might be a less tangiable problem.
A clean FE might get you back on track.
(By clean - making sure of no corruption)

Example corruption steps
http://www.experts-exchange.com/Databases/MS_Access/Q_21603768.html

However not all of those will apply to an ADP.
(Decompile will though ;-)
0
 
LVL 17

Accepted Solution

by:
Arji earned 250 total points
ID: 16918001
Also, make sure and do your Office and OS service packs but Leigh is right about removing the corruption.  The easiest way is to create a new project with same data and then import everything except tables, queries and diagrams into the new project from the corrupt project.  See File | Get External Date | Import.  I just had to do that yesterday for a crashing program.....and it seems there is no one thing that causes it either.
0
 
LVL 17

Expert Comment

by:Arji
ID: 16918005
 File | Get External Data | Import
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now