Can't create new form (2nd posting)

  • Thread starter Thread starter Neil Terry
  • Start date Start date
N

Neil Terry

I really need help on this problem. Access 2002 is pretty
useless without being able to create new forms.
I am reposting the information that I posted on 9/17
because it appears that the original post is getting
buried by time.

I'm using Access 2002 and when I try to create a new form
using the wizard, as soon as I select a table I get this
message: "You made an illegal function call".
I uninstalled and reinstalled Access 2002 but that didn't
fix it.
Since I already have some forms, I conclude that this
problem has cropped up recently. I possibly created the
forms on my Win2k machine.

When I use Access 2000, I don't have any problem.

I'm using Windows XP home.

When I use Access 2002 on my Windows 2000 Prof. machine, I
don't have any problem creating a new form. This only
occurs on my Windows XP home machine.

Neil
 
This sounds more like a Windows XP problem than as Access problem. Does
this only occur with a particular file or does it happen eveytime? If its
only that one database, it may be correcupted. Create a new database and
import eveything from the old database into the new one and try creating
your forms then. Good luck.

Kelvin Lu
 
Thanks Kelvin.
It happens with any database.
Neil
-----Original Message-----
This sounds more like a Windows XP problem than as Access problem. Does
this only occur with a particular file or does it happen eveytime? If its
only that one database, it may be correcupted. Create a new database and
import eveything from the old database into the new one and try creating
your forms then. Good luck.

Kelvin Lu




.
Click to expand...
 
Neil Terry said:
Thanks Kelvin.
It happens with any database.
Neil
Click to expand...

Have you tried creating forms without using the wizard? Does that work?

Have you tried repairing your installation of Access 2002 on the machine
where it's failing?

You might also try re-registering dao360.dll.
 
I encountered a problem when running: regsvr32.exe
dao360.dll.
I got the following message from regsvr32: Load library
("dao360.dll") failed - The specified module could not be
found.

I copied the run command from your message and also double
checked the spelling. I also did a search on my C: drive
and that module could not be found. I tried running the
Access 2002 repair again but it didn't help.

If I need to get a copy of dao360.dll, please tell me
where I can get it and where it should be placed.

Thank you,
Neil
 
The one you want to register is
c:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll

If you want you can search for
regsvr32.exe; dao360.dll

Then in the search results it will list these two; just drag dao360.dll and
drop it on regsvr32.exe
 
Joan,

Thanks for your reply. The drag and drop method you
mentioned worked correctly to register dao360.dll but I am
still getting the "you made an illegal function call" in
Access 2002 when trying to creat a new form with the
wizard.

I should mention that I am using the upgrade to Access
2002 from Access 2000 (a part of Office 2000 prof.). This
means that I must first install Access 2000 then install
Access 2002 because of the upgrade requirement. I don't
know if this might have something to do with my problem or
not.

Thanks again,
Neil
 
Have you tried Dirk's other suggestions?

I would reinstall. FYI, you don't need to install 2000 in order to install
the upgrade. When you install 2002, at some point it will look for a
qualifying product for the upgrade. Just put the 2000 CD in and point to
it; it will find it and continue with the installation of 2002.

Try uninstalling everything, and reinstall.
 
Neil Terry said:
Joan,

Thanks for your reply. The drag and drop method you
mentioned worked correctly to register dao360.dll but I am
still getting the "you made an illegal function call" in
Access 2002 when trying to creat a new form with the
wizard.

I should mention that I am using the upgrade to Access
2002 from Access 2000 (a part of Office 2000 prof.). This
means that I must first install Access 2000 then install
Access 2002 because of the upgrade requirement. I don't
know if this might have something to do with my problem or
not.
Click to expand...

I'm guessing it does, one way or another. Did you end up with both
Office 2000 and Office 2002 (or maybe just Access 2002) installed on
your system? Did you upgrade just Access, or the whole Office suite?
If it was the whole Office suite, I'd try completely uninstalling Office
2002, and then completely uninstall Office 2000, and then reinstall
Office 2002. As Joan has noted, you don't need to have Access 2000
actually installed on your system to qualify for the upgrade. If you
just upgraded Access, you should probably just uninstall the Access
versions, in reverse sequence, and then reinstall Access 2002. If
neither of these procedures works, I'm at a loss for the moment.

To completely uninstall Access 2000, see this KB article:


http://support.microsoft.com/default.aspx?scid=kb;en-us;203370&Product=ofw2k
HOW TO: Completely Remove Access 2000 from Your Computer

I note, though, that it says the Eraser2000 utility isn't to be used
with Windows XP.
 
Thanks to Dirk and Joan

I removed both Access 2000 and 2002 then reinstalled 2002
and now it seems to be ok. I say seems because when I
opened 2002 from the Start menu, it worked ok but when I
opened it from the linkage in the toolbar, I got the same
old 'illegal function call' message. I removed the link
from the toolbar and then recreated it and now that works
too. Seems strange to me.

I'm using Office XP Small business but had previously been
using Office 2000 Professional which allowed me to upgrade
to Access 2002. I now have Office XP SBE and Access 2002
running and I think it's ok.

Neil
 
Back
Top