Cannot open my own Databases

[Guest]

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

 

['69 Camaro]

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

 

[Guest]

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]

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

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

 

[Guest]

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]

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.


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?



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.
on
the and
the

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


on
the and
the XP,
not get
into not
have

 

[Guest]

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

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

 

['69 Camaro]

Hi, Kassie.

The code is not compiled and the procedure where this error is occurring has
no error handler. Open the VB Editor by pressing <ALT><F11> and select the
Debug menu -> Compile <DatabaseName> to compile the code. What is your
compile error and which line of code is highlighted?

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

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

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

 

[Guest]

Hi

Let me start off by saying a BIG thank you for all your assistance so far.
I tried your advice, and only got an "Invalid procedure call or argument".
There is no code whatsoever! However, when I ran this DB on the other PC, it
runs, and has code associated with each form. I investigated further, and
discovered that the moment I exit this DB(on the other PC), and go back in,
it no longer works. It would seem that it saves everything but the code! I
will redo this excercise on my home Pc tonight, and see whether that will
solve the problem.

Hi, Kassie.

The code is not compiled and the procedure where this error is occurring has
no error handler. Open the VB Editor by pressing <ALT><F11> and select the
Debug menu -> Compile <DatabaseName> to compile the code. What is your
compile error and which line of code is highlighted?

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

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

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

 

[Bilk Whitey]

when I ran this DB on the other PC, it
runs, and has code associated with each form. I investigated further,
and discovered that the moment I exit this DB(on the other PC), and go
back in, it no longer works. It would seem that it saves everything
but the code! I will redo this excercise on my home Pc tonight, and
see whether that will solve the problem.

Sounds like a corruption of some sort - have you tried compact/repair or
importing all of the objects into a new mdb?

Regards,
Keith.
www.keithwilby.com

 

[Guest]

This is what happens when I Import the original database into a new one!. I
cannot open the original database on a specific PC, as I allegedly do not
have permission to do so.

To overcome this ipermission ssue, I have already formatted my PC, and
started from scratch. The next step was to try and import into a new DB.