If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Error with Export
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? -- Daniel |
#2
|
|||
|
|||
Error with Export
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. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Daniel Pineault" wrote in message ... 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? -- Daniel |
#3
|
|||
|
|||
Error with Export
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 "Arvin Meyer [MVP]" wrote: 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. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Daniel Pineault" wrote in message ... 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? -- Daniel |
#4
|
|||
|
|||
Error with Export
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 "Daniel Pineault" wrote in message ... 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 "Arvin Meyer [MVP]" wrote: 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. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Daniel Pineault" wrote in message ... 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? -- Daniel |
#5
|
|||
|
|||
Error with Export
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 "Daniel Pineault" wrote in message ... 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 "Arvin Meyer [MVP]" wrote: 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. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Daniel Pineault" wrote in message ... 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? -- Daniel |
Thread Tools | |
Display Modes | |
|
|