Previous watch point still active

bknight
BronzeLounger
Posts: 1463
Joined: 08 Jul 2016, 18:53

Previous watch point still active

Post by bknight »

I thought I asked this before but I had a watch point in some code and now it stop every time the code is executed. What may I do to stop the stop from occurring?

User avatar
HansV
Administrator
Posts: 78794
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Previous watch point still active

Post by HansV »

Does this persist after selecting Database Tools > Compact and Repair Database?
If so:
- Close the database.
- Press Windows key+R to activate the Run dialog.
- Enter the following in the box, substituting the full path and filename of the database:

msaccess.exe "C:\Access\MyDatabase.accdb" /decompile

- Click OK.
Best wishes,
Hans

bknight
BronzeLounger
Posts: 1463
Joined: 08 Jul 2016, 18:53

Re: Previous watch point still active

Post by bknight »

msaccess.exe "C:\users\Me\documents\access\access07\Apex.accdb" /decompile
Took a couple of tries to input correct address.
Thanks

bknight
BronzeLounger
Posts: 1463
Joined: 08 Jul 2016, 18:53

Re: Previous watch point still active

Post by bknight »

There used to be a compact/repair function in the dark ages does it still exist?

User avatar
HansV
Administrator
Posts: 78794
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Previous watch point still active

Post by HansV »

You're using Access 2007, aren't you?
Click the big Office button, then click Manage > Compact and Repair Database.

In Access 2010 and later, Compact and Repair Database is the first command on the Database Tools tab of the ribbon.
Best wishes,
Hans

bknight
BronzeLounger
Posts: 1463
Joined: 08 Jul 2016, 18:53

Re: Previous watch point still active

Post by bknight »

Ok, I see it now.
Thanks