Importing VBA Code from another Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I recently imported all the the tables, queries, forms etc from one Access
200 database to another and found that all my event procedures now do not
work. When I click on a command button or try to run a procedure in a form
it tells me there is an error finding the file, possibly a network error.
Can you suggest how to fix this?

regards
Dan
 
Hi, Dan.
Can you suggest how to fix this?
Click to expand...

As Dirk Goldgar explained yesterday, you are the victim of a nasty bug.
Please see his answer on the following Web page:

http://www.microsoft.com/office/com...1c31&cid=ee2bd67f-8368-4792-8e52-a35e69d5c4c4

Your current database is corrupted. If you don't have a backup to restore
from then the steps to fix the problem are all explained in KB article
304548. Namely, after installing MS Office 2000 SP-3 on all computers with
Access 2000 that access this database file, create a new database, then
import all objects into this new database. Some of the forms, reports or
modules will not be able to be imported because they are corrupted. These
may possibly be recovered by copying and pasting the code from the corrupted
objects in the bad database into new modules in the brand new database. You
may even need to rewrite any code that is not recoverable with an import or
copy/paste operation.

When you are finished, compile the code, then compact/repair the new database.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)
Yellow Page info: Scott Ripley - (304) 863-9540 - Rr 3 Box 269a,
Washington, WV 26181

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that the first and
best answers are often given to those who have a history of rewarding the
contributors who have taken the time to answer questions correctly.
 
Excellent, Thanks to all for the assistance

'69 Camaro said:
Hi, Dan.


As Dirk Goldgar explained yesterday, you are the victim of a nasty bug.
Please see his answer on the following Web page:

http://www.microsoft.com/office/com...1c31&cid=ee2bd67f-8368-4792-8e52-a35e69d5c4c4

Your current database is corrupted. If you don't have a backup to restore
from then the steps to fix the problem are all explained in KB article
304548. Namely, after installing MS Office 2000 SP-3 on all computers with
Access 2000 that access this database file, create a new database, then
import all objects into this new database. Some of the forms, reports or
modules will not be able to be imported because they are corrupted. These
may possibly be recovered by copying and pasting the code from the corrupted
objects in the bad database into new modules in the brand new database. You
may even need to rewrite any code that is not recoverable with an import or
copy/paste operation.

When you are finished, compile the code, then compact/repair the new database.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)
Yellow Page info: Scott Ripley - (304) 863-9540 - Rr 3 Box 269a,
Washington, WV 26181

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that the first and
best answers are often given to those who have a history of rewarding the
contributors who have taken the time to answer questions correctly.
Click to expand...
 
Back
Top