Re: Cannot open my own Databases

From: Kassie (Kassie_at_discussions.microsoft.com)
Date: 01/05/05 

Date: Wed, 5 Jan 2005 07:07:05 -0800

Sorry about that. The actual message is a Visual Basic one, stating that an
error occured while loading 'Form_frm{form name}. It then asks whether you
want to continue or not. It does not help to click on "No". Should you then
try to open a form, the following MS Access error message appears: {The
expression "On Open" you entered as the event property setting produced the
following error: Invalid procedure call or argument} It then goes on to
explain that the expression may not result in the name of a macro, the name
of a user defined function, or [Event Procedure] and that there may have been
an error in evaluating the event, function or macro.

Kassie

"'69 Camaro" wrote:

> 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
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
>