|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Has anyone ver gotten this message when trying to open an Access database:
You do not have the necessary permissions to use the <name> object. Have your
system administrator or the person who created this object establish the
appropriate permissions for you. (Error 3033). Please help. This is out of
the blue, and I can't seem to fix it.
|
|
That message indicates that you are not using the correct workgroup file,
while trying to open the database.
Is this database secured? Do you launch it via a desktop shortcut? What is
the target of that shortcut, if so.
You say it started 'out of the blue', but databases do not implement
security by themselves.
Open Access and go to Tools, Security, Workgroup Administrator and it will
tell you the workgroup file you are joined to by default. Post back with
that path. Also do a search on your computer for *.mdw and post back with
those paths.
--
Joan Wild
Microsoft Access MVP
Elis1974 wrote:
[Quoted Text] > Has anyone ver gotten this message when trying to open an Access
> database: You do not have the necessary permissions to use the <name>
> object. Have your system administrator or the person who created this
> object establish the appropriate permissions for you. (Error 3033).
> Please help. This is out of the blue, and I can't seem to fix it.
|
|
I was under the impression that the database was secure. I set up the user
names and passwords myself several years ago, and have never gotten this
error message before. This database is on an internal network, where it is
based at one main computer, and then the others can access it by going
through a shortcut on their desktop which is connected to the main computer.
When I open the Access program on my computer, which is not the main
computer, this is the workgroup path I get: C:\Documents and
Settings\eallerellie\Application Data\Microsoft\Access\System.mdw. I tried
to check the workgroup administrator on the main computer and I don't even
have that option. The workgroup administrator does not come up under tools
and security. On my computer, when I search for *.mdw I get the same
workgroup path as above, listed for "system". But when I search the internal
network I get the the following path: M:\RPCaccess, which is the name of the
folder that the database is in on the main computer. As explained above, we
did launch the database from a shortcut, and the target is
"\\CALLROOM\RPC\RPCaccess\RPC Database10.28.05.mdb". I hope some of this
makes sense to you, cause I'm completely confused. I am a nurse, not a
computer person. I just took a few classes and developed this database, and
obviously have no idea what I'm doing:) Any help would be appreciated.
Thanks, Elisabeth
"Joan Wild" wrote:
[Quoted Text] > That message indicates that you are not using the correct workgroup file,
> while trying to open the database.
>
> Is this database secured? Do you launch it via a desktop shortcut? What is
> the target of that shortcut, if so.
> You say it started 'out of the blue', but databases do not implement
> security by themselves.
>
> Open Access and go to Tools, Security, Workgroup Administrator and it will
> tell you the workgroup file you are joined to by default. Post back with
> that path. Also do a search on your computer for *.mdw and post back with
> those paths.
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Elis1974 wrote:
> > Has anyone ver gotten this message when trying to open an Access
> > database: You do not have the necessary permissions to use the <name>
> > object. Have your system administrator or the person who created this
> > object establish the appropriate permissions for you. (Error 3033).
> > Please help. This is out of the blue, and I can't seem to fix it.
>
>
>
|
|
Elis1974 wrote:
[Quoted Text] > I was under the impression that the database was secure. I set up
> the user names and passwords myself several years ago, and have never
> gotten this error message before.
OK, that establishes that you are not using the correct workgroup file.
That is why you are getting the error.
This database is on an internal
> network, where it is based at one main computer, and then the others
> can access it by going through a shortcut on their desktop which is
> connected to the main computer. When I open the Access program on my
> computer, which is not the main computer, this is the workgroup path
> I get: C:\Documents and Settings\eallerellie\Application
> Data\Microsoft\Access\System.mdw.
OK, that suggests to me that you are joined by default to the standard
system.mdw that ships with Access.
I tried to check the workgroup
> administrator on the main computer and I don't even have that option.
On the main computer, Access is likely an older version (but the default
workgroup on that machine doesn't matter anyway).
> The workgroup administrator does not come up under tools and
> security. On my computer, when I search for *.mdw I get the same
> workgroup path as above, listed for "system". But when I search the
> internal network I get the the following path: M:\RPCaccess, which is
> the name of the folder that the database is in on the main computer.
> As explained above, we did launch the database from a shortcut, and
> the target is "\\CALLROOM\RPC\RPCaccess\RPC Database10.28.05.mdb". I
> hope some of this makes sense to you, cause I'm completely confused.
That target assumes that you are joined by default to the workgroup file in
M:\RPCaccess and you're not.
You have two choices (the second one being preferred):
Go back into the workgroup administrator on each machine, click on Join, and
browse to the mdw file in M:\RPCaccess.
Or
Modify the shortcut...
"path to msaccess.exe" "\\CALLROOM\RPC\RPCaccess\RPC Database10.28.05.mdb"
/wrkgrp "\\CALLROOM\RPC\RPCaccess\something.mdw"
That is all on one line. You need to check the path to msaccess.exe on your
local machine and substitute accordingly. And also the name of the mdw.
In Access, you are always joined by default to some mdw file. It is used in
all Access sessions. When you secure a mdb, you create a new workgroup
file. Since you can only be joined by default to one workgroup at a time,
you can create a shortcut like the one above to over-ride the default, for
that session.
Normally you don't want to make your secure mdw the default one to use,
because you may have other databases that are not secure, and you don't want
to login for those. Hope that explains it.
--
Joan Wild
Microsoft Access MVP
|
|
I have the same problem when I replaced the upgraded PC for the users. So I
just join the workgroup.mdw then all access asking user ID and password. I
don't know how to fix it ---separate only one file using user ID and password
, all other MS access files don't need user ID and PW. Please help.
"Joan Wild" wrote:
[Quoted Text] > Elis1974 wrote:
> > I was under the impression that the database was secure. I set up
> > the user names and passwords myself several years ago, and have never
> > gotten this error message before.
>
> OK, that establishes that you are not using the correct workgroup file.
> That is why you are getting the error.
>
> This database is on an internal
> > network, where it is based at one main computer, and then the others
> > can access it by going through a shortcut on their desktop which is
> > connected to the main computer. When I open the Access program on my
> > computer, which is not the main computer, this is the workgroup path
> > I get: C:\Documents and Settings\eallerellie\Application
> > Data\Microsoft\Access\System.mdw.
>
> OK, that suggests to me that you are joined by default to the standard
> system.mdw that ships with Access.
>
> I tried to check the workgroup
> > administrator on the main computer and I don't even have that option.
>
> On the main computer, Access is likely an older version (but the default
> workgroup on that machine doesn't matter anyway).
>
> > The workgroup administrator does not come up under tools and
> > security. On my computer, when I search for *.mdw I get the same
> > workgroup path as above, listed for "system". But when I search the
> > internal network I get the the following path: M:\RPCaccess, which is
> > the name of the folder that the database is in on the main computer.
> > As explained above, we did launch the database from a shortcut, and
> > the target is "\\CALLROOM\RPC\RPCaccess\RPC Database10.28.05.mdb". I
> > hope some of this makes sense to you, cause I'm completely confused.
>
> That target assumes that you are joined by default to the workgroup file in
> M:\RPCaccess and you're not.
>
> You have two choices (the second one being preferred):
> Go back into the workgroup administrator on each machine, click on Join, and
> browse to the mdw file in M:\RPCaccess.
> Or
> Modify the shortcut...
> "path to msaccess.exe" "\\CALLROOM\RPC\RPCaccess\RPC Database10.28.05.mdb"
> /wrkgrp "\\CALLROOM\RPC\RPCaccess\something.mdw"
>
> That is all on one line. You need to check the path to msaccess.exe on your
> local machine and substitute accordingly. And also the name of the mdw.
>
> In Access, you are always joined by default to some mdw file. It is used in
> all Access sessions. When you secure a mdb, you create a new workgroup
> file. Since you can only be joined by default to one workgroup at a time,
> you can create a shortcut like the one above to over-ride the default, for
> that session.
>
> Normally you don't want to make your secure mdw the default one to use,
> because you may have other databases that are not secure, and you don't want
> to login for those. Hope that explains it.
>
> --
> Joan Wild
> Microsoft Access MVP
>
>
>
|
|
ginger8990 wrote:
[Quoted Text] > I have the same problem when I replaced the upgraded PC for the
> users. So I just join the workgroup.mdw then all access asking user
> ID and password. I don't know how to fix it ---separate only one file
> using user ID and password , all other MS access files don't need
> user ID and PW. Please help.
You need to use the workgroup administrator and join the standard system.mdw
that ships with Access. Then create a desktop shortcut to launch the secure
mdb. The target would look like:
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"
--
Joan Wild
Microsoft Access MVP
|
|
Well, I'm glad that you can identify what's going on. That makes me feel
better. And I greatly appreciate your instructions, however, I have a few
more questions before I start this "fixit job". Please see below questions...
1. How do I modify a shortcut?
2. In reference to this "You need to check the path to msaccess.exe on your
[Quoted Text] > local machine and substitute accordingly. And also the name of the mdw."- how do I do this, and which machine is considered the "local" machine. Is it tha main computer?
I know I probably seem like a moron, and I guess with this I am. Thanks for
you help!
"Joan Wild" wrote:
> Elis1974 wrote:
> > I was under the impression that the database was secure. I set up
> > the user names and passwords myself several years ago, and have never
> > gotten this error message before.
>
> OK, that establishes that you are not using the correct workgroup file.
> That is why you are getting the error.
>
> This database is on an internal
> > network, where it is based at one main computer, and then the others
> > can access it by going through a shortcut on their desktop which is
> > connected to the main computer. When I open the Access program on my
> > computer, which is not the main computer, this is the workgroup path
> > I get: C:\Documents and Settings\eallerellie\Application
> > Data\Microsoft\Access\System.mdw.
>
> OK, that suggests to me that you are joined by default to the standard
> system.mdw that ships with Access.
>
> I tried to check the workgroup
> > administrator on the main computer and I don't even have that option.
>
> On the main computer, Access is likely an older version (but the default
> workgroup on that machine doesn't matter anyway).
>
> > The workgroup administrator does not come up under tools and
> > security. On my computer, when I search for *.mdw I get the same
> > workgroup path as above, listed for "system". But when I search the
> > internal network I get the the following path: M:\RPCaccess, which is
> > the name of the folder that the database is in on the main computer.
> > As explained above, we did launch the database from a shortcut, and
> > the target is "\\CALLROOM\RPC\RPCaccess\RPC Database10.28.05.mdb". I
> > hope some of this makes sense to you, cause I'm completely confused.
>
> That target assumes that you are joined by default to the workgroup file in
> M:\RPCaccess and you're not.
>
> You have two choices (the second one being preferred):
> Go back into the workgroup administrator on each machine, click on Join, and
> browse to the mdw file in M:\RPCaccess.
> Or
> Modify the shortcut...
> "path to msaccess.exe" "\\CALLROOM\RPC\RPCaccess\RPC Database10.28.05.mdb"
> /wrkgrp "\\CALLROOM\RPC\RPCaccess\something.mdw"
>
> That is all on one line. You need to check the path to msaccess.exe on your
> local machine and substitute accordingly. And also the name of the mdw.
>
> In Access, you are always joined by default to some mdw file. It is used in
> all Access sessions. When you secure a mdb, you create a new workgroup
> file. Since you can only be joined by default to one workgroup at a time,
> you can create a shortcut like the one above to over-ride the default, for
> that session.
>
> Normally you don't want to make your secure mdw the default one to use,
> because you may have other databases that are not secure, and you don't want
> to login for those. Hope that explains it.
>
> --
> Joan Wild
> Microsoft Access MVP
>
>
>
|
|
Elis1974 wrote:
[Quoted Text] > Well, I'm glad that you can identify what's going on. That makes me
> feel better. And I greatly appreciate your instructions, however, I
> have a few more questions before I start this "fixit job". Please
> see below questions...
> 1. How do I modify a shortcut?
Right-click the shortcut, and choose Properties. It'll open to the shortcut
tab and the Target line will be highlighted. Edit that line.
> 2. In reference to this "You need to check the path to msaccess.exe
> on your
>> local machine and substitute accordingly. And also the name of the
>> mdw."- how do I do this, and which machine is considered the "local"
>> machine. Is it tha main computer?
'local machine' means your computer (not the main one). If you go to Start,
Search for file and folders, you can type msaccess.exe in the textbox for
'what to search for' - that will find the file and show you the path; it's
likely something like
c:\Program Files\Microsoft Office\Office\...
As for the name of the mdw, you didn't specify in your previous message,
what the name of the file is, just the folder. So look in
CALLROOM\RPC\RPCaccess\ or your M:\RPCaccess folder to find the name of the
file.
--
Joan Wild
Microsoft Access MVP
|
|
O.K. Hopefully this will be my last few questions:) In the shortcut, where I
put in "path to msaccess.exe" "\\CALLROOM\RPC\RPCaccess\RPC
Database10.28.05.mdb"
/wrkgrp "\\CALLROOM\RPC\RPCaccess\something.mdw", I have 2 questions:
1. Do I actually put "path to msaccess.exe", or do I just start with
"\\CALLROOM\RPC...
2. What is the "something" at the end of the path?
Thansk you so much for all your help!! If I can tell any of your superiors
how much I appreciate you, I'd like to.
"Joan Wild" wrote:
[Quoted Text] > Elis1974 wrote:
> > Well, I'm glad that you can identify what's going on. That makes me
> > feel better. And I greatly appreciate your instructions, however, I
> > have a few more questions before I start this "fixit job". Please
> > see below questions...
> > 1. How do I modify a shortcut?
>
> Right-click the shortcut, and choose Properties. It'll open to the shortcut
> tab and the Target line will be highlighted. Edit that line.
>
> > 2. In reference to this "You need to check the path to msaccess.exe
> > on your
> >> local machine and substitute accordingly. And also the name of the
> >> mdw."- how do I do this, and which machine is considered the "local"
> >> machine. Is it tha main computer?
>
> 'local machine' means your computer (not the main one). If you go to Start,
> Search for file and folders, you can type msaccess.exe in the textbox for
> 'what to search for' - that will find the file and show you the path; it's
> likely something like
> c:\Program Files\Microsoft Office\Office\...
>
> As for the name of the mdw, you didn't specify in your previous message,
> what the name of the file is, just the folder. So look in
> CALLROOM\RPC\RPCaccess\ or your M:\RPCaccess folder to find the name of the
> file.
>
> --
> Joan Wild
> Microsoft Access MVP
>
>
>
|
|
Where it says "path to msaccess.exe", put the path to wherever msaccess.exe
is located on your machine. For example, on my machine that's C:\Program
Files\Microsoft Office.11\OFFICE11\msaccess.exe. Since there are blanks in
that path, it's necessary to enclose it in quotes:
"C:\Program Files\Microsoft Office.11\OFFICE11\msaccess.exe"
The "\\CALLROOM\RPC\RPCaccess\something.mdw" is whatever your workgroup file
(the mdw associated with your application) is actually named.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Elis1974" <Elis1974[ at ]discussions.microsoft.com> wrote in message
news:6DF922DF-60EA-48A1-91ED-52E63DC55D82[ at ]microsoft.com...
[Quoted Text] > O.K. Hopefully this will be my last few questions:) In the shortcut,
> where I
> put in "path to msaccess.exe" "\\CALLROOM\RPC\RPCaccess\RPC
> Database10.28.05.mdb"
> /wrkgrp "\\CALLROOM\RPC\RPCaccess\something.mdw", I have 2 questions:
> 1. Do I actually put "path to msaccess.exe", or do I just start with
> "\\CALLROOM\RPC...
> 2. What is the "something" at the end of the path?
>
> Thansk you so much for all your help!! If I can tell any of your superiors
> how much I appreciate you, I'd like to.
>
> "Joan Wild" wrote:
>
>> Elis1974 wrote:
>> > Well, I'm glad that you can identify what's going on. That makes me
>> > feel better. And I greatly appreciate your instructions, however, I
>> > have a few more questions before I start this "fixit job". Please
>> > see below questions...
>> > 1. How do I modify a shortcut?
>>
>> Right-click the shortcut, and choose Properties. It'll open to the
>> shortcut
>> tab and the Target line will be highlighted. Edit that line.
>>
>> > 2. In reference to this "You need to check the path to msaccess.exe
>> > on your
>> >> local machine and substitute accordingly. And also the name of the
>> >> mdw."- how do I do this, and which machine is considered the "local"
>> >> machine. Is it tha main computer?
>>
>> 'local machine' means your computer (not the main one). If you go to
>> Start,
>> Search for file and folders, you can type msaccess.exe in the textbox for
>> 'what to search for' - that will find the file and show you the path;
>> it's
>> likely something like
>> c:\Program Files\Microsoft Office\Office\...
>>
>> As for the name of the mdw, you didn't specify in your previous message,
>> what the name of the file is, just the folder. So look in
>> CALLROOM\RPC\RPCaccess\ or your M:\RPCaccess folder to find the name of
>> the
>> file.
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>>
>>
|
|
So you're saying that I should go the the shortcut on my desktop and right
click on properties and then under the shortcut tab, where it says Target: I
should type in
"\\CALLROOM\RPC\RPCaccess\RPCDatabase10.28.05.mdb" /wrkgrp
"\\CALLROOM\RPC\RPCaccess\something.mdw", but instead of putting "something"
I should put RPCDatabase10.28.05, which is the name of the database I am
trying to gain access to?
I'm feeling very confused right now. The simpliest way you can explain this
to me would be most helpful. Preterd you're talking to a 5 year old:)
"Douglas J. Steele" wrote:
[Quoted Text] > Where it says "path to msaccess.exe", put the path to wherever msaccess.exe > is located on your machine. For example, on my machine that's C:\Program > Files\Microsoft Office.11\OFFICE11\msaccess.exe. Since there are blanks in > that path, it's necessary to enclose it in quotes: > > "C:\Program Files\Microsoft Office.11\OFFICE11\msaccess.exe" > > The "\\CALLROOM\RPC\RPCaccess\something.mdw" is whatever your workgroup file > (the mdw associated with your application) is actually named. > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele> (no private e-mails, please) > > > "Elis1974" <Elis1974[ at ]discussions.microsoft.com> wrote in message > news:6DF922DF-60EA-48A1-91ED-52E63DC55D82[ at ]microsoft.com... > > O.K. Hopefully this will be my last few questions:) In the shortcut, > > where I > > put in "path to msaccess.exe" "\\CALLROOM\RPC\RPCaccess\RPC > > Database10.28.05.mdb" > > /wrkgrp "\\CALLROOM\RPC\RPCaccess\something.mdw", I have 2 questions: > > 1. Do I actually put "path to msaccess.exe", or do I just start with > > "\\CALLROOM\RPC... > > 2. What is the "something" at the end of the path? > > > > Thansk you so much for all your help!! If I can tell any of your superiors > > how much I appreciate you, I'd like to. > > > > "Joan Wild" wrote: > > > >> Elis1974 wrote: > >> > Well, I'm glad that you can identify what's going on. That makes me > >> > feel better. And I greatly appreciate your instructions, however, I > >> > have a few more questions before I start this "fixit job". Please > >> > see below questions... > >> > 1. How do I modify a shortcut? > >> > >> Right-click the shortcut, and choose Properties. It'll open to the > >> shortcut > >> tab and the Target line will be highlighted. Edit that line. > >> > >> > 2. In reference to this "You need to check the path to msaccess.exe > >> > on your > >> >> local machine and substitute accordingly. And also the name of the > >> >> mdw."- how do I do this, and which machine is considered the "local" > >> >> machine. Is it tha main computer? > >> > >> 'local machine' means your computer (not the main one). If you go to > >> Start, > >> Search for file and folders, you can type msaccess.exe in the textbox for > >> 'what to search for' - that will find the file and show you the path; > >> it's > >> likely something like > >> c:\Program Files\Microsoft Office\Office\... > >> > >> As for the name of the mdw, you didn't specify in your previous message, > >> what the name of the file is, just the folder. So look in > >> CALLROOM\RPC\RPCaccess\ or your M:\RPCaccess folder to find the name of > >> the > >> file. > >> > >> -- > >> Joan Wild > >> Microsoft Access MVP > >> > >> > >> > > > |
|
Elis1974 wrote:
[Quoted Text] > So you're saying that I should go the the shortcut on my desktop and
> right click on properties and then under the shortcut tab, where it
> says Target: I should type in
> "\\CALLROOM\RPC\RPCaccess\RPCDatabase10.28.05.mdb" /wrkgrp
> "\\CALLROOM\RPC\RPCaccess\something.mdw", but instead of putting
> "something" I should put RPCDatabase10.28.05, which is the name of
> the database I am trying to gain access to?
No. Almost, but not quite. In an earlier post, you said when you searched
for *.mdw on the network, it located a mdw file in the
\\CALLROOM\RPC\RPCaccess folder - what is the name of the mdw file it found
in that folder?
Also, when you search your local computer for msaccess.exe, what is the path
that it finds for this file?
--
Joan Wild
Microsoft Access MVP
|
|
You must include the the msaccess.exe part. Switches such as /wrkgrp won't
work otherwise
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Elis1974" <Elis1974[ at ]discussions.microsoft.com> wrote in message
news:7E8ECE46-8627-421E-9DCA-A5D8BA331B7D[ at ]microsoft.com...
[Quoted Text] > So you're saying that I should go the the shortcut on my desktop and right > click on properties and then under the shortcut tab, where it says Target: > I > should type in > "\\CALLROOM\RPC\RPCaccess\RPCDatabase10.28.05.mdb" /wrkgrp > "\\CALLROOM\RPC\RPCaccess\something.mdw", but instead of putting > "something" > I should put RPCDatabase10.28.05, which is the name of the database I am > trying to gain access to? > > I'm feeling very confused right now. The simpliest way you can explain > this > to me would be most helpful. Preterd you're talking to a 5 year old:) > "Douglas J. Steele" wrote: > >> Where it says "path to msaccess.exe", put the path to wherever >> msaccess.exe >> is located on your machine. For example, on my machine that's C:\Program >> Files\Microsoft Office.11\OFFICE11\msaccess.exe. Since there are blanks >> in >> that path, it's necessary to enclose it in quotes: >> >> "C:\Program Files\Microsoft Office.11\OFFICE11\msaccess.exe" >> >> The "\\CALLROOM\RPC\RPCaccess\something.mdw" is whatever your workgroup >> file >> (the mdw associated with your application) is actually named. >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele>> (no private e-mails, please) >> >> >> "Elis1974" <Elis1974[ at ]discussions.microsoft.com> wrote in message >> news:6DF922DF-60EA-48A1-91ED-52E63DC55D82[ at ]microsoft.com... >> > O.K. Hopefully this will be my last few questions:) In the shortcut, >> > where I >> > put in "path to msaccess.exe" "\\CALLROOM\RPC\RPCaccess\RPC >> > Database10.28.05.mdb" >> > /wrkgrp "\\CALLROOM\RPC\RPCaccess\something.mdw", I have 2 questions: >> > 1. Do I actually put "path to msaccess.exe", or do I just start with >> > "\\CALLROOM\RPC... >> > 2. What is the "something" at the end of the path? >> > >> > Thansk you so much for all your help!! If I can tell any of your >> > superiors >> > how much I appreciate you, I'd like to. >> > >> > "Joan Wild" wrote: >> > >> >> Elis1974 wrote: >> >> > Well, I'm glad that you can identify what's going on. That makes me >> >> > feel better. And I greatly appreciate your instructions, however, I >> >> > have a few more questions before I start this "fixit job". Please >> >> > see below questions... >> >> > 1. How do I modify a shortcut? >> >> >> >> Right-click the shortcut, and choose Properties. It'll open to the >> >> shortcut >> >> tab and the Target line will be highlighted. Edit that line. >> >> >> >> > 2. In reference to this "You need to check the path to msaccess.exe >> >> > on your >> >> >> local machine and substitute accordingly. And also the name of the >> >> >> mdw."- how do I do this, and which machine is considered the >> >> >> "local" >> >> >> machine. Is it tha main computer? >> >> >> >> 'local machine' means your computer (not the main one). If you go to >> >> Start, >> >> Search for file and folders, you can type msaccess.exe in the textbox >> >> for >> >> 'what to search for' - that will find the file and show you the path; >> >> it's >> >> likely something like >> >> c:\Program Files\Microsoft Office\Office\... >> >> >> >> As for the name of the mdw, you didn't specify in your previous >> >> message, >> >> what the name of the file is, just the folder. So look in >> >> CALLROOM\RPC\RPCaccess\ or your M:\RPCaccess folder to find the name >> >> of >> >> the >> >> file. >> >> >> >> -- >> >> Joan Wild >> >> Microsoft Access MVP >> >> >> >> >> >> >> >> >>
|
|
1. When I search for *.mdw on the network, (called Callroom), I get a file
called RPC located in the M:\RPCaccess folder.
2. When I search for msaccess.exe on my local hard drive (C) I find nothing.
I'm so confused at this point!!!
"Joan Wild" wrote:
[Quoted Text] > Elis1974 wrote:
> > So you're saying that I should go the the shortcut on my desktop and
> > right click on properties and then under the shortcut tab, where it
> > says Target: I should type in
> > "\\CALLROOM\RPC\RPCaccess\RPCDatabase10.28.05.mdb" /wrkgrp
> > "\\CALLROOM\RPC\RPCaccess\something.mdw", but instead of putting
> > "something" I should put RPCDatabase10.28.05, which is the name of
> > the database I am trying to gain access to?
>
> No. Almost, but not quite. In an earlier post, you said when you searched
> for *.mdw on the network, it located a mdw file in the
> \\CALLROOM\RPC\RPCaccess folder - what is the name of the mdw file it found
> in that folder?
>
> Also, when you search your local computer for msaccess.exe, what is the path
> that it finds for this file?
>
> --
> Joan Wild
> Microsoft Access MVP
>
>
>
|
|
So the path to your workgroup file is M:\RPCAccess\RPC.mdw, right?
When you search for msaccess.exe, be sure to search all files and folders,
and click on More Advanced Options and check the system folders, and hidden
files and folders, and subfolders. Post back with the path.
--
Joan Wild
Microsoft Access MVP
Elis1974 wrote:
[Quoted Text] > 1. When I search for *.mdw on the network, (called Callroom), I get a
> file called RPC located in the M:\RPCaccess folder.
> 2. When I search for msaccess.exe on my local hard drive (C) I find
> nothing.
>
> I'm so confused at this point!!!
>
> "Joan Wild" wrote:
>
>> Elis1974 wrote:
>>> So you're saying that I should go the the shortcut on my desktop and
>>> right click on properties and then under the shortcut tab, where it
>>> says Target: I should type in
>>> "\\CALLROOM\RPC\RPCaccess\RPCDatabase10.28.05.mdb" /wrkgrp
>>> "\\CALLROOM\RPC\RPCaccess\something.mdw", but instead of putting
>>> "something" I should put RPCDatabase10.28.05, which is the name of
>>> the database I am trying to gain access to?
>>
>> No. Almost, but not quite. In an earlier post, you said when you
>> searched for *.mdw on the network, it located a mdw file in the
>> \\CALLROOM\RPC\RPCaccess folder - what is the name of the mdw file
>> it found in that folder?
>>
>> Also, when you search your local computer for msaccess.exe, what is
>> the path that it finds for this file?
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
|
|
1. The path to the workgroup file for the defunct database is
M:\RPCAccess\RPCDatabase10.25.05.mdw.
2. On my Hard Drive, when I search for msaccess.exe the path I get is
C:\Program Files\Microsoft Office\Office10
"Joan Wild" wrote:
[Quoted Text] > So the path to your workgroup file is M:\RPCAccess\RPC.mdw, right?
>
> When you search for msaccess.exe, be sure to search all files and folders,
> and click on More Advanced Options and check the system folders, and hidden
> files and folders, and subfolders. Post back with the path.
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Elis1974 wrote:
> > 1. When I search for *.mdw on the network, (called Callroom), I get a
> > file called RPC located in the M:\RPCaccess folder.
> > 2. When I search for msaccess.exe on my local hard drive (C) I find
> > nothing.
> >
> > I'm so confused at this point!!!
> >
> > "Joan Wild" wrote:
> >
> >> Elis1974 wrote:
> >>> So you're saying that I should go the the shortcut on my desktop and
> >>> right click on properties and then under the shortcut tab, where it
> >>> says Target: I should type in
> >>> "\\CALLROOM\RPC\RPCaccess\RPCDatabase10.28.05.mdb" /wrkgrp
> >>> "\\CALLROOM\RPC\RPCaccess\something.mdw", but instead of putting
> >>> "something" I should put RPCDatabase10.28.05, which is the name of
> >>> the database I am trying to gain access to?
> >>
> >> No. Almost, but not quite. In an earlier post, you said when you
> >> searched for *.mdw on the network, it located a mdw file in the
> >> \\CALLROOM\RPC\RPCaccess folder - what is the name of the mdw file
> >> it found in that folder?
> >>
> >> Also, when you search your local computer for msaccess.exe, what is
> >> the path that it finds for this file?
> >>
> >> --
> >> Joan Wild
> >> Microsoft Access MVP
>
>
>
|
|
Great, we're almost there.
First you shouldn't name the mdw the same as the mdb - they each need to
create an associated ldb file and they can't if they both have the same
name.
I would change the name of the mdw to RPCDatabase.mdw
Now right-click your desktop shortcut and put the following in the target:
"C:\Program Files\Microsoft Office\Office10\msaccess.exe"
"\\CALLROOM\RPC\RPCaccess\RPCDatabase10.28.05.mdb" /wrkgrp
"\\CALLROOM\RPC\RPCaccess\RPCDatabase.mdw"
You will need to modify everyone's shortcut to say this.
--
Joan Wild
Microsoft Access MVP
Elis1974 wrote:
[Quoted Text] > 1. The path to the workgroup file for the defunct database is
> M:\RPCAccess\RPCDatabase10.25.05.mdw.
>
> 2. On my Hard Drive, when I search for msaccess.exe the path I get is
> C:\Program Files\Microsoft Office\Office10
>
> "Joan Wild" wrote:
>
>> So the path to your workgroup file is M:\RPCAccess\RPC.mdw, right?
>>
>> When you search for msaccess.exe, be sure to search all files and
>> folders, and click on More Advanced Options and check the system
>> folders, and hidden files and folders, and subfolders. Post back
>> with the path.
>>
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>> Elis1974 wrote:
>>> 1. When I search for *.mdw on the network, (called Callroom), I get
>>> a file called RPC located in the M:\RPCaccess folder.
>>> 2. When I search for msaccess.exe on my local hard drive (C) I find
>>> nothing.
>>>
>>> I'm so confused at this point!!!
>>>
>>> "Joan Wild" wrote:
>>>
>>>> Elis1974 wrote:
>>>>> So you're saying that I should go the the shortcut on my desktop
>>>>> and right click on properties and then under the shortcut tab,
>>>>> where it says Target: I should type in
>>>>> "\\CALLROOM\RPC\RPCaccess\RPCDatabase10.28.05.mdb" /wrkgrp
>>>>> "\\CALLROOM\RPC\RPCaccess\something.mdw", but instead of putting
>>>>> "something" I should put RPCDatabase10.28.05, which is the name of
>>>>> the database I am trying to gain access to?
>>>>
>>>> No. Almost, but not quite. In an earlier post, you said when you
>>>> searched for *.mdw on the network, it located a mdw file in the
>>>> \\CALLROOM\RPC\RPCaccess folder - what is the name of the mdw file
>>>> it found in that folder?
>>>>
>>>> Also, when you search your local computer for msaccess.exe, what is
>>>> the path that it finds for this file?
>>>>
>>>> --
>>>> Joan Wild
>>>> Microsoft Access MVP
|
|
O.K. Now I'm not so sure that the path to the workgroup file for the defunct
database is actually M:\RPCAccess\RPCDatabase10.25.05.mdw. I guess I sort of
assumed it was, since that's the path I used to follow to get to it. How can
I be sure? And, then how do I change the name of it?
Ughhhh!! I know you'll be as happy to be finished with this as I will!
"Joan Wild" wrote:
[Quoted Text] > Great, we're almost there.
>
> First you shouldn't name the mdw the same as the mdb - they each need to
> create an associated ldb file and they can't if they both have the same
> name.
>
> I would change the name of the mdw to RPCDatabase.mdw
>
> Now right-click your desktop shortcut and put the following in the target:
>
> "C:\Program Files\Microsoft Office\Office10\msaccess.exe"
> "\\CALLROOM\RPC\RPCaccess\RPCDatabase10.28.05.mdb" /wrkgrp
> "\\CALLROOM\RPC\RPCaccess\RPCDatabase.mdw"
>
> You will need to modify everyone's shortcut to say this.
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Elis1974 wrote:
> > 1. The path to the workgroup file for the defunct database is
> > M:\RPCAccess\RPCDatabase10.25.05.mdw.
> >
> > 2. On my Hard Drive, when I search for msaccess.exe the path I get is
> > C:\Program Files\Microsoft Office\Office10
> >
> > "Joan Wild" wrote:
> >
> >> So the path to your workgroup file is M:\RPCAccess\RPC.mdw, right?
> >>
> >> When you search for msaccess.exe, be sure to search all files and
> >> folders, and click on More Advanced Options and check the system
> >> folders, and hidden files and folders, and subfolders. Post back
> >> with the path.
> >>
> >>
> >> --
> >> Joan Wild
> >> Microsoft Access MVP
> >>
> >> Elis1974 wrote:
> >>> 1. When I search for *.mdw on the network, (called Callroom), I get
> >>> a file called RPC located in the M:\RPCaccess folder.
> >>> 2. When I search for msaccess.exe on my local hard drive (C) I find
> >>> nothing.
> >>>
> >>> I'm so confused at this point!!!
> >>>
> >>> "Joan Wild" wrote:
> >>>
> >>>> Elis1974 wrote:
> >>>>> So you're saying that I should go the the shortcut on my desktop
> >>>>> and right click on properties and then under the shortcut tab,
> >>>>> where it says Target: I should type in
> >>>>> "\\CALLROOM\RPC\RPCaccess\RPCDatabase10.28.05.mdb" /wrkgrp
> >>>>> "\\CALLROOM\RPC\RPCaccess\something.mdw", but instead of putting
> >>>>> "something" I should put RPCDatabase10.28.05, which is the name of
> >>>>> the database I am trying to gain access to?
> >>>>
> >>>> No. Almost, but not quite. In an earlier post, you said when you
> >>>> searched for *.mdw on the network, it located a mdw file in the
> >>>> \\CALLROOM\RPC\RPCaccess folder - what is the name of the mdw file
> >>>> it found in that folder?
> >>>>
> >>>> Also, when you search your local computer for msaccess.exe, what is
> >>>> the path that it finds for this file?
> >>>>
> >>>> --
> >>>> Joan Wild
> >>>> Microsoft Access MVP
>
>
>
|
|
Open My Computer or Windows Explorer and go to the ME:\ drive. Open the
RPCAccess folder. Go to Tools, Folder Options, and then the View tab. In
the Advanced settings list, ensure that 'Hide extensions for known file
types' is unchecked.
Now in that folder what files do you see listed that have a mdw or a mdb
extension?
--
Joan Wild
Microsoft Access MVP
"Elis1974" <Elis1974[ at ]discussions.microsoft.com> wrote in message
news:2FA9DFB7-59CA-4E91-B567-C3DFAC33E8C7[ at ]microsoft.com...
[Quoted Text] > O.K. Now I'm not so sure that the path to the workgroup file for the
> defunct
> database is actually M:\RPCAccess\RPCDatabase10.25.05.mdw. I guess I sort
> of
> assumed it was, since that's the path I used to follow to get to it. How
> can
> I be sure? And, then how do I change the name of it?
>
> Ughhhh!! I know you'll be as happy to be finished with this as I will!
>
> "Joan Wild" wrote:
>
>> Great, we're almost there.
>>
>> First you shouldn't name the mdw the same as the mdb - they each need to
>> create an associated ldb file and they can't if they both have the same
>> name.
>>
>> I would change the name of the mdw to RPCDatabase.mdw
>>
>> Now right-click your desktop shortcut and put the following in the
>> target:
>>
>> "C:\Program Files\Microsoft Office\Office10\msaccess.exe"
>> "\\CALLROOM\RPC\RPCaccess\RPCDatabase10.28.05.mdb" /wrkgrp
>> "\\CALLROOM\RPC\RPCaccess\RPCDatabase.mdw"
>>
>> You will need to modify everyone's shortcut to say this.
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>> Elis1974 wrote:
>> > 1. The path to the workgroup file for the defunct database is
>> > M:\RPCAccess\RPCDatabase10.25.05.mdw.
>> >
>> > 2. On my Hard Drive, when I search for msaccess.exe the path I get is
>> > C:\Program Files\Microsoft Office\Office10
>> >
>> > "Joan Wild" wrote:
>> >
>> >> So the path to your workgroup file is M:\RPCAccess\RPC.mdw, right?
>> >>
>> >> When you search for msaccess.exe, be sure to search all files and
>> >> folders, and click on More Advanced Options and check the system
>> >> folders, and hidden files and folders, and subfolders. Post back
>> >> with the path.
>> >>
>> >>
>> >> --
>> >> Joan Wild
>> >> Microsoft Access MVP
>> >>
>> >> Elis1974 wrote:
>> >>> 1. When I search for *.mdw on the network, (called Callroom), I get
>> >>> a file called RPC located in the M:\RPCaccess folder.
>> >>> 2. When I search for msaccess.exe on my local hard drive (C) I find
>> >>> nothing.
>> >>>
>> >>> I'm so confused at this point!!!
>> >>>
>> >>> "Joan Wild" wrote:
>> >>>
>> >>>> Elis1974 wrote:
>> >>>>> So you're saying that I should go the the shortcut on my desktop
>> >>>>> and right click on properties and then under the shortcut tab,
>> >>>>> where it says Target: I should type in
>> >>>>> "\\CALLROOM\RPC\RPCaccess\RPCDatabase10.28.05.mdb" /wrkgrp
>> >>>>> "\\CALLROOM\RPC\RPCaccess\something.mdw", but instead of putting
>> >>>>> "something" I should put RPCDatabase10.28.05, which is the name of
>> >>>>> the database I am trying to gain access to?
>> >>>>
>> >>>> No. Almost, but not quite. In an earlier post, you said when you
>> >>>> searched for *.mdw on the network, it located a mdw file in the
>> >>>> \\CALLROOM\RPC\RPCaccess folder - what is the name of the mdw file
>> >>>> it found in that folder?
>> >>>>
>> >>>> Also, when you search your local computer for msaccess.exe, what is
>> >>>> the path that it finds for this file?
>> >>>>
>> >>>> --
>> >>>> Joan Wild
>> >>>> Microsoft Access MVP
>>
>>
>>
|
|
That should have been M:\ not ME:\
--
Joan Wild
Microsoft Access MVP
|
|
Great instructions!! Thanks!! In the RPCAccess folder there are many mdb
files, including RPCdatabase 10.28.05(the defunct db), and also several other
RPC database's with other backup dates, and the original "RPC database". The
only mdw is called RPC.MDW.
"Joan Wild" wrote:
[Quoted Text] > That should have been M:\ not ME:\
>
> --
> Joan Wild
> Microsoft Access MVP
>
>
>
|
|
Well now you have me wondering. I thought before that the 10.28.05 in the
filename was a bit strange.
Do you know, or can you find out what these files are? I would think that
you'd use the original RPC database on a day to day basis, and that it
periodically is backed up - and that's what the date is about. However, can
you verify that?
*IF* I'm right then your shortcut target needs to say...
"C:\Program Files\Microsoft Office\Office10\msaccess.exe"
"\\CALLROOM\RPC\RPCaccess\RPCDatabase.mdb" /wrkgrp
"\\CALLROOM\RPC\RPCaccess\RPC.mdw"
--
Joan Wild
Microsoft Access MVP
"Elis1974" <Elis1974[ at ]discussions.microsoft.com> wrote in message
news:BFC7A5DF-CE1D-4B2D-B867-9710DF68BCD9[ at ]microsoft.com...
[Quoted Text] > Great instructions!! Thanks!! In the RPCAccess folder there are many mdb
> files, including RPCdatabase 10.28.05(the defunct db), and also several
> other
> RPC database's with other backup dates, and the original "RPC database".
> The
> only mdw is called RPC.MDW.
>
> "Joan Wild" wrote:
>
>> That should have been M:\ not ME:\
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>>
>>
|
|
Upon a review of the thread, I think my assumption may be wrong. Perhaps
the 10.28.05 isn't a backup but the latest version of the mdb. If that's
the case then your target needs to be
"C:\Program Files\Microsoft Office\Office10\msaccess.exe"
"\\CALLROOM\RPC\RPCaccess\RPCDatabase10.28.05.mdb" /wrkgrp
"\\CALLROOM\RPC\RPCaccess\RPC.mdw"
--
Joan Wild
Microsoft Access MVP
"Joan Wild" <jwild[ at ]nospamtyenet.com> wrote in message
news:OsGPP2%23OGHA.3016[ at ]tk2msftngp13.phx.gbl...
[Quoted Text] > Well now you have me wondering. I thought before that the 10.28.05 in the
> filename was a bit strange.
>
> Do you know, or can you find out what these files are? I would think that
> you'd use the original RPC database on a day to day basis, and that it
> periodically is backed up - and that's what the date is about. However,
> can you verify that?
>
> *IF* I'm right then your shortcut target needs to say...
> "C:\Program Files\Microsoft Office\Office10\msaccess.exe"
> "\\CALLROOM\RPC\RPCaccess\RPCDatabase.mdb" /wrkgrp
> "\\CALLROOM\RPC\RPCaccess\RPC.mdw"
>
>
> --
> Joan Wild
> Microsoft Access MVP
> "Elis1974" <Elis1974[ at ]discussions.microsoft.com> wrote in message
> news:BFC7A5DF-CE1D-4B2D-B867-9710DF68BCD9[ at ]microsoft.com...
>> Great instructions!! Thanks!! In the RPCAccess folder there are many
>> mdb
>> files, including RPCdatabase 10.28.05(the defunct db), and also several
>> other
>> RPC database's with other backup dates, and the original "RPC database".
>> The
>> only mdw is called RPC.MDW.
>>
>> "Joan Wild" wrote:
>>
>>> That should have been M:\ not ME:\
>>>
>>> --
>>> Joan Wild
>>> Microsoft Access MVP
>>>
>>>
>>>
>
>
|
|
You are correct that the 10.28.05 is the latest copy of the database. We had
another problem with a previous version and I had to make that one (which was
previously a backup) the current version. This was back in October
(obviously from the date you can tell that) and we hadn't had any real
problems till now. So I need to cut and paste this into the target section
of the shortcut to the RPCDatabase 10.28.05. Is that right?
"Joan Wild" wrote:
[Quoted Text] > Upon a review of the thread, I think my assumption may be wrong. Perhaps
> the 10.28.05 isn't a backup but the latest version of the mdb. If that's
> the case then your target needs to be
> "C:\Program Files\Microsoft Office\Office10\msaccess.exe"
> "\\CALLROOM\RPC\RPCaccess\RPCDatabase10.28.05.mdb" /wrkgrp
> "\\CALLROOM\RPC\RPCaccess\RPC.mdw"
>
> --
> Joan Wild
> Microsoft Access MVP
>
> "Joan Wild" <jwild[ at ]nospamtyenet.com> wrote in message
> news:OsGPP2%23OGHA.3016[ at ]tk2msftngp13.phx.gbl...
> > Well now you have me wondering. I thought before that the 10.28.05 in the
> > filename was a bit strange.
> >
> > Do you know, or can you find out what these files are? I would think that
> > you'd use the original RPC database on a day to day basis, and that it
> > periodically is backed up - and that's what the date is about. However,
> > can you verify that?
> >
> > *IF* I'm right then your shortcut target needs to say...
> > "C:\Program Files\Microsoft Office\Office10\msaccess.exe"
> > "\\CALLROOM\RPC\RPCaccess\RPCDatabase.mdb" /wrkgrp
> > "\\CALLROOM\RPC\RPCaccess\RPC.mdw"
> >
> >
> > --
> > Joan Wild
> > Microsoft Access MVP
> > "Elis1974" <Elis1974[ at ]discussions.microsoft.com> wrote in message
> > news:BFC7A5DF-CE1D-4B2D-B867-9710DF68BCD9[ at ]microsoft.com...
> >> Great instructions!! Thanks!! In the RPCAccess folder there are many
> >> mdb
> >> files, including RPCdatabase 10.28.05(the defunct db), and also several
> >> other
> >> RPC database's with other backup dates, and the original "RPC database".
> >> The
> >> only mdw is called RPC.MDW.
> >>
> >> "Joan Wild" wrote:
> >>
> >>> That should have been M:\ not ME:\
> >>>
> >>> --
> >>> Joan Wild
> >>> Microsoft Access MVP
> >>>
> >>>
> >>>
> >
> >
>
>
>
|
|
Yes, put what I posted below into the target. You'll need to modify
everyone's shortcut.
And please post back if it works!
--
Joan Wild
Microsoft Access MVP
"Elis1974" <Elis1974[ at ]discussions.microsoft.com> wrote in message
news:473486DE-224A-4458-8BEE-9EC6CE1758EE[ at ]microsoft.com...
[Quoted Text] > You are correct that the 10.28.05 is the latest copy of the database. We
> had
> another problem with a previous version and I had to make that one (which
> was
> previously a backup) the current version. This was back in October
> (obviously from the date you can tell that) and we hadn't had any real
> problems till now. So I need to cut and paste this into the target
> section
> of the shortcut to the RPCDatabase 10.28.05. Is that right?
>
> "Joan Wild" wrote:
>
>> Upon a review of the thread, I think my assumption may be wrong. Perhaps
>> the 10.28.05 isn't a backup but the latest version of the mdb. If that's
>> the case then your target needs to be
>> "C:\Program Files\Microsoft Office\Office10\msaccess.exe"
>> "\\CALLROOM\RPC\RPCaccess\RPCDatabase10.28.05.mdb" /wrkgrp
>> "\\CALLROOM\RPC\RPCaccess\RPC.mdw"
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>> "Joan Wild" <jwild[ at ]nospamtyenet.com> wrote in message
>> news:OsGPP2%23OGHA.3016[ at ]tk2msftngp13.phx.gbl...
>> > Well now you have me wondering. I thought before that the 10.28.05 in
>> > the
>> > filename was a bit strange.
>> >
>> > Do you know, or can you find out what these files are? I would think
>> > that
>> > you'd use the original RPC database on a day to day basis, and that it
>> > periodically is backed up - and that's what the date is about.
>> > However,
>> > can you verify that?
>> >
>> > *IF* I'm right then your shortcut target needs to say...
>> > "C:\Program Files\Microsoft Office\Office10\msaccess.exe"
>> > "\\CALLROOM\RPC\RPCaccess\RPCDatabase.mdb" /wrkgrp
>> > "\\CALLROOM\RPC\RPCaccess\RPC.mdw"
>> >
>> >
>> > --
>> > Joan Wild
>> > Microsoft Access MVP
>> > "Elis1974" <Elis1974[ at ]discussions.microsoft.com> wrote in message
>> > news:BFC7A5DF-CE1D-4B2D-B867-9710DF68BCD9[ at ]microsoft.com...
>> >> Great instructions!! Thanks!! In the RPCAccess folder there are many
>> >> mdb
>> >> files, including RPCdatabase 10.28.05(the defunct db), and also
>> >> several
>> >> other
>> >> RPC database's with other backup dates, and the original "RPC
>> >> database".
>> >> The
>> >> only mdw is called RPC.MDW.
>> >>
>> >> "Joan Wild" wrote:
>> >>
>> >>> That should have been M:\ not ME:\
>> >>>
>> >>> --
>> >>> Joan Wild
>> >>> Microsoft Access MVP
>> >>>
>> >>>
>> >>>
>> >
>> >
>>
>>
>>
|
|
I feel like we're soooo close, but I copied the whole path into the target
for the shortcut, and it gives me an error message that says:
Can't find the database file
"\\CALLROOM\RPC\RPCAccess\RPCDatabase10.28.05.mdb."
Makse sure you have entered the correct path and file name.
I did it twice just to make sure I hadn't messed it up the first time.
Now what? I must have given you something incorrectly. What can I go back
and double check.
"Joan Wild" wrote:
[Quoted Text] > Yes, put what I posted below into the target. You'll need to modify
> everyone's shortcut.
>
> And please post back if it works!
>
> --
> Joan Wild
> Microsoft Access MVP
>
> "Elis1974" <Elis1974[ at ]discussions.microsoft.com> wrote in message
> news:473486DE-224A-4458-8BEE-9EC6CE1758EE[ at ]microsoft.com...
> > You are correct that the 10.28.05 is the latest copy of the database. We
> > had
> > another problem with a previous version and I had to make that one (which
> > was
> > previously a backup) the current version. This was back in October
> > (obviously from the date you can tell that) and we hadn't had any real
> > problems till now. So I need to cut and paste this into the target
> > section
> > of the shortcut to the RPCDatabase 10.28.05. Is that right?
> >
> > "Joan Wild" wrote:
> >
> >> Upon a review of the thread, I think my assumption may be wrong. Perhaps
> >> the 10.28.05 isn't a backup but the latest version of the mdb. If that's
> >> the case then your target needs to be
> >> "C:\Program Files\Microsoft Office\Office10\msaccess.exe"
> >> "\\CALLROOM\RPC\RPCaccess\RPCDatabase10.28.05.mdb" /wrkgrp
> >> "\\CALLROOM\RPC\RPCaccess\RPC.mdw"
> >>
> >> --
> >> Joan Wild
> >> Microsoft Access MVP
> >>
> >> "Joan Wild" <jwild[ at ]nospamtyenet.com> wrote in message
> >> news:OsGPP2%23OGHA.3016[ at ]tk2msftngp13.phx.gbl...
> >> > Well now you have me wondering. I thought before that the 10.28.05 in
> >> > the
> >> > filename was a bit strange.
> >> >
> >> > Do you know, or can you find out what these files are? I would think
> >> > that
> >> > you'd use the original RPC database on a day to day basis, and that it
> >> > periodically is backed up - and that's what the date is about.
> >> > However,
> >> > can you verify that?
> >> >
> >> > *IF* I'm right then your shortcut target needs to say...
> >> > "C:\Program Files\Microsoft Office\Office10\msaccess.exe"
> >> > "\\CALLROOM\RPC\RPCaccess\RPCDatabase.mdb" /wrkgrp
> >> > "\\CALLROOM\RPC\RPCaccess\RPC.mdw"
> >> >
> >> >
> >> > --
> >> > Joan Wild
> >> > Microsoft Access MVP
> >> > "Elis1974" <Elis1974[ at ]discussions.microsoft.com> wrote in message
> >> > news:BFC7A5DF-CE1D-4B2D-B867-9710DF68BCD9[ at ]microsoft.com...
> >> >> Great instructions!! Thanks!! In the RPCAccess folder there are many
> >> >> mdb
> >> >> files, including RPCdatabase 10.28.05(the defunct db), and also
> >> >> several
> >> >> other
> >> >> RPC database's with other backup dates, and the original "RPC
> >> >> database".
> >> >> The
> >> >> only mdw is called RPC.MDW.
> >> >>
> >> >> "Joan Wild" wrote:
> >> >>
> >> >>> That should have been M:\ not ME:\
> >> >>>
> >> >>> --
> >> >>> Joan Wild
> >> >>> Microsoft Access MVP
> >> >>>
> >> >>>
> >> >>>
> >> >
> >> >
> >>
> >>
> >>
>
>
>
|
|
I have gone through all of these scenarios and am getting a little confused
on how to fix my issue. I attempted to remove my warning concerning security
and, somehow, removed my access to my own database. This is on a single
computer with no other usesers. Here's the error that I get when I attempt
to log in:
You do not have the necessary permissions to use the 'C:\Documents and
Settings\Shawn Knapp.Bennett-INDIANA\My Documents\Call Logs\Call Logs
2003.mdb' object. Have your system administrator or the person who created
this object establish the appropriate permissions for you.
When I click help it gives me the "Error 3033".
I make a back-up once a week and now my computer will not open my back-up
database.
I've tried re-directing the Workgroup Administrator to the above path, which
is where the file is, but I'm not getting anywhere. I also found my Target
to my shortcut and it's directed to the right file, I think.
Can you help?
"Elis1974" wrote:
[Quoted Text] > 1. The path to the workgroup file for the defunct database is
> M:\RPCAccess\RPCDatabase10.25.05.mdw.
>
> 2. On my Hard Drive, when I search for msaccess.exe the path I get is
> C:\Program Files\Microsoft Office\Office10
>
> "Joan Wild" wrote:
>
> > So the path to your workgroup file is M:\RPCAccess\RPC.mdw, right?
> >
> > When you search for msaccess.exe, be sure to search all files and folders,
> > and click on More Advanced Options and check the system folders, and hidden
> > files and folders, and subfolders. Post back with the path.
> >
> >
> > --
> > Joan Wild
> > Microsoft Access MVP
> >
> > Elis1974 wrote:
> > > 1. When I search for *.mdw on the network, (called Callroom), I get a
> > > file called RPC located in the M:\RPCaccess folder.
> > > 2. When I search for msaccess.exe on my local hard drive (C) I find
> > > nothing.
> > >
> > > I'm so confused at this point!!!
> > >
> > > "Joan Wild" wrote:
> > >
> > >> Elis1974 wrote:
> > >>> So you're saying that I should go the the shortcut on my desktop and
> > >>> right click on properties and then under the shortcut tab, where it
> > >>> says Target: I should type in
> > >>> "\\CALLROOM\RPC\RPCaccess\RPCDatabase10.28.05.mdb" /wrkgrp
> > >>> "\\CALLROOM\RPC\RPCaccess\something.mdw", but instead of putting
> > >>> "something" I should put RPCDatabase10.28.05, which is the name of
> > >>> the database I am trying to gain access to?
> > >>
> > >> No. Almost, but not quite. In an earlier post, you said when you
> > >> searched for *.mdw on the network, it located a mdw file in the
> > >> \\CALLROOM\RPC\RPCaccess folder - what is the name of the mdw file
> > >> it found in that folder?
> > >>
> > >> Also, when you search your local computer for msaccess.exe, what is
> > >> the path that it finds for this file?
> > >>
> > >> --
> > >> Joan Wild
> > >> Microsoft Access MVP
> >
> >
> >
|
|
Shawn wrote:
[Quoted Text] > I have gone through all of these scenarios and am getting a little
> confused on how to fix my issue. I attempted to remove my warning
> concerning security and, somehow, removed my access to my own
> database.
What did you do exactly? Do you mean you removed security? What steps did
you take?
> This is on a single computer with no other usesers.
> Here's the error that I get when I attempt to log in:
>
> You do not have the necessary permissions to use the 'C:\Documents and
> Settings\Shawn Knapp.Bennett-INDIANA\My Documents\Call Logs\Call Logs
> 2003.mdb' object. Have your system administrator or the person who
> created this object establish the appropriate permissions for you.
How are you opening the database? Is there a desktop shortcut? What is in
the target of the shortcut?
--
Joan Wild
Microsoft Access MVP
|
|
I will try to remember the steps that I took. I know that I went into
Tools>Security. From there I'm afraid I don't remember exactly what I do.
As I mentioned, I typically rely on my back-ups, but I think that I've
removed my name from the list of accounts somehow.
I have a shortcut that I use to open. I also tried opening it directly from
the folder, but the same thing happened. From the shortcut I went into
properties and clicked on "Find Target...". It took me directly to
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS(application). I opened
that, but got afraid of making more mistakes.
Thank you for your quick response. Very impressive.
"Joan Wild" wrote:
[Quoted Text] > Shawn wrote:
> > I have gone through all of these scenarios and am getting a little
> > confused on how to fix my issue. I attempted to remove my warning
> > concerning security and, somehow, removed my access to my own
> > database.
>
> What did you do exactly? Do you mean you removed security? What steps did
> you take?
>
> > This is on a single computer with no other usesers.
> > Here's the error that I get when I attempt to log in:
> >
> > You do not have the necessary permissions to use the 'C:\Documents and
> > Settings\Shawn Knapp.Bennett-INDIANA\My Documents\Call Logs\Call Logs
> > 2003.mdb' object. Have your system administrator or the person who
> > created this object establish the appropriate permissions for you.
>
> How are you opening the database? Is there a desktop shortcut? What is in
> the target of the shortcut?
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
>
>
|
|
Joan,
I need to give you an update on my database. I've gained access again!
PRAISE THE LORD.
I saw on one of your (many) blogs to replace the security .MDW files. Well,
I grabbed my back-up and re-installed it. It works. It's obvious that I
removed my acces in this file somehow.
Thank you for your help.
"Joan Wild" wrote:
[Quoted Text] > Shawn wrote:
> > I have gone through all of these scenarios and am getting a little
> > confused on how to fix my issue. I attempted to remove my warning
> > concerning security and, somehow, removed my access to my own
> > database.
>
> What did you do exactly? Do you mean you removed security? What steps did
> you take?
>
> > This is on a single computer with no other usesers.
> > Here's the error that I get when I attempt to log in:
> >
> > You do not have the necessary permissions to use the 'C:\Documents and
> > Settings\Shawn Knapp.Bennett-INDIANA\My Documents\Call Logs\Call Logs
> > 2003.mdb' object. Have your system administrator or the person who
> > created this object establish the appropriate permissions for you.
>
> How are you opening the database? Is there a desktop shortcut? What is in
> the target of the shortcut?
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
>
>
|
|
Glad you're back in. Always wise to backup (and often) when trying new
features.
--
Joan Wild
Microsoft Access MVP
Shawn wrote:
[Quoted Text] > Joan,
> I need to give you an update on my database. I've gained access
> again! PRAISE THE LORD.
>
> I saw on one of your (many) blogs to replace the security .MDW files.
> Well, I grabbed my back-up and re-installed it. It works. It's
> obvious that I removed my acces in this file somehow.
>
> Thank you for your help.
>
> "Joan Wild" wrote:
>
>> Shawn wrote:
>>> I have gone through all of these scenarios and am getting a little
>>> confused on how to fix my issue. I attempted to remove my warning
>>> concerning security and, somehow, removed my access to my own
>>> database.
>>
>> What did you do exactly? Do you mean you removed security? What
>> steps did you take?
>>
>>> This is on a single computer with no other usesers.
>>> Here's the error that I get when I attempt to log in:
>>>
>>> You do not have the necessary permissions to use the 'C:\Documents
>>> and Settings\Shawn Knapp.Bennett-INDIANA\My Documents\Call
>>> Logs\Call Logs 2003.mdb' object. Have your system administrator or
>>> the person who created this object establish the appropriate
>>> permissions for you.
>>
>> How are you opening the database? Is there a desktop shortcut?
>> What is in the target of the shortcut?
>>
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
|
|
|