Hi Deb,
It looks like Doug Steele's web page has been moved from Rogers.com to
accessmvp.com. I was unaware of this recent change. The new URL for Doug's
reference errors article is:
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
You find other goodies from Doug here:
http://www.accessmvp.com/djsteele/AccessIndex.html
Thank You for bringing this to my attention.
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
________________________________________
:
Hi, Tom!
Thank you for the links and the valuable information. I will be spending
some quality time reading and developing my database
I'm not certain how
we got the wizard(s) to work, but it sounds like it was a miracle!
Having printed every link I could click, I did notice one of the links is
"missing" and thought you'd like to know:
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html
Thanks again!
Cross-eyed in Ohio
______________________________________
:
Hi Deb,
I'm glad to read that you were successful!
It's interesting to note, from your initial post, that you were able to run
the "create a new database" wizard. Apparently this wizard is not dependent
It has been several years since I've actually used Access,
and I'm hoping the wizards will help me.
Here is a list of URL's that are useful for anyone, but especially for
people getting started:
Naming Conventions
Special characters that you must avoid when you work with Access databases
http://support.microsoft.com/?id=826763
Commonly used naming conventions
http://www.mvps.org/access/general/gen0012.htm
http://www.xoc.net/standards/default.asp
Using a Naming Convention
http://msdn.microsoft.com/library/d...us/odeopg/html/deconusingnamingconvention.asp
Reserved Words
Reserved Words in Microsoft Access
http://support.microsoft.com/?id=286335
List of reserved words in Jet 4.0
http://support.microsoft.com/?id=321266
Database Design
You should spend some time gaining an understanding of database design and
normalization before attempting to build something in Access (or any RDBMS
software for that matter). Here are some links to get you started. Don't
underestimate the importance of gaining a good understanding of database
design. Brew a good pot of coffee and enjoy reading!
http://www.datatexcg.com/Downloads/DatabaseDesignTips1997.pdf
http://www.eade.com/AccessSIG/downloads.htm
(See the last download titled "Understanding Normalization")
http://support.microsoft.com/?id=234208
http://support.microsoft.com/?id=289533
Also recommended: Find the copy of Northwind.mdb that is probably already
installed on your hard drive. Study the relationships between the various
tables (Tools > Relationships...)
Name AutoCorrect
Name AutoCorrect was introduced with Access 2000. This is a most buggy
feature. I recommend always deselecting the options to track & perform
corrections via Tools > Options ---> General Tab. Unfortunately, these
options are selected by default in all new databases, so you should remember
to always deselect it. For more information, see the following article:
Failures caused by Name Auto-Correct
http://members.iinet.net.au/~allenbrowne/bug-03.html
References
Solving Problems with Library References (Allen Browne)
http://members.iinet.net.au/~allenbrowne/ser-38.html
Access Reference Problems (Doug Steele)
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html
Articles I've written which are posted on Qbuilt.com
ADO and DAO Library References in Access Databases
http://www.access.qbuilt.com/html/gem_tips1.html
Combo box to find a record
http://www.access.qbuilt.com/html/find_a_record.html
Crosstab Queries
http://www.access.qbuilt.com/html/crosstab_queries.html
Gem Tips
http://www.access.qbuilt.com/html/gem_tips.html
For an exhaustive list of URL's, please see Jeff Conrad's collection posted
here:
http://www.ltcomputerdesigns.com/JCReferences.html
I am running Access 2000 and Microsoft Windows 2000
(5.00.2195, service pack 4).
Please make sure that you have installed service pack 3 (SP3) for Office
2000. There are some nasty bugs that were subsequently corrected with the
service packs. To verify this, open Access and click on Help > About
Microsoft Access. (You can get this information by using the Help > About
dialog of any Office program). You should also have the latest service pack
installed for the JET database engine as well:
How to obtain the latest service pack for the Microsoft Jet 4.0 Database
Engine
http://support.microsoft.com/kb/239114#2
"Lifeline" Tom
__________________________________
Tom,
I can't thank you enough! These fixes appear to have worked, and I'm looking
forward to building my databases. Thanks again!
Deb
__________________________________
Hi Lossm15,
You will receive the LoadLibrary error if you do not include double-quotes
around the entire filename. Sorry that I didn't warn you to include the
double-quotes. For example, on my PC, I found (3) copies of the DAO360.dll
file with the following full filenames:
C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll
C:\WINNT\ServicePackFiles\i386\dao360.dll and
C:\WINNT\system32\dllcache\dao360.dll
If I issue the following command from the Start > Run dialog, I will receive
the LoadLibrary error message:
regsvr32 C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll
However, the following command will be successful:
regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll"
Oh what a difference a set of quotes can make! Try searching for each .dll
file that you need to re-register. When the search is complete, reduce the
size of the find files dialog enough so that you can display both the search
results and the Start > Run dialog on the same screen. Enter the command:
Regsvr32 into the Start > Run dialog. Then use the drag-and-drop technique
to drag the dao360.dll file to the Start > Run dialog. When you drop it in
place, the complete path including the double-quote marks should be filled in
automatically.
As for which copy of the files to register, I would avoid using anything
from a folder that indicates ServicePackFiles or dllcache. I think, in
general, that your best bet is to right click on the files, and then
left-click on the Properties item in the short-cut menu. Pick the copy that
has the latest version number indicated.
Good Luck, and please let me know how it goes.
Oh, and you're very welcome!
Tom
__________________________________
Tom,
Hi! Thank you for your quick response. I started with #4, and got the error
message: "Loadlibrary failed... the specified module could not be found".
Tried the same with step #5, with the same results.
Did a Start/Search/for files on my computer: acwzlib.mde, accwiz.dll, and
dao360.dll. All were found on my computer - but I don't know "where" (several
copies, in several files, none appearing to relate to the Access issue) or
what to do with them at this point to make things work.
You are my lifeline! What do I do next? In the meantime, I am reading thru
the articles as recommended at the bottome of your suggestion (833220, and
267279). Did I mention I did try the suggestions as recommended in article
242218 (yesterday, before the original post)?
THANK YOU!
THANK YOU!
__________________________________
Okay, here's a few more things to try:
If you were missing acwztool.mde, then you might be missing Acwzlib.mde
and/or Accwiz.dll as well.
Try registering the Accwiz.dll and/or DAO360.dll file(s). Use the
directions in steps 4 & 5 of this article to re-register these .DLL files:
http://support.microsoft.com/?id=303769
Tom
__________________________________
I am able to run the "create a new database" wizard when I first open Access,
but if I am working in a database and want to create a new form (or table or
query, etc.) using the wizard "create new... using wizard", I get no response
from my computer. It has been several years since I've actually used Access,
and I'm hoping the wizards will help me. I am running Access 2000 and
Microsoft Windows 2000 (5.00.2195, service pack 4).
I have browsed the recent posts, and tried all the recommended fixes I
thought applicable. Am stumped. I have tried the "repair"; I have tried
uninstalling and re-installing; I have tried the fixes as found in
http://support.microsoft.com/?id=242218. (Here I discovered I needed to copy
a missing file, acwztool.mde, and did so - thanks!)
Any assistance will be greatly appreciated!