Big problem

[Cereldine]

Im having some big problems with my database. If i make any ammendments in my vba code it refuses to let me save them. I get the message 'save operation failed'. Is the only way around this to insert existing objects into new database?

This method causes a further complication! forms open fine first time, if you exit the database and then re-enter it can't find some of the methods/functions e.g 'cannot find trim function'

Any idea what is going on?
thanks

 

[Mile-O]

Open a module, go to Tools -> References and see if any are MISSING.

 

[Cereldine]

they are all there, but more worringly in the new database none of the code is visible and im getting the message - error accessing file - network connection may have been lost

 

[tkpstock]

Try doing an MS Office repair.

Also, bring the database to your local machine and see if you have the same problem. Do a compact/repair on the database - also do a Debug > Compile in the VBA menu.

Is your network connection flaky? Do you have other problems with your computer connecting to the internet / network?

HTH.

 

[Summerwind]

You get these symptoms if your app was closed whilst code was suspended for some reason.

If this is what's happened, you won't be able to repair the app and just get the same "Connection lost" message.

A sure cure, but a total pain, is to copy each form, query etc from the broken app into a new one. You won't be able to export or import becuse of the Lost Connection fault.

With your modules you will have to copy them one at a time, then compile the new app after each paste. If you're lucky they will be ok. If not you will have to create a new module then copy and paste the code from old to new.

I've had to do this a couple of times when I have suspended execution whilst de-bugging then forgotten to reset the app. That's why I'm fairly sure you have a solution.

Best of luck!

 

[Cereldine]

Cheers, your sounds like the best but probably most tedious way of fixing the problem!