Why?

[jahoobob via AccessMonster.com]

I have a front end to an employee info db that resides on a network drive.
One person uses this frontend. I made changes to this fe, added three trial
modules that opened reports from a from and closed without testing them. The
regular user opened the fe and got the Invalid argument error and couldn't do
anything without the debugger going to one of these new modules. I had named
the form field that returned the report name incorrectly. She closed it on
her computer and I opened it on my computer with no problems. I compacted &
repaired OK. She still got the same error. I deleted the three modules and
compacted and repaired. Still the same error and the three modules showed.
I deleted them from here view and closed and opened the db. Same error and
the modules still showed. Went to my computer and the modules were gone. I
even did a restart on her computer and the problem remained.
I "fixed" the problem by importing all the objects into a new db and she can
now work in it.
Does anyone have any idea about what was going on here?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200606/1

[pietlinden]

If the problem goes away when you import all objects into a new db, it
sounds like a corrupt object somewhere in your db.

[david epsom dot com dot au]

VBA 6, used by Access 2000, 2002, and 2003, has bugs and is poorly
integrated into Access, particularly Access 2000.

MS did fix some of the bugs in Access 2000, but as Access 2002,
not as a service pack.

Your solution (importing everything into a new database) was
good and correct.

Often, you can fix this kind of problem by using the /decompile
command line option: create a shortcut to MSACCESS.EXE, then
add the /decompile option to the shortcut. Use the new shortcut
to open the MDB with the corrupt project.

This specific problem you had can sometimes be fixed by deleting
the module from the VBA project window, instead of using the
Access database window.

(david)
"jahoobob via AccessMonster.com" <u12179@uwe> wrote in message
news:6282eda5535d0@uwe...

I have a front end to an employee info db that resides on a network drive.
One person uses this frontend. I made changes to this fe, added three
trial
modules that opened reports from a from and closed without testing them.
The
regular user opened the fe and got the Invalid argument error and couldn't
do
anything without the debugger going to one of these new modules. I had
named
the form field that returned the report name incorrectly. She closed it
on
her computer and I opened it on my computer with no problems. I compacted
&
repaired OK. She still got the same error. I deleted the three modules
and
compacted and repaired. Still the same error and the three modules
showed.
I deleted them from here view and closed and opened the db. Same error
and
the modules still showed. Went to my computer and the modules were gone.
I
even did a restart on her computer and the problem remained.
I "fixed" the problem by importing all the objects into a new db and she
can
now work in it.
Does anyone have any idea about what was going on here?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200606/1