locked out of old app

I'm maintaining an inherited (Access 2002) database, with no
documentation. I need to change the address for the data source, but
the main toolbar has been changed. It no longer has View or Tools, and
I can't open the database for editing by holding down the Shift key.
It's also password-protected, but fortunately I know the password.
I've searched the VB code, and can find no reference to a custom
toolbar.

How do I restore the options on the toolbar, and/or open this in Design
view, so I can work with this application?

Thanks in advance,

S.H.

re: locked out of old app

sh_spamca...@yahoo.com wrote:[color=blue]
> I'm maintaining an inherited (Access 2002) database, with no
> documentation. I need to change the address for the data source, but
> the main toolbar has been changed. It no longer has View or Tools,[/color]
and[color=blue]
> I can't open the database for editing by holding down the Shift key.
> It's also password-protected, but fortunately I know the password.
> I've searched the VB code, and can find no reference to a custom
> toolbar.
>
> How do I restore the options on the toolbar, and/or open this in[/color]
Design[color=blue]
> view, so I can work with this application?
>
> Thanks in advance,
>
> S.H.[/color]

re: locked out of old app

Launch MS Access, then do a File, Open on the database while holding
down the shift key. This results in a system admin's view like you are
expecting.

re: locked out of old app

I still can't open the database for editing by holding down the Shift
key. Is there any other way?

Thanks,

S.H.

re: locked out of old app

sh_spamcatch@yahoo.com wrote:
[color=blue]
> I still can't open the database for editing by holding down the Shift
> key. Is there any other way?
>
> Thanks,
>
> S.H.
>[/color]

Create a new database. See if you can import the objects into it.

re: locked out of old app

Salad wrote:[color=blue]
> sh_spamcatch@yahoo.com wrote:
>[color=green]
> > I still can't open the database for editing by holding down the[/color][/color]
Shift[color=blue][color=green]
> > key. Is there any other way?
> >
> > Thanks,
> >
> > S.H.
> >[/color]
>
> Create a new database. See if you can import the objects into it.[/color]

I can import the tables only. Since the tables are in a separate mdb,
I can already access them directly. I need to change the location of
the data source in the original application to point to that separate
mdb. (My network gurus have seen fit to move all the servers without
prior warning, so I'm scrambling to fix everything.)

The basic question: how do I get to Linked Table Manager without the
Tools option on the menu?

Thanks,

S.H.

re: locked out of old app

On 10 Jan 2005 11:07:24 -0800, sh_spamcatch@yahoo.com wrote:

Open MsAccess.
File/Open. Shift-Load your app.
You should now have Tools/Database utilities/Linked table manager.
If not, your Access installation is bad; try on another machine.

-Tom.

[color=blue]
>I'm maintaining an inherited (Access 2002) database, with no
>documentation. I need to change the address for the data source, but
>the main toolbar has been changed. It no longer has View or Tools, and
>I can't open the database for editing by holding down the Shift key.
>It's also password-protected, but fortunately I know the password.
>I've searched the VB code, and can find no reference to a custom
>toolbar.
>
>How do I restore the options on the toolbar, and/or open this in Design
>view, so I can work with this application?
>
>Thanks in advance,
>
>S.H.[/color]

re: locked out of old app

Tom van Stiphout wrote:[color=blue]
> On 10 Jan 2005 11:07:24 -0800, sh_spamcatch@yahoo.com wrote:
>
> Open MsAccess.
> File/Open. Shift-Load your app.
> You should now have Tools/Database utilities/Linked table manager.
> If not, your Access installation is bad; try on another machine.
>
> -Tom.
>[/color]

That's the thing: I can use Shift-Load on my other apps, but not this
one. I'm not sure if it's the password, or the linked table error
message that prevents this.

Is there any other way to get into design mode? Or any other way to
change the linked tables?

re: locked out of old app

This has been mentioned already but let me reiterate ....

If you create a clean database, you likely will be able to import all
objects, i.e., forms, macros, reports, et al.[color=blue]
>From the new database, from within the Forms\Macros\Reports modules,[/color]
simply right click, find your database name and import.

You may have tried this and had a password failure already, so pardon
me if I did not ascertain that from your post.

re: locked out of old app

sh_spamcatch@yahoo.com wrote:[color=blue]
> Salad wrote:
>[color=green]
>>sh_spamcatch@yahoo.com wrote:
>>
>>[color=darkred]
>>>I still can't open the database for editing by holding down the[/color][/color]
>
> Shift
>[color=green][color=darkred]
>>>key. Is there any other way?
>>>
>>>Thanks,
>>>
>>>S.H.
>>>[/color]
>>
>>Create a new database. See if you can import the objects into it.[/color]
>
>
> I can import the tables only. Since the tables are in a separate mdb,
> I can already access them directly. I need to change the location of
> the data source in the original application to point to that separate
> mdb. (My network gurus have seen fit to move all the servers without
> prior warning, so I'm scrambling to fix everything.)
>
> The basic question: how do I get to Linked Table Manager without the
> Tools option on the menu?
>
> Thanks,
>
> S.H.
>[/color]

Is it possible its not an MDB but an MDE?

Is there user-level security or is it a password on the MDB?

Is this a runtime version?

Can you get to the database window at all (Window/Unhide)? If you could
create a module you could run a command like
DoCmd.RunCommand acCmdLinkTables
or
DoCmd.RunCommand acCmdToolbarsCustomize

There is some information you have that we lack.

re: locked out of old app

Samantha wrote:[color=blue]
> This has been mentioned already but let me reiterate ....
>
> If you create a clean database, you likely will be able to import all
> objects, i.e., forms, macros, reports, et al.[color=green]
> >From the new database, from within the Forms\Macros\Reports modules,[/color]
> simply right click, find your database name and import.
>
> You may have tried this and had a password failure already, so pardon
> me if I did not ascertain that from your post.[/color]

Samantha,

Thank you! Something as simple as right click was all I needed. That
was the way to import everything, not just tables.
Ya learn something new every day. Again, thank you.

S.H.