Error with Export

[Daniel Pineault]

I have had a problem with a database and decided to export the objects to a
new db to see if it might help in resolving my problem. I performed an
import of the object without any problems into the new empty db. That said
when I goto the VBE interface and try to access any module (to access the
code)... I always get a network error and I don't get any code?

Has anyone seen this before and is there a remedy?

 

[Arvin Meyer [MVP]]

You should be accessing the front-end of your database on your workstation,
not on the network. If your database isn't split, it should be. That's
probably the cause of your corruption. On your local machine, try rebuilding
the database again, then splitting it and linking the 2 after putting only
the back-end on a server.

 

[Daniel Pineault]

Arvin,

The db is split and the tables work fine. But when I open the db a get an
error stating it can't find the specified function, and when I try on open a
module, clsmodule, form code I get an error about 'unable to access network
file...' and I get no code whatsoever. I am in the front-end, there is not
network file required??!! It's like the import failed without any error
message, like my code vanished. The shells are there (module names, cls
modules name, form module names) but nothing within them.
--
Daniel

You should be accessing the front-end of your database on your workstation,
not on the network. If your database isn't split, it should be. That's
probably the cause of your corruption. On your local machine, try rebuilding
the database again, then splitting it and linking the 2 after putting only
the back-end on a server.

 

[Klatuu]

That is a known problem with corruption.
The recommend way to deal with it is to copy all module code and paste it
into text files. This includes report and form modules. After you copy the
code out of a form/report module, delete the code in the module and set the
form/report's Has Module property to no.

Now, after you have imported all your objects into a new mdb, go back and
copy the code from the text files into the modules where they belong.
Tidious, but effective.

Not a guarantee, but it did work for me once.

Here is a link to an article by Allen Browne on the subject:

http://allenbrowne.com/ser-47.html#SaveAsText

Arvin,

The db is split and the tables work fine. But when I open the db a get an
error stating it can't find the specified function, and when I try on open
a
module, clsmodule, form code I get an error about 'unable to access
network
file...' and I get no code whatsoever. I am in the front-end, there is
not
network file required??!! It's like the import failed without any error
message, like my code vanished. The shells are there (module names, cls
modules name, form module names) but nothing within them.

 

[Arvin Meyer [MVP]]

That is a definite corruption problem. Do you have a copy from an earlier
backup? If not, can you see the code in the file you copied from? Make sure
that you have multiple copies of everything and do not work on original
files.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Arvin,

The db is split and the tables work fine. But when I open the db a get an
error stating it can't find the specified function, and when I try on open
a
module, clsmodule, form code I get an error about 'unable to access
network
file...' and I get no code whatsoever. I am in the front-end, there is
not
network file required??!! It's like the import failed without any error
message, like my code vanished. The shells are there (module names, cls
modules name, form module names) but nothing within them.