Re: Access form password

[Manuel Santos]

In a government office I worked, where I was the Development Manager, i had
a few "wars" with the administration because they wanted the databases to be
in access and the aplications should follow the access structure and not the
SQL structure

2011/6/10 Steven Peck 

> You should try our answer
>
> Us - "Sounds like you need to budget for another developer for it"
> Them - "But it's business critical"
> Us - "Sounds like you should be able to find the funding for a position
> then."
>
> Now, this doesn't actually always work, but it works most of the time
> fortunatly.  Partly because we actively scan for access databases on our
> network shares and then give them our policy which is, we don't support it
> please let us know who your business contact is that does so we know where
> to direct issue requests too.
>
> The few occasions tey do make it 'our problem' we help them find the
> funding so it can be converted to a more sustainable app on one of the SQL
> databases.  Then it goes in the end of year reports as a big giant reminder.
>
> Steven Peck
> http://www.blkmtn.org
>
> On Fri, Jun 10, 2011 at 7:30 AM, Matthew B Ames 
> wrote:
>
>>  We have had the “cottage-industry” of Access applications across the
>> company I work for too.  They are developed by normal staff who then
>> leave/move on and then these things chug along for a bit and then start to
>> fail and end up in my department for fixing.   L
>>
>>
>>
>> *From:* James Rankin [mailto:kz2...@googlemail.com]
>> *Sent:* 10 June 2011 14:56
>>
>> *To:* NT System Admin Issues
>> *Subject:* Re: Access form password
>>
>>
>>
>> Thanks everyone for all the pointers. However...I think the database is
>> corrupted. It can't be repaired, you can't view the database properties, it
>> throws an index error every time - and according to Google, that points to a
>> database "corrupted beyond repair". Even though the users are still managing
>> to utilize it. Somehow.
>>
>>
>> I think I may try to use this as the starting point for a larger project
>> to get the myriad small Access databases dotted around the place
>> consolidated into a single SQL-based system with proper maintenance and
>> authentication etc.
>>
>> I am so glad it's Friday afternoon :-)
>>
>>  On 10 June 2011 14:52, Daniel Rodriguez  wrote:
>>
>> It may help if you could see the contents of the .df files. There are some
>> free viewers. DBFPlus comes to mind. You may also need to convert those .dbf
>> files. DBFConvert probably do the trick for you. That way you dont have to
>> go hunting for an older version of Access. Then I use a hex editor to look
>> at those forms. Also, I would look at any vba scripting files, if any.
>>
>> But, that's me.
>>
>> Typed not so frustratingly on my Dell Streak 7.
>>
>> On Jun 10, 2011 9:01 AM,  wrote:
>>
>> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~
>> ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~
>>
>> ---
>> To manage subscriptions click here:
>> http://lyris.sunbelt-software.com/read/my_forums/
>> or send an email to listmana...@lyris.sunbeltsoftware.com
>> with the body: unsubscribe ntsysadmin
>>
>>
>>
>>
>> --
>> "On two occasions...I have been asked, 'Pray, Mr Babbage, if you put into
>> the machine wrong figures, will the right answers come out?' I am not able
>> rightly to apprehend the kind of confusion of ideas that could provoke such
>> a question."
>>
>> *IMPORTANT: The information in this email is CONFIDENTIAL. If its
>> contents are disclosed in any way my lawyers will swoop down from black
>> helicopters like Seal Team Six and drag you away with a black bag over your
>> head. They will then take you to a secret prison and make you fight to the
>> death with other people who dared to share this email. You will be given a
>> large bowie knife and a supply of methamphetamines while I watch the said
>> deathmatch and wager vast sums of money on who will be the winner. If the
>> fight becomes boring or there is a stalemate, I will release rabid dogs and
>> my two-stone cat into the arena to liven things up a bit. If these animals
>> become in any way docile, I will squirt them with water pistols until they
>> become a bit more temperamental.*
>>
>> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~
>> ~ <http://www.sunbeltsoftware.com/Bus

Re: Access form password

[Steven Peck]

You should try our answer

Us - "Sounds like you need to budget for another developer for it"
Them - "But it's business critical"
Us - "Sounds like you should be able to find the funding for a position
then."

Now, this doesn't actually always work, but it works most of the time
fortunatly.  Partly because we actively scan for access databases on our
network shares and then give them our policy which is, we don't support it
please let us know who your business contact is that does so we know where
to direct issue requests too.

The few occasions tey do make it 'our problem' we help them find the funding
so it can be converted to a more sustainable app on one of the SQL
databases.  Then it goes in the end of year reports as a big giant reminder.

Steven Peck
http://www.blkmtn.org

On Fri, Jun 10, 2011 at 7:30 AM, Matthew B Ames wrote:

>  We have had the “cottage-industry” of Access applications across the
> company I work for too.  They are developed by normal staff who then
> leave/move on and then these things chug along for a bit and then start to
> fail and end up in my department for fixing.   L
>
>
>
> *From:* James Rankin [mailto:kz2...@googlemail.com]
> *Sent:* 10 June 2011 14:56
>
> *To:* NT System Admin Issues
> *Subject:* Re: Access form password
>
>
>
> Thanks everyone for all the pointers. However...I think the database is
> corrupted. It can't be repaired, you can't view the database properties, it
> throws an index error every time - and according to Google, that points to a
> database "corrupted beyond repair". Even though the users are still managing
> to utilize it. Somehow.
>
>
> I think I may try to use this as the starting point for a larger project to
> get the myriad small Access databases dotted around the place consolidated
> into a single SQL-based system with proper maintenance and authentication
> etc.
>
> I am so glad it's Friday afternoon :-)
>
>  On 10 June 2011 14:52, Daniel Rodriguez  wrote:
>
> It may help if you could see the contents of the .df files. There are some
> free viewers. DBFPlus comes to mind. You may also need to convert those .dbf
> files. DBFConvert probably do the trick for you. That way you dont have to
> go hunting for an older version of Access. Then I use a hex editor to look
> at those forms. Also, I would look at any vba scripting files, if any.
>
> But, that's me.
>
> Typed not so frustratingly on my Dell Streak 7.
>
> On Jun 10, 2011 9:01 AM,  wrote:
>
> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~
> ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~
>
> ---
> To manage subscriptions click here:
> http://lyris.sunbelt-software.com/read/my_forums/
> or send an email to listmana...@lyris.sunbeltsoftware.com
> with the body: unsubscribe ntsysadmin
>
>
>
>
> --
> "On two occasions...I have been asked, 'Pray, Mr Babbage, if you put into
> the machine wrong figures, will the right answers come out?' I am not able
> rightly to apprehend the kind of confusion of ideas that could provoke such
> a question."
>
> *IMPORTANT: The information in this email is CONFIDENTIAL. If its contents
> are disclosed in any way my lawyers will swoop down from black helicopters
> like Seal Team Six and drag you away with a black bag over your head. They
> will then take you to a secret prison and make you fight to the death with
> other people who dared to share this email. You will be given a large bowie
> knife and a supply of methamphetamines while I watch the said deathmatch and
> wager vast sums of money on who will be the winner. If the fight becomes
> boring or there is a stalemate, I will release rabid dogs and my two-stone
> cat into the arena to liven things up a bit. If these animals become in any
> way docile, I will squirt them with water pistols until they become a bit
> more temperamental.*
>
> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~
> ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~
>
> ---
> To manage subscriptions click here:
> http://lyris.sunbelt-software.com/read/my_forums/
> or send an email to listmana...@lyris.sunbeltsoftware.com
> with the body: unsubscribe ntsysadmin
>
> This email and any attachments to it may be confidential and are intended
> solely for the use of the individual to whom it is addressed. If you are not
> the intended recipient of this email, you must neither take any action based
> upon its contents, nor copy or show it to anyone. Please contact the sender
> if you believe you have received this email in error. QinetiQ may monitor
> email traffic data and 

RE: Access form password

[Matthew B Ames]

We have had the "cottage-industry" of Access applications across the company I 
work for too.  They are developed by normal staff who then leave/move on and 
then these things chug along for a bit and then start to fail and end up in my 
department for fixing.   :(

From: James Rankin [mailto:kz2...@googlemail.com]
Sent: 10 June 2011 14:56
To: NT System Admin Issues
Subject: Re: Access form password

Thanks everyone for all the pointers. However...I think the database is 
corrupted. It can't be repaired, you can't view the database properties, it 
throws an index error every time - and according to Google, that points to a 
database "corrupted beyond repair". Even though the users are still managing to 
utilize it. Somehow.

I think I may try to use this as the starting point for a larger project to get 
the myriad small Access databases dotted around the place consolidated into a 
single SQL-based system with proper maintenance and authentication etc.

I am so glad it's Friday afternoon :-)
On 10 June 2011 14:52, Daniel Rodriguez 
mailto:drod...@gmail.com>> wrote:

It may help if you could see the contents of the .df files. There are some free 
viewers. DBFPlus comes to mind. You may also need to convert those .dbf files. 
DBFConvert probably do the trick for you. That way you dont have to go hunting 
for an older version of Access. Then I use a hex editor to look at those forms. 
Also, I would look at any vba scripting files, if any.

But, that's me.

Typed not so frustratingly on my Dell Streak 7.
On Jun 10, 2011 9:01 AM, 
mailto:roberto.gri...@gmail.com>> wrote:

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to 
listmana...@lyris.sunbeltsoftware.com<mailto:listmana...@lyris.sunbeltsoftware.com>
with the body: unsubscribe ntsysadmin



--
"On two occasions...I have been asked, 'Pray, Mr Babbage, if you put into the 
machine wrong figures, will the right answers come out?' I am not able rightly 
to apprehend the kind of confusion of ideas that could provoke such a question."

IMPORTANT: The information in this email is CONFIDENTIAL. If its contents are 
disclosed in any way my lawyers will swoop down from black helicopters like 
Seal Team Six and drag you away with a black bag over your head. They will then 
take you to a secret prison and make you fight to the death with other people 
who dared to share this email. You will be given a large bowie knife and a 
supply of methamphetamines while I watch the said deathmatch and wager vast 
sums of money on who will be the winner. If the fight becomes boring or there 
is a stalemate, I will release rabid dogs and my two-stone cat into the arena 
to liven things up a bit. If these animals become in any way docile, I will 
squirt them with water pistols until they become a bit more temperamental.

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to 
listmana...@lyris.sunbeltsoftware.com<mailto:listmana...@lyris.sunbeltsoftware.com>
with the body: unsubscribe ntsysadmin

This email and any attachments to it may be confidential and are
intended solely for the use of the individual to whom it is addressed.
If you are not the intended recipient of this email, you must neither
take any action based upon its contents, nor copy or show it to anyone.
Please contact the sender if you believe you have received this email in
error. QinetiQ may monitor email traffic data and also the content of
email for the purposes of security. QinetiQ Limited (Registered in
England & Wales: Company Number: 3796233) Registered office: Cody Technology 
Park, Ively Road, Farnborough, Hampshire, GU14 0LX http://www.qinetiq.com.

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin

Re: Access form password

[James Rankin]

Thanks everyone for all the pointers. However...I think the database is
corrupted. It can't be repaired, you can't view the database properties, it
throws an index error every time - and according to Google, that points to a
database "corrupted beyond repair". Even though the users are still managing
to utilize it. Somehow.

I think I may try to use this as the starting point for a larger project to
get the myriad small Access databases dotted around the place consolidated
into a single SQL-based system with proper maintenance and authentication
etc.

I am so glad it's Friday afternoon :-)

On 10 June 2011 14:52, Daniel Rodriguez  wrote:

> It may help if you could see the contents of the .df files. There are some
> free viewers. DBFPlus comes to mind. You may also need to convert those .dbf
> files. DBFConvert probably do the trick for you. That way you dont have to
> go hunting for an older version of Access. Then I use a hex editor to look
> at those forms. Also, I would look at any vba scripting files, if any.
>
> But, that's me.
>
> Typed not so frustratingly on my Dell Streak 7.
>  On Jun 10, 2011 9:01 AM,  wrote:
>
> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~
> ~   ~
>
> ---
> To manage subscriptions click here:
> http://lyris.sunbelt-software.com/read/my_forums/
> or send an email to listmana...@lyris.sunbeltsoftware.com
> with the body: unsubscribe ntsysadmin
>



-- 
"On two occasions...I have been asked, 'Pray, Mr Babbage, if you put into
the machine wrong figures, will the right answers come out?' I am not able
rightly to apprehend the kind of confusion of ideas that could provoke such
a question."

*IMPORTANT: The information in this email is CONFIDENTIAL. If its contents
are disclosed in any way my lawyers will swoop down from black helicopters
like Seal Team Six and drag you away with a black bag over your head. They
will then take you to a secret prison and make you fight to the death with
other people who dared to share this email. You will be given a large bowie
knife and a supply of methamphetamines while I watch the said deathmatch and
wager vast sums of money on who will be the winner. If the fight becomes
boring or there is a stalemate, I will release rabid dogs and my two-stone
cat into the arena to liven things up a bit. If these animals become in any
way docile, I will squirt them with water pistols until they become a bit
more temperamental.*

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~   ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin

Re: Access form password

[Daniel Rodriguez]

It may help if you could see the contents of the .df files. There are some
free viewers. DBFPlus comes to mind. You may also need to convert those .dbf
files. DBFConvert probably do the trick for you. That way you dont have to
go hunting for an older version of Access. Then I use a hex editor to look
at those forms. Also, I would look at any vba scripting files, if any.

But, that's me.

Typed not so frustratingly on my Dell Streak 7.
 On Jun 10, 2011 9:01 AM,  wrote:

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~   ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin

Re: Access form password

[roberto . grippi]

Get to know your enemy: do you have older records in the company that show
what passwords your developer used at that time, and in this case give you a
hint on what he might have used for your db?

Could be faster than any other (more serious) method.
My 2c.

Roberto Grippi


2011/6/10 James Rankin 

> Tried that, do File | Get External Data | Import, select the old 97 db, and
> it bombs with "operation invalid without a current index". It then offers me
> an Import Objects dialog, which is completely empty. Sounds like not only is
> this ancient, it may well be damaged or erroneous too. When I try to "Repair
> Database" from 97, it tells me there is an index problem. My day just keeps
> getting better :-(
>
>
> On 10 June 2011 13:07, Tony Patton  wrote:
>
>> Bit of a long shot, but have you tried importing everything into a new
>> database in Access 2000?
>>
>> It's been a long time since I came across this.
>>
>> T
>>
>> Typed slowly on HTC Desire
>> On 10 Jun 2011 13:02, "James Rankin"  wrote:
>> > I have, I've cleared the password for the user Admin which is the db
>> owner,
>> > yet still, when I go to convert, I get the permissions error. I hope
>> this
>> > developer hasn't done something crafty to block the conversion.
>> >
>> > On 10 June 2011 12:59, Jonathan Link  wrote:
>> >
>> >> But perhaps, under 97 you can go in and turn off all the passwords...
>> >>
>> >>
>> >> On Fri, Jun 10, 2011 at 7:56 AM, James Rankin > >wrote:
>> >>
>> >>> Yes, I can open it in Access 97, but I am damned if I am sequencing up
>> an
>> >>> Office 97 app to run on our Windows 2008 R2 systems.
>> >>>
>> >>> I need to convert it to, at the very least, Access 2000 for it to be
>> in
>> >>> any way supportable, and even then it would only have to be for a
>> short
>> >>> period. Longer term we need to look to get this data put somewhere
>> >>> completely different, but that's a whole different battle.
>> >>>
>> >>>
>> >>> On 10 June 2011 12:46, Manuel Santos  wrote:
>> >>>
>> >>>> Can’t you find a machine with Access 97 installed?
>> >>>>
>> >>>>
>> >>>>
>> >>>> *From:* James Rankin [mailto:kz2...@googlemail.com]
>> >>>> *Sent:* sexta-feira, 10 de Junho de 2011 12:16
>> >>>> *To:* NT System Admin Issues
>> >>>> *Subject:* Re: Access form password
>> >>>>
>> >>>>
>> >>>>
>> >>>> Note the use of the word "drafting"
>> >>>>
>> >>>> When I cool off a bit I'll probably tone it down nicely :-)
>> >>>>
>> >>>> I still can't get this blasted thing converted. I tried running
>> Access
>> >>>> 2000 using the command line with the /convert switch and specifying
>> the
>> >>>> "Admin" username, but it just pops up a "Logon" box and rejects my
>> >>>> credentials every time
>> >>>>
>> >>>> On 10 June 2011 12:05, Andrew S. Baker  wrote:
>> >>>>
>> >>>> Be thankful he was stuck using an older version of Access.
>> >>>>
>> >>>> Anyway, you're not out of the woods yet...
>> >>>>
>> >>>> Oh, and a snotty email isn't really going to help your cause here.
>> Rather, send out a memo that indicates that you would like a meeting to
>> discuss and uncover any other apps that are being used so you can ensure
>> that they are backed up and supportable. You won't have to make any direct
>> references to this incident, which helps people save face and makes them far
>> more likely to cooperate with you.
>> >>>>
>> >>>>
>> >>>>
>> >>>> *ASB *(Professional Bio <http://about.me/Andrew.S.Baker/bio>)
>> >>>> *Harnessing the Advantages of Technology for the SMB market...*
>>
>> >>>>
>> >>>>
>> >>>>
>> >>>> On Fri, Jun 10, 2011 at 6:17 AM, James Rankin > >
>> >>>> wrote:
>> >>>>
>> >>>> Well I never - we have managed to dig the password out of it. The
>> >>>> developer clearly wasn't as cl

Re: Access form password

[James Rankin]

Tried that, do File | Get External Data | Import, select the old 97 db, and
it bombs with "operation invalid without a current index". It then offers me
an Import Objects dialog, which is completely empty. Sounds like not only is
this ancient, it may well be damaged or erroneous too. When I try to "Repair
Database" from 97, it tells me there is an index problem. My day just keeps
getting better :-(

On 10 June 2011 13:07, Tony Patton  wrote:

> Bit of a long shot, but have you tried importing everything into a new
> database in Access 2000?
>
> It's been a long time since I came across this.
>
> T
>
> Typed slowly on HTC Desire
> On 10 Jun 2011 13:02, "James Rankin"  wrote:
> > I have, I've cleared the password for the user Admin which is the db
> owner,
> > yet still, when I go to convert, I get the permissions error. I hope this
> > developer hasn't done something crafty to block the conversion.
> >
> > On 10 June 2011 12:59, Jonathan Link  wrote:
> >
> >> But perhaps, under 97 you can go in and turn off all the passwords...
> >>
> >>
> >> On Fri, Jun 10, 2011 at 7:56 AM, James Rankin  >wrote:
> >>
> >>> Yes, I can open it in Access 97, but I am damned if I am sequencing up
> an
> >>> Office 97 app to run on our Windows 2008 R2 systems.
> >>>
> >>> I need to convert it to, at the very least, Access 2000 for it to be in
> >>> any way supportable, and even then it would only have to be for a short
> >>> period. Longer term we need to look to get this data put somewhere
> >>> completely different, but that's a whole different battle.
> >>>
> >>>
> >>> On 10 June 2011 12:46, Manuel Santos  wrote:
> >>>
> >>>> Can’t you find a machine with Access 97 installed?
> >>>>
> >>>>
> >>>>
> >>>> *From:* James Rankin [mailto:kz2...@googlemail.com]
> >>>> *Sent:* sexta-feira, 10 de Junho de 2011 12:16
> >>>> *To:* NT System Admin Issues
> >>>> *Subject:* Re: Access form password
> >>>>
> >>>>
> >>>>
> >>>> Note the use of the word "drafting"
> >>>>
> >>>> When I cool off a bit I'll probably tone it down nicely :-)
> >>>>
> >>>> I still can't get this blasted thing converted. I tried running Access
> >>>> 2000 using the command line with the /convert switch and specifying
> the
> >>>> "Admin" username, but it just pops up a "Logon" box and rejects my
> >>>> credentials every time
> >>>>
> >>>> On 10 June 2011 12:05, Andrew S. Baker  wrote:
> >>>>
> >>>> Be thankful he was stuck using an older version of Access.
> >>>>
> >>>> Anyway, you're not out of the woods yet...
> >>>>
> >>>> Oh, and a snotty email isn't really going to help your cause here.
> Rather, send out a memo that indicates that you would like a meeting to
> discuss and uncover any other apps that are being used so you can ensure
> that they are backed up and supportable. You won't have to make any direct
> references to this incident, which helps people save face and makes them far
> more likely to cooperate with you.
> >>>>
> >>>>
> >>>>
> >>>> *ASB *(Professional Bio <http://about.me/Andrew.S.Baker/bio>)
> >>>> *Harnessing the Advantages of Technology for the SMB market...*
>
> >>>>
> >>>>
> >>>>
> >>>> On Fri, Jun 10, 2011 at 6:17 AM, James Rankin 
> >>>> wrote:
> >>>>
> >>>> Well I never - we have managed to dig the password out of it. The
> >>>> developer clearly wasn't as clever as he thought
> >>>>
> >>>> Now onto the next issue - whenever I try and open this database in a
> >>>> later version of Access, it tells me this
> >>>>
> >>>> [image: 3.jpg]
> >>>> Anyone have any ideas how to get around this bit?
> >>>>
> >>>> Cheers,
> >>>>
> >>>>
> >>>>
> >>>> On 10 June 2011 11:03, James Rankin  wrote:
> >>>>
> >>>> Thanks for the suggestion. Unfortunately that tool just, like many
> >>>> others, tells me the database isn't password protected. It isn't

Re: Access form password

[Tony Patton]

Bit of a long shot, but have you tried importing everything into a new
database in Access 2000?

It's been a long time since I came across this.

T

Typed slowly on HTC Desire
On 10 Jun 2011 13:02, "James Rankin"  wrote:
> I have, I've cleared the password for the user Admin which is the db
owner,
> yet still, when I go to convert, I get the permissions error. I hope this
> developer hasn't done something crafty to block the conversion.
>
> On 10 June 2011 12:59, Jonathan Link  wrote:
>
>> But perhaps, under 97 you can go in and turn off all the passwords...
>>
>>
>> On Fri, Jun 10, 2011 at 7:56 AM, James Rankin wrote:
>>
>>> Yes, I can open it in Access 97, but I am damned if I am sequencing up
an
>>> Office 97 app to run on our Windows 2008 R2 systems.
>>>
>>> I need to convert it to, at the very least, Access 2000 for it to be in
>>> any way supportable, and even then it would only have to be for a short
>>> period. Longer term we need to look to get this data put somewhere
>>> completely different, but that's a whole different battle.
>>>
>>>
>>> On 10 June 2011 12:46, Manuel Santos  wrote:
>>>
>>>> Can’t you find a machine with Access 97 installed?
>>>>
>>>>
>>>>
>>>> *From:* James Rankin [mailto:kz2...@googlemail.com]
>>>> *Sent:* sexta-feira, 10 de Junho de 2011 12:16
>>>> *To:* NT System Admin Issues
>>>> *Subject:* Re: Access form password
>>>>
>>>>
>>>>
>>>> Note the use of the word "drafting"
>>>>
>>>> When I cool off a bit I'll probably tone it down nicely :-)
>>>>
>>>> I still can't get this blasted thing converted. I tried running Access
>>>> 2000 using the command line with the /convert switch and specifying the
>>>> "Admin" username, but it just pops up a "Logon" box and rejects my
>>>> credentials every time
>>>>
>>>> On 10 June 2011 12:05, Andrew S. Baker  wrote:
>>>>
>>>> Be thankful he was stuck using an older version of Access.
>>>>
>>>> Anyway, you're not out of the woods yet...
>>>>
>>>> Oh, and a snotty email isn't really going to help your cause here.
Rather, send out a memo that indicates that you would like a meeting to
discuss and uncover any other apps that are being used so you can ensure
that they are backed up and supportable. You won't have to make any direct
references to this incident, which helps people save face and makes them far
more likely to cooperate with you.
>>>>
>>>>
>>>>
>>>> *ASB *(Professional Bio <http://about.me/Andrew.S.Baker/bio>)
>>>> *Harnessing the Advantages of Technology for the SMB market...*
>>>>
>>>>
>>>>
>>>> On Fri, Jun 10, 2011 at 6:17 AM, James Rankin 
>>>> wrote:
>>>>
>>>> Well I never - we have managed to dig the password out of it. The
>>>> developer clearly wasn't as clever as he thought
>>>>
>>>> Now onto the next issue - whenever I try and open this database in a
>>>> later version of Access, it tells me this
>>>>
>>>> [image: 3.jpg]
>>>> Anyone have any ideas how to get around this bit?
>>>>
>>>> Cheers,
>>>>
>>>>
>>>>
>>>> On 10 June 2011 11:03, James Rankin  wrote:
>>>>
>>>> Thanks for the suggestion. Unfortunately that tool just, like many
>>>> others, tells me the database isn't password protected. It isn't, per
se.
>>>> You can open the database, where you are met with this
>>>>
>>>> [image: menu.jpg]
>>>>
>>>> When you fail to get the right password for admin, this appears
>>>>
>>>> [image: password.jpg]
>>>>
>>>> Needless to say, I can't get into Design view - the database just
closes
>>>> automatically.
>>>>
>>>> This is very annoying, and I'm hoping the powers-that-be start taking
>>>> notice of their serious lack of process and procedure which allows
things
>>>> like this to swim up and bite me on the ass.
>>>>
>>>> Grrr
>>>>
>>>> On 10 June 2011 10:48, Manuel Santos  wrote:
>>>>
>>>> As far as I remember, I once had a problem like that, and wasn't able
to
>>>> 

Re: Access form password

[Manuel Santos]

As far as I remember, I once had a problem like that, and wasn't able to
access  some data on Access 97 database, and I used a tool to crack the
password: http://www.rixler.com/eng/access_password_recovery.htm

2011/6/10 James Rankin 

> Another day, another episode of "I can't believe this has been allowed to
> happen" - yet here I am.
>
> We have a department that (unknown to me until today) are reliant on a
> database that was built (and still runs in!) Access 97. Yes, you heard me
> right. I mean, it only went out of extended support in February 2002, what's
> nearly ten years of unsupported software between friends?
>
> However (the plot thickens) it was built and maintained by a developer who
> has now left the company. And it needs some administration doing to it. And
> it turns out that the form to administer the database is password-protected.
> And not surprisingly, as with all problems that seem to have defeated
> everyone else, it is now sitting in my lap. The developer can't be contacted
> - believe me, short of commissioning a private investigator, I have tried
> all I can.
>
> The question is - does anyone know any way I could reveal or reset the
> password that is protecting the admin form? It's that long since I used any
> form of Access (never mind a 14-year old version of it!) that I am
> completely clueless here.
>
> I'm already drafting up a snotty email to go to the business heads here
> about the importance of migrating their critical data onto supported
> platforms, so hopefully something like this should never happen again (yes,
> it probably will, though). But if anyone can think of any way I can get
> inside the guts of this ancient database, I sure would be grateful.
>
>
> TIA,
>
>
>
> JRR
>
> --
> "On two occasions...I have been asked, 'Pray, Mr Babbage, if you put into
> the machine wrong figures, will the right answers come out?' I am not able
> rightly to apprehend the kind of confusion of ideas that could provoke such
> a question."
>
> *IMPORTANT: The information in this email is CONFIDENTIAL. If its contents
> are disclosed in any way my lawyers will swoop down from black helicopters
> like Seal Team Six and drag you away with a black bag over your head. They
> will then take you to a secret prison and make you fight to the death with
> other people who dared to share this email. You will be given a large bowie
> knife and a supply of methamphetamines while I watch the said deathmatch and
> wager vast sums of money on who will be the winner. If the fight becomes
> boring or there is a stalemate, I will release rabid dogs and my two-stone
> cat into the arena to liven things up a bit. If these animals become in any
> way docile, I will squirt them with water pistols until they become a bit
> more temperamental.*
>
> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~
> ~   ~
>
> ---
> To manage subscriptions click here:
> http://lyris.sunbelt-software.com/read/my_forums/
> or send an email to listmana...@lyris.sunbeltsoftware.com
> with the body: unsubscribe ntsysadmin
>

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~   ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin