Re: Cannot open my own Databases

From: '69 Camaro (ForwardZERO_SPAM.To.69Camaro_at_Spameater.orgZERO_SPAM)
Date: 01/05/05 

Date: Wed, 5 Jan 2005 06:24:34 -0800

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/details.aspx?FamilyID=1a8ce553-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/details.aspx?familyid=8f0a8df6-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.)

"Kassie" <Kassie@discussions.microsoft.com> wrote in message
news:A95C3449-C259-4B72-A3F9-717CA0FD88FF@microsoft.com...
> 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
> "'69 Camaro" wrote:
>
> > 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.)
> >
> >
> > "Kassie" <Kassie@discussions.microsoft.com> wrote in message
> > news:F383573F-DBC9-4145-9534-300F64613AAC@microsoft.com...
> > > 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
> > >
> > > "'69 Camaro" wrote:
> > >
> > > > 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.)
> > > >
> > > >
> > > > "Kassie" <Kassie@discussions.microsoft.com> wrote in message
> > > > news:B93AD135-01C2-4C7D-975F-6DCBB7511F26@microsoft.com...
> > > > > 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
> > > >
> > > >
> > > >
> >
> >
> >