PC Review


Reply
Thread Tools Rate Thread

Access 95 Migration to Windows XP

 
 
=?Utf-8?B?TFRvZnNydWQ=?=
Guest
Posts: n/a
 
      1st Jun 2005
Good day everyone,

I have ran into a problem with getting into an Access 95 database that was
recently migrated from Windows 98 to Windows XP.

While it was in Windows 98, if you tried to get into the database to make
changes it would prompt you for credentials. Now that it is running Windows
XP, it doesn't even prompt me for the credentials. I have tried changing the
groups without success and now I am being prevented from making any changes.

Has anyone seen this type of behaviour before and can possibly shed some
light on this?

Many thanks!

Lance
 
Reply With Quote
 
 
 
 
Keith
Guest
Posts: n/a
 
      1st Jun 2005
"LTofsrud" <(E-Mail Removed)> wrote in message
news:F27D18F4-0246-4864-A209-(E-Mail Removed)...
> Good day everyone,
>
> I have ran into a problem with getting into an Access 95 database that was
> recently migrated from Windows 98 to Windows XP.
>
> While it was in Windows 98, if you tried to get into the database to make
> changes it would prompt you for credentials. Now that it is running
> Windows
> XP, it doesn't even prompt me for the credentials. I have tried changing
> the
> groups without success and now I am being prevented from making any
> changes.
>
>

In order to open an Access application you need a Workgroup Information File
(WIF). For non-secured apps this will be the default 'system.mdw' somewhere
on your OS drive. To have Access prompt you for user credentials you need
to point you PC at the WIF that was created to secure it. You would
normally do this via a desktop shortcut with a command line format:

"Full path to MSACCESS.exe" "Full path to your app.mdb" /wrkgrp "Full path
to your WIF.mdw"

including the quotation marks. An alternative method is to use the
Workgroup Admin tool to switch your PC to look at your custom WIF which was
probably how your old system was set up, since you didn't mention using a
shortcut.

Either way you need to locate your custom WIF which hopefully wasn't on the
OS drive that was presumably wipes as part of your XP upgrade.

Good luck.
Keith.
www.keithwilby.com


 
Reply With Quote
 
=?Utf-8?B?TFRvZnNydWQ=?=
Guest
Posts: n/a
 
      1st Jun 2005
Thanks for the quick reply Keith.

I will give that a try tonight. I wasn't provided a Workgroup Information
File from the migration so does this mean that I am probably out of luck?

I do have the credentials (user ID and password), so is there a way to
recreate the WIF if I cannot locate it?

Lance


"Keith" wrote:

> "LTofsrud" <(E-Mail Removed)> wrote in message
> news:F27D18F4-0246-4864-A209-(E-Mail Removed)...
> > Good day everyone,
> >
> > I have ran into a problem with getting into an Access 95 database that was
> > recently migrated from Windows 98 to Windows XP.
> >
> > While it was in Windows 98, if you tried to get into the database to make
> > changes it would prompt you for credentials. Now that it is running
> > Windows
> > XP, it doesn't even prompt me for the credentials. I have tried changing
> > the
> > groups without success and now I am being prevented from making any
> > changes.
> >
> >

> In order to open an Access application you need a Workgroup Information File
> (WIF). For non-secured apps this will be the default 'system.mdw' somewhere
> on your OS drive. To have Access prompt you for user credentials you need
> to point you PC at the WIF that was created to secure it. You would
> normally do this via a desktop shortcut with a command line format:
>
> "Full path to MSACCESS.exe" "Full path to your app.mdb" /wrkgrp "Full path
> to your WIF.mdw"
>
> including the quotation marks. An alternative method is to use the
> Workgroup Admin tool to switch your PC to look at your custom WIF which was
> probably how your old system was set up, since you didn't mention using a
> shortcut.
>
> Either way you need to locate your custom WIF which hopefully wasn't on the
> OS drive that was presumably wipes as part of your XP upgrade.
>
> Good luck.
> Keith.
> www.keithwilby.com
>
>
>

 
Reply With Quote
 
Keith
Guest
Posts: n/a
 
      1st Jun 2005
"LTofsrud" <(E-Mail Removed)> wrote in message
news:30E31646-D1E7-4A1C-B926-(E-Mail Removed)...
> Thanks for the quick reply Keith.
>
> I will give that a try tonight. I wasn't provided a Workgroup Information
> File from the migration so does this mean that I am probably out of luck?


Hi Lance.

Yes, unless you resort to some hacking software that is available from
various outlets (at a price).

>
> I do have the credentials (user ID and password), so is there a way to
> recreate the WIF if I cannot locate it?
>


You'd need all the unique information that was used to create the WIF, not
just the user ID and password I'm afraid.

Regards,
Keith.


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Migration to access ... help !!! John@home Microsoft Access Database Table Design 0 23rd Jul 2009 05:17 PM
Access migration Mark Microsoft Access ADP SQL Server 1 3rd May 2009 06:05 AM
Access Migration to SQL Steve Westwood Microsoft Access ADP SQL Server 6 24th May 2007 07:56 PM
Issues Migration Access 97 to Access 2003 Mone Microsoft Access 1 8th Apr 2007 05:30 AM
Re: Access 97 to Access 2000 (or later version) migration Larry Daugherty Microsoft Access 1 15th Sep 2003 12:26 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:02 PM.