Hi, Kassie.
Error messages state that an error has occured while loading (all .frm
files)
Access does not load .frm files.
Perhaps I can guess what you see. Your switchboard form is designated as
your startup form, so when Access launches the application and tries to open
this form, you see an error message with "Microsoft Visual Basic" in the
title bar and you read the message "Compile error: Error in loading DLL"
and then a line of code in the switchboard form module is highlighted in the
VB Editor. Perhaps this is the line of code that's highlighted:
Set con = Application.CurrentProject.Connection
If this is the case, then make sure that you have the following service
packs installed on your computer: MS Office XP SP-2 or higher, MS Jet 4.0
SP-8 or higher, and MDAC 2.8 or higher. If you don't, then make sure that
you (or someone with the authorization) logs into the computer as the
Windows Administrator and loads each of these service packs. If you need
the service packs, then please see the following Web pages:
See this Web page for MS Office XP SP-2:
http://www.microsoft.com/downloads/...53-ab76-4a63-99da-b4ed914c1514&displaylang=en
See this Web page for the latest service pack for Jet 4.0:
http://support.microsoft.com/?id=239114
See this Web page for the latest MDAC downloads and patches available:
http://msdn.microsoft.com/data/downloads/updates/default.aspx#MDACDownloads
If you need to check the files for the current MDAC version on your
computer, then please see this Web page for the MDAC checker:
http://www.microsoft.com/downloads/...f6-4a21-4b43-bf53-14332ef092c9&displaylang=en
Once each of these service packs is loaded, then while still logged in as
the Windows Administrator, ensure that the DAO and MSADO libraries are
properly registered. To do so, click the Windows Start button, and then
click Run. If your DAO and MSADO libraries are installed in the default
directories (otherwise, just replace the path with your own), then use the
following command for the DAO library (this is all one line):
Regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.DLL"
Use the following command for the MSADO library (this is all one line):
Regsvr32 "C:\Program Files\Common Files\system\ado\Msado15.dll"
If I have guessed correctly about the error message you see, then this will
fix some of the problems, but please post back anyway with whatever errors
still remain.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
I only have the one mdw file on my PC. I have joined this group on
several
occasions, to no avail.
In an attempt to resolve the issue, I have also formatted my HDD and
started
from scratch.
It did not help.
Error messages state that an error has occured while loading (all .frm
files)
This includes the switchboard form. While being prompted to continue or
not, Access does not respond to a "No" answer. I had to answer "Yes" on
each
form. Once in the program, I cannot open or edit any form, as it does not
accept any "Save" click. I can however see my forms in design mode, and
even
open them from there. While I have an "Exit" button on these forms,
clicking
it results in an error message that no macro is associated with the
button.
The relevant macro is available under the "Macro" tab, however.
I am beginning to think that VB for Applications is the problem here. I
say
this because I have now tried this file on another Win 2K PC, running
Office
2K, as well as a PC running Win XP Pro and Office XP Pro, where it works
fine. I even copied the [system.mdw] file from the Win 2K PC onto mine,
and
not even that helped. I have also deleted the .mdw file.
Our network consists of only 6 PC's, without a dedicated server, so no
chance of the .mdw sitting on another PC.
Kassie
:
Hi, Kassie.
none of my databases
were supposed to be secured.
If an attempt to open an Access database results in the error message,
"You
do not have permission to open this database. Please see your
Administrator
...." then the database has been secured, and the Access user you are
currently logged in as does not have "Open/Run Database" permissions.
Could
anyone else have used your computer to secure these databases without
your
knowledge?
I have no idea what workgroup was previously used
<SNIP>
I therefore also do not have any info about
such a previous workgroup.
Use Windows 2000's search feature to locate every *.MDW file on the
computer. These are the workgroup information files that one selects to
"join the workgroup" by using the Workgroup Administrator application.
Join
one of them and attempt to open each of the Access databases. If the
database opens _without_ the error message, "You do not have permission
to
open this database" then you may have found the correct workgroup for
that
database. (I write "may" because it may be an earlier version of the
final
workgroup information file that was used to secure the database.)
Repeat
the joining of each workgroup and try to open each database until you
determine which database belongs to which workgroup. If this computer
is on
a network, it's possible that the correct workgroup information file
resides
on a network server, so you'll have more work to do if none of the
workgroup
information files on your current computer is the right one.
I created a new database (on
another PC), and imported my data into the new one. This worked fine
on
the
other PC. On copying the file onto my PC, I got a string of errors,
and
the
program does not work
Please let us know what error messages you received.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Tks, BUT
I have no idea what workgroup was previously used, as none of my
databases
were supposed to be secured. I therefore also do not have any info
about
such a previous workgroup. I can run these databases on my home PC,
which
runs on Windows XP Pro and Office XP Pro. I created a new database
(on
another PC), and imported my data into the new one. This worked fine
on
the
other PC. On copying the file onto my PC, I got a string of errors,
and
the
program does not work
:
Hi, Kassie.
Access XP is currently joined to the default workgroup for Access
XP,
not
the workgroup that was used to secure the Access 2K databases. Use
the
Workgroup Administrator to join the secure Access 2K workgroup.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a
message
will be forwarded to me.)
I developed a number of databases on a PC running Windows 98 and
Access
2000.
I was not the first user on this PC. I have subsequently
upgraded to
Windows 2000 and to Office XP Professional. Since then I cannot
get
into
any
of these databases. I get an error code 3303, stating that I do
not
have
the
necessary permission to access this database