Database unable to Login for my computer

[edisonl via AccessMonster.com]

Hi,

1.I got an application that built from my computer, other pc user are able to
use the application from their pc except me.

2.Ironic it might seems, I tried to make some amendments under Security> User
and Group Accounts under name to set it as Users but was not able to save
changes (Apply button was disabled)

3.I even set start up as normal not locking any data, view all tools, but the
start up still in admins mode.

Regards, Edison

 

[Arvin Meyer [MVP]]

Find the MDW file on one of the computers that works, copy it to the same
place on your machine after renaming the MDW file on your machine.

 

[edisonl via AccessMonster.com]

Hi Arvin,

How do I locate the MDW file ?

Regards, Edison

Find the MDW file on one of the computers that works, copy it to the same
place on your machine after renaming the MDW file on your machine.

Hi,

[quoted text clipped - 12 lines]

Regards, Edison

 

[Arvin Meyer [MVP]]

It could be anywhere, but it's usually in the same folder as the database or
in:

C:\Windows\system32\System.mdw

I may not have the name system.mdw, but it will have the mdw extension.

The easiest way to find all the mdw files on your machine is to do a simple:

File >>> Search
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Hi Arvin,

How do I locate the MDW file ?

Regards, Edison

Find the MDW file on one of the computers that works, copy it to the same
place on your machine after renaming the MDW file on your machine.

Hi,

[quoted text clipped - 12 lines]

Regards, Edison

 

[edisonl via AccessMonster.com]

Dear Arvin,

Is the file name similar to my application Eg: Application>> CustomerOrder.
mdw ?

Regards, Edison

It could be anywhere, but it's usually in the same folder as the database or
in:

C:\Windows\system32\System.mdw

I may not have the name system.mdw, but it will have the mdw extension.

The easiest way to find all the mdw files on your machine is to do a simple:

File >>> Search

Hi Arvin,

[quoted text clipped - 9 lines]

 

[Arvin Meyer [MVP]]

It can be, but not necessarily. Start your Workgroup Administrator:

Tools >>> Security >>> Workgroup Administrator

and take a look at the workgroup that you are connected to, that should tell
you something.

Then do a file search on:

..mdw

and find all of them. Try joining each one until it works for you. Or, more
simply find the workgroup on one of the machines that is working right, copy
it and put it on your drive. Then join it.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Dear Arvin,

Is the file name similar to my application Eg: Application>>
CustomerOrder.
mdw ?

Regards, Edison

It could be anywhere, but it's usually in the same folder as the database
or
in:

C:\Windows\system32\System.mdw

I may not have the name system.mdw, but it will have the mdw extension.

The easiest way to find all the mdw files on your machine is to do a
simple:

File >>> Search

Hi Arvin,

[quoted text clipped - 9 lines]

Regards, Edison

 

[Salad]

It can be, but not necessarily. Start your Workgroup Administrator:

Tools >>> Security >>> Workgroup Administrator

and take a look at the workgroup that you are connected to, that should tell
you something.

Then do a file search on:

.mdw

and find all of them. Try joining each one until it works for you. Or, more
simply find the workgroup on one of the machines that is working right, copy
it and put it on your drive. Then join it.

Hi Arvin:

At a client site, I log into Win2003 Server. I have looked for
Wrkgadm.Exe in the Windows folder, the System32 folder, and the C:
drive. File not found. Is that file hidden somehow? In Explorer, it
says to show hidden files. Should I be able to find the Wrkgadm.Exe
file or could it be hiddent from users?

 

[Arvin Meyer [MVP]]

At a client site, I log into Win2003 Server. I have looked for
Wrkgadm.Exe in the Windows folder, the System32 folder, and the C: drive.
File not found. Is that file hidden somehow? In Explorer, it says to
show hidden files. Should I be able to find the Wrkgadm.Exe file or could
it be hiddent from users?

Unless Access is installed on the server, it won't be there. FWIW, it's
usually in the Windows\System32 folder.

 

[Salad]

Unless Access is installed on the server, it won't be there. FWIW, it's
usually in the Windows\System32 folder.

The OS is Win2003 Server. I don't know if one can hide files by profile
name. I have show hidden files set the true in explorer. But in
Windows\System32 folder there's no wrkgadm.exe

 

[Joan Wild]

1. Use Search to locate all *.mdw files on your computer.

2. To start the workgroup administrator - it would help if you told us
the version of Access you're using. Version 97 it's in the system
folder; Version 2000 it's in Program Files\Microsoft Office\Office\1033
folder; Version 2002/2003 it's in Access - Tools, Security, Workgroup
Administrator. Version 2007, Office button, Database Tools, Administer
menu. You can also start it in code with
DoCmd.RunCommand acCmdWorkgroupAdministrator.

3. Doing 2 will join you to the selected workgroup for every session of
Access - i.e. making it the default. You'd likely rather not do this -
keep the default at system.mdw for unsecure databases, and use a desktop
shortcut to launch your secure databases - the workgroup will only be
used for that session of Access, and the default will be used for all
other sessions. The desktop shortcut would have the following in the
target:

"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure.mdw"

Whatever your choice, try each of the mdw files you find, until you get
the right one. If you can't find it, then go to someone else's computer
and check to see what mdw file they are using (workgroup administrator
on their machine).

Joan Wild

 

[David W. Fenton]

I may not have the name system.mdw, but it will have the mdw
extension.

I'm not certain it has to, to be honest.

 

[Salad]

1. Use Search to locate all *.mdw files on your computer.

2. To start the workgroup administrator - it would help if you told us
the version of Access you're using. Version 97 it's in the system
folder; Version 2000 it's in Program Files\Microsoft Office\Office\1033
folder; Version 2002/2003 it's in Access - Tools, Security, Workgroup
Administrator. Version 2007, Office button, Database Tools, Administer
menu. You can also start it in code with
DoCmd.RunCommand acCmdWorkgroupAdministrator.

Ahhh. It's 2003 on the system. So it's part of MS-Access then, not a
separate file like in A97? That'd explain it. I did see that from the
menu but wondered why a person may switch to another group while in an
application.

 

[edisonl via AccessMonster.com]

Hi Salad,

1. I tried using a search from another pc for the system.mdw (I am using
Access 2000) and locate it under C:\Program Files\Microsoft Office\Office\
1033

2. I did a copy and paste to my pc same directory however my Access
application doesn't work.

3. The odd things is only 1 application doesn't work where other Access
application does works.

Regards, Edison

1. Use Search to locate all *.mdw files on your computer.

[quoted text clipped - 5 lines]

menu. You can also start it in code with
DoCmd.RunCommand acCmdWorkgroupAdministrator.

Ahhh. It's 2003 on the system. So it's part of MS-Access then, not a
separate file like in A97? That'd explain it. I did see that from the
menu but wondered why a person may switch to another group while in an
application.

3. Doing 2 will join you to the selected workgroup for every session of
Access - i.e. making it the default. You'd likely rather not do this -

[quoted text clipped - 25 lines]

 

[edisonl via AccessMonster.com]

Hi guys,

Managed to save my piece of work for now..

Make a foolish mistake, just to share.. I did a on enter of keyboard go to
new record (Which I shouldn't have)..

Hopefully it can help someone out there to save some time on this silly
mistakes..

Regards, Edison

 

[Joan Wild]

Ahhh. It's 2003 on the system. So it's part of MS-Access then, not a
separate file like in A97? That'd explain it. I did see that from the
menu but wondered why a person may switch to another group while in an
application.

The workgroup administrator does not switch the current mdw in use; it
just changes your default mdw. Once you quit Access and then restart,
it will then use the mdw specified as the default. The only time it
doesn't use the default, is if you use a shortcut that over-rides the
default via the /wrkgrp switch.

Joan Wild

 

[Salad]

The workgroup administrator does not switch the current mdw in use; it
just changes your default mdw. Once you quit Access and then restart,
it will then use the mdw specified as the default. The only time it
doesn't use the default, is if you use a shortcut that over-rides the
default via the /wrkgrp switch.

Joan Wild

Mil gracia.