Cannot import switchboard form

[Joallyn]

Hello listers,

I've run into (yet another) Access problem that has me stumped. It started with an unfortunate finger spasm that deleted my latest and greatest "Incidents" form. To fix the problem, I imported the same form from my most recent backup. After that, I got an error message on startup ("Microsoft VB: Error accessing file. Network connections may have been lost.&quot Now my switchboard doesn't work, and I get multiple other errors.

I tried importing the switchboard form into the most recent database, but nothing happens. Neither can I import the repaired Incidents form backwards, into previous dbase copies that have a working switchboard.

Has anyone run into this before?

I would greatly appreciate any suggestions...

thanks

J

 

[Darrylles]

Hi joallyn,

a)I take it you've tried 'compact and repair' of both the supplying and receiving db's?

b)You don't mention whether the supplying and receiving db's are from the same or different Access versions.
When importing Switchboard forms from Access '97 to 2000, there may well be problems due to VBA differences.

c)Try opening both databases AT THE SAME TIME. Right click the form from the back-up and paste into the receiving db (rather than using import).

Can't think of anything else to try.

Regards,

Darrylle

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[Joallyn]

Hi Darrylle,

thanks for replying. I tried compact and repair (no luck), and my versions were both MS2000. I didn't get a chance to try your last suggestion, since I finally got it back and running, after searching through the archives and finding the following link recommendation:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q304548&

It's not perfect, but it pointed me in the right direction.
What I first tried was creating a new dbase and importing everything from the previous versions, but I still got errors when I tried to import the offending form. I then opened a previous version that had a copy of that particular form. I viewed the code, and changed the HasModule property to False. I was then able to import it into the new dbase.

Geesh. Apparently, one should not copy or paste forms that contain code modules into other Access dbase version.

cheers,

J

 

[Darrylles]

Hiya,

I'd agree with that statement (as in my point ( b )), however, you have said that yours were both 2000?

Should be no probs. therefore.

What I do think, (from your initial post) is that you somehow got temporarily disconnected from the network and the form was corrupted on import.
Access probably got 'confused' by the corrupted form.

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."