Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 716
  • Last Modified:

ADP1.ADP - ADP2.ADP - ADP3.ADP

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
apij
Asked:
apij
  • 2
1 Solution
 
Leigh PurvisDatabase DeveloperCommented:
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
 
ArjiCommented:
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
 
ArjiCommented:
 File | Get External Data | Import
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now