Re: Problem with Upgrade MS Access 2003 to Access 2007

On Sun, 14 Jun 2009 14:50:02 -0700, CarneyClegg3
<CarneyClegg3@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I am confused.
First you write that the file is password protected. Then that it
requires a login (I assume you mean username) and password. Please use
precise language.
You write that the timestamp is Feb-2008. Today is Jun-2009 so why is
this the correct one? The correct one can be derived from the
"workgroup administrator" (wrkgadm.exe) program, or from the shortcut
to open the app.
You write you were in the Immediate window. Of this secured app? If
yes, then the security isn't very good. If no then this doesn't tell
you much; just that you opened an unsecured MDB.

When working with Workgroup Security the best advice is to realize
this is an advanced topic, and you should download, study, and fully
understand the Security FAQ from microsoft.com before proceeding.

-Tom.
Microsoft Access MVP



I'm working with a client who has an important MS Access 2003 file that he
can't open after upgrading from Access 2003 to Access 2007.

The Access file is password protected. Since the upgrade, any time someone
enters a login and password nothing happens ( no error message, and the file
is not opened ). Our goal is to be able to open and work with the file.

After reading the forum, I believed it was the workgroup file, so I checked
for and found the file "security.mdw", in the location C:\Documents and
Settings\username\Application Data\Microsoft\Access. The file has a
timestamp of February 2008, so it is the correct one.

I tried calling the MS Access file from the MS dos prompt using the command:
"path to 2007 msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"
but still had the same problem. That is, we typed the username and password
into the file, but nothing happened.

I did go to the immediate window posting, and tried it out, doing the command
?SysCmd(acSysCmdGetWorkgroupFile) in MSAccess 2007 at the immediate window.
It returned null.

This has been a problem for my client for quite a while, as the Access file
contains important information that he needs to run his business. With this
information, could you tell us what I could do in order to get him going?

Thanks.
.

Relevant Pages

  • Re: Enter user name, enter password, then press enter...
    ... What do you do when the customer asks that the database login in be the same ... username and password to use all of the stuff that she is permitted to use. ... I have implemented this type of security for Access, VB, and Web Based ASP ...
    (microsoft.public.access.forms)
  • [NT] Vulnerability in Hosting Controller (Username Detection)
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Hosting Controller is an all in one ... The site owners' may login to Hosting Controller by submitting the login ... If a non-existing username is entered, ...
    (Securiteam)
  • Re: Show users last login time
    ... > screen upon login stating the user's last login date and ... Check the Security log in Event Viewer. ... Enable the "Do not display last user name" option. ... username and password field did together. ...
    (microsoft.public.win2000.general)
  • Re: Integrated Windows Authentication
    ... click on customer level, scroll down to the bottom, ... > We have a subdirectory within a website on IIS 5.0, on> which users are to login with their username and password> before accessing it. ... > The only way I get the login page within the domain is if> I enabled "Basic Authentication", but I do not wish to> leave this enable due to security reason. ...
    (microsoft.public.inetserver.iis.security)
  • Re: WSE 3.0, usernameOverTransportSecurity, custom Token Manager w/ securityTokenManager,
    ... Microsoft.Web.Services3.Security.Security security) ... throw new Exception("The username token is not present in the ... I've added the web service call directly to my Data binding method ... protected override string AuthenticateToken(UsernameToken ...
    (microsoft.public.dotnet.framework.webservices.enhancements)