Error Creating a Module

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

I've created a new Microsoft Access 2000 SP 3 database.
To get the data into my new database, I've exported the
data from another database. I'm not sure why this would
cause issues, but just thought I'd mention it.

So I go to Moduless, click on New. The code area comes
up and I type in the following

Sub Test()
msgbbox "Test"
End Sub

I get the error message "Error Accessing File. Network
Connection May Have Been Lost." when I try to save the
module.

Any suggestions?

Thanks,
Jennifer
 
Your sub procedure isn't the problem.

When code gets exported to a new database it will corrupt
the project if it doesn't compile. It's best to import
new code, being sure to recompile and save the project
prior to closing the .mdb

Usually the reason it doesn't compile is that a reference
is missing. Are you using DAO objects? Be sure you make
all the necessary references the new code requires prior
to doing the import. good luck.
 
Back
Top