[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 724
  • 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

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

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