Access: Visual Basic File not found box???

[YACHTIE]

Hi all,
Am running a Access 2K version in Win XP and suspect due to someone leaving the database open over the weekend.....duh....
Now we cannot open the said database anymore without being pestered by this meaningless dialog box:
The yellow triangle ok box which states file not found from Visual basic, cannot do "Alt F11" either without getting this same past poppin up.

Have tried Microsoft's knbse article

http://support.microsoft.com/kb/248960/EN-US/

also w/o success, halfway thru the export routine get same message and efectively stops me from comntinuing.

Archive search has not produced anything helpful.

Any suggestions are welcome

 

[jadams0173]

I would try to decompile the db and if that doesn't work maybe try importing all the objects into a new access db.

"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile "X:\Your.mdb"

After you decompile compact the db and close it. Also hold down the shift key to bypass startup macro's ect. Open it again and see what happens. If it works got to the VBA screen and under the debug menu compile the project again.

I tried to have patience but it took to long! -DW

 

[YACHTIE]

Thanks for the suggestion, however neither work, am unable to copy the objects after the first dozen or so start getting the same silly messages. And prevents me from copying.

Now the kicker... this morning all is well and guess what our server got rebooted last night.

Looks like all the date is there now and accessible.

Needless to say I am not too impressed by our IT dept.

Never know this my help someone somehow

Best Regards

 

[Bandenjamin]

To prevent future problems try adding a form that quits the application after a certain length of time. I use a hidden form that launches on startup with the timer set to 43,200,000 (milliseconds) That works out to about 12 hours and will prevent people from being signed in for too long.

 

[YACHTIE]

Would love that can you post the code for that for me?

Appreciated,

REgards,

Gerrit

 

[Bandenjamin]

Create an event procedure on the Timer() form with the following.

Private Sub Form_Timer()
DoCmd.Quit acSave

End Sub

Make sure you don't set the timer too low!! First time I did it I tested it at 1000 on the timer interval. Which is only 1 second....kinda tough to fix. I would set it for at least 60000 so you have to wait full minute.

 

[Bandenjamin]

sorry. It goes as an event procedure in the OnTimer field of the form properties.

 

[YACHTIE]

OK, thanks a bunch but forgive my ignorance on this, can you be more specific on how to get this working?
Whatever I tried does not seem to fly for me.......

Thanks

 

[Bandenjamin]

1. Create a form in design view and call it TimerForm or whatever you like to help you remember.

2. Right click on the upper left corner of the form and select Properties.
3. Click on the Event Tab.
4. Scroll down to "On Timer" and click the 3 dots to the 5. right of the field.
6. Select Code Builder from the list.
7. Input the following code

Private Sub Form_Timer()
DoCmd.Quit acSave

End Sub

8. Close code window (you should now be back at the properties box)
9. In the "Timer Interval" filed input the number of milliseconds you want the app to stay open 43200000 is 12 hours.
10. Close the properties box. Go to Tools then Startup.
11. In the Display Form/Page field select your timer form.
12. Then hide your form going to window>Hide. I also hide the form on the DB window.

If you already have your database launching with a that isn't closed you can also insert the timer instructions in that and get the same results.

Hope that helps.

Dan.

 

[YACHTIE]

Thanks for the explicit instructions, got it working somewhat.....
Problem being I already had a startup form that contains functional items for the user that we cannot do without, and that form does no longer show up, also the timer form does not like to hide.......it comes up each time the dbase is opened.

Apprecuiate the help any other suggestions on how to over come this?

TIA

 

[Bandenjamin]

Sure since you already have a form that starts up just put the code in the timer properties of that form.