Error when creating database

[Guest]

Hi,
I am using MS Access 2000 and have the following problem. I am creating a
file based on the template "Contact Management". Later on I want to customize
it to suit our needs. But when it is being created by the wizard it creates
the file but gives the following message: "Microsoft Access can't apply the
filter because all records all locked". When I try to use some of the items
on the switchboard it tells me that there was an error executing the command.
Any help is appreciated.
Regards, Lupe

 

[Guest]

Hi Lupe,

I just used Access 2000 (with service pack 3) to create the Contacts
Management database. I received no errors in the process, and my switchboard
works fine. So, there appears to be something misconfigured in your
installation of Access. Let's try the shotgun approach to solving this
problem.

First, is your installation of Access updated completely? Use the following
KB article as a guide:

How to keep a Jet 4.0 database in top working condition
http://support.microsoft.com/?id=303528

Make sure that you have service pack 3 (SP-3) for Office 2000 and SP-8 for
the JET database engine installed. Also verify that you have the latest
service packs for your version of the operating system.

Try temporarily disabling your antivirus software? Does this allow the
wizard to function properly? Here is more information on this topic:

http://groups.google.com/group/micr..._frm/thread/287b312d799c6739/2543458dbca8ddde

and

http://alexdyb.blogspot.com/2006/02/be-careful-with-kaspersky-anti-virus.html

If that does not help, then try a detect and repair operation, which you can
initiate for the Help menu. You may be prompted for your installation CD
during this process.

Here is my standard boilerplate text for dealing with wizard related
problems. Switchboard related errors are often related to the ADO library not
being registered correctly on your PC.

Try the following steps. You possibly have other wizards that are not
functional as well.

Replace three files on your hard drive, Acwzmain.mde, Acwzlib.mde and
Acwztool.mde, using the instructions shown in KB 303769. One or more of these
files may have become corrupted. Do this without Access running.

http://support.microsoft.com/?id=303769
http://support.microsoft.com/?id=833220 <--- Error in loading DLL

1.) Insert the Microsoft Office or Access compact disc.
2.) By using Windows Explorer, open the Pfiles\Msoffice\Office\1033
folder on your CD-ROM or DVD-ROM drive, and locate the
Acwzmain.mde, Acwzlib.mde and Acwztool.mde files.
3.) Select these files, and then click Copy on the Edit menu
4.) Open the folder that you installed Office into. The default folder is
C:\Program Files\Microsoft Office. Select the Office\1033 folder,
and then on the Edit menu, click Paste.

If that doesn't fix the problem, try re-registering the Accwiz.dll,
Msado15.dll and DAO360.dll files.
Click on Start > Run. Then enter the commands:

Regsvr32 Accwiz.dll
Regsvr32 "C:\Program Files\Common Files\system\ado\Msado15.dll"
Regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll"


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________