MS Access failed to create the Visual Basic Module '|,'

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

Guest

I am trying to create a VBA pocedure to work with a Combo Box. Every time I
try to enter the procedure code, I click on the "..." to create the
procedure, and I get The Choose Builder window. I choose Code, and hit OK.
Then I get the "subject" error (above),with an explanation:

" If your database is on a network drive, check your network connecction,
and then try again", with an OK button.

There are no modules created in the database. I don't know what the data
following the word Module mean: '|,'

Wish I could give you more information, but that's all I have.
I'm using VBA 2000 (9.0.4402 SR-1).

I would appreciate any help you have.
Regards,
10SNUT

10SNUT
 
If there is any code in any form, there is a Module (the form's class
module). As soon as you start the code builder, you open a module. The pipe
character, | is merely a placeholder for a name in the error message.
Access database front-ends are better created on a workstation and later
backed up on the server. The tables are split and linked from the server.
There is a good chance that your database is corrupted. I would create a
new, empty and import the objects (forms, reports, etc.) 1 at a time. Make
sure you add or change any references that you may have set in the original.

More information on corruption and how to avoid it

Have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top