I have a 2007 database that has decided to crash whenever i try entering the
VBA environment either to run or edit it. This has come about from nothing
but prevents the database from running, or me making any corrections to
remedy it.
I've tried importing into a new DB but the offending forms will not import
and trying a save as into a new DB won't work since Access tells me that the
file is already in use (it is - but only by me trying to do a save as).
As usual this is a critical DB and the backups are painfully out of date so
i would appreciate any ideas on how to correct this one.

H

If this happens in a particluar database only, try a compact, decompile,
compact sequence. Details of these recovery steps:
http://allenbrowne.com/recover.html

If it happens in all databases but only started recently, have you installed
other software recently?

You may be able to import all but 1 or 2 bad forms into a new database. It
would then be possible to import the bad form(s) from a backup, so your data
is completely up to date and you may not have to redesign those forms from
scratch.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Humphrey" <(E-Mail Removed)> wrote in message
news:4A34C7FE-031C-4BD1-A663-(E-Mail Removed)...
>I have a 2007 database that has decided to crash whenever i try entering
>the
> VBA environment either to run or edit it. This has come about from
> nothing
> but prevents the database from running, or me making any corrections to
> remedy it.
> I've tried importing into a new DB but the offending forms will not import
> and trying a save as into a new DB won't work since Access tells me that
> the
> file is already in use (it is - but only by me trying to do a save as).
> As usual this is a critical DB and the backups are painfully out of date
> so
> i would appreciate any ideas on how to correct this one.
>
> H

Thanks for the response. To keep everyone in the loop I was able to get it
fixed by sending the offending database to a colleague who opened it and did
a Save As to a new filename. He then sent the DB back to me.
Strangely all has worked correctly since then.

I'm not advocating this in lieu of Allen's process below, but as a wise man
once said "If it's stupid and it works; it's not stupid". Thanks for your
help.

"Allen Browne" wrote:

> If this happens in a particluar database only, try a compact, decompile,
> compact sequence. Details of these recovery steps:
> http://allenbrowne.com/recover.html
>
> If it happens in all databases but only started recently, have you installed
> other software recently?
>
> You may be able to import all but 1 or 2 bad forms into a new database. It
> would then be possible to import the bad form(s) from a backup, so your data
> is completely up to date and you may not have to redesign those forms from
> scratch.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Humphrey" <(E-Mail Removed)> wrote in message
> news:4A34C7FE-031C-4BD1-A663-(E-Mail Removed)...
> >I have a 2007 database that has decided to crash whenever i try entering
> >the
> > VBA environment either to run or edit it. This has come about from
> > nothing
> > but prevents the database from running, or me making any corrections to
> > remedy it.
> > I've tried importing into a new DB but the offending forms will not import
> > and trying a save as into a new DB won't work since Access tells me that
> > the
> > file is already in use (it is - but only by me trying to do a save as).
> > As usual this is a critical DB and the backups are painfully out of date
> > so
> > i would appreciate any ideas on how to correct this one.
> >
> > H
>
>

=?Utf-8?B?SHVtcGhyZXk=?= <(E-Mail Removed)> wrote
in news:891D4DB9-56B3-4CAE-AEAC-(E-Mail Removed):

> To keep everyone in the loop I was able to get it
> fixed by sending the offending database to a colleague who opened
> it and did a Save As to a new filename. He then sent the DB back
> to me. Strangely all has worked correctly since then.

My copy of Access has a Save As menu item but it only allows me to
save a selected object under a different name.

I suspect your friend created a new file and imported the contents
of your problematic file, which is part of what Allen had suggested
you try.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

No, he did a Save As on the entire database; saving it as a new file. He's
not very au fait on the workings of Access so i talked him through the
process over the phone. When you choose Save As one of the options is to
save the database as a new 2007 DB, or a 2003 DB, etc. We simple chose 2007,
gave it a new name and returned it back to me.

"David W. Fenton" wrote:

> =?Utf-8?B?SHVtcGhyZXk=?= <(E-Mail Removed)> wrote
> in news:891D4DB9-56B3-4CAE-AEAC-(E-Mail Removed):
>
> > To keep everyone in the loop I was able to get it
> > fixed by sending the offending database to a colleague who opened
> > it and did a Save As to a new filename. He then sent the DB back
> > to me. Strangely all has worked correctly since then.
>
> My copy of Access has a Save As menu item but it only allows me to
> save a selected object under a different name.
>
> I suspect your friend created a new file and imported the contents
> of your problematic file, which is part of what Allen had suggested
> you try.
>
> --
> David W. Fenton http://www.dfenton.com/
> usenet at dfenton dot com http://www.dfenton.com/DFA/
>

From 2007 to 2007. I need that for the SharePoint functionality

"AccessVandal via AccessMonster.com" wrote:

> My question might not be relevant.
>
> When you created a new database, in the Access Options – Popular – Creating
> databases – Default file format, is the format set to Access 2007 or 2002-
> 2003 or 2000?
>
> If the new database is created using older format, you may have problems
> importing objects into 2007 format but you would not have problems importing
> older formats into 2007 format. (Same as for 2000 and 2002-2003.) 2007 wizard
> is not so smart to warn you if you make a mistake by renaming the file name
> and the file extension in the text field. You have to select the browser and
> in the file menu, select the combo box for the correct format, not just by
> changing the file extension.
>
> It will prompt a message if you attempt to import 2007 objects into older
> versions. Did a message appear?
>
> Humphrey wrote:
> >No, he did a Save As on the entire database; saving it as a new file. He's
> >not very au fait on the workings of Access so i talked him through the
> >process over the phone. When you choose Save As one of the options is to
> >save the database as a new 2007 DB, or a 2003 DB, etc. We simple chose 2007,
> >gave it a new name and returned it back to me.
>
> --
> Please Rate the posting if helps you.
>
> Message posted via http://www.accessmonster.com
>
>

=?Utf-8?B?SHVtcGhyZXk=?= <(E-Mail Removed)> wrote
in news:3269B8D7-C705-4823-A472-(E-Mail Removed):

> "David W. Fenton" wrote:
>
>> =?Utf-8?B?SHVtcGhyZXk=?= <(E-Mail Removed)>
>> wrote in news:891D4DB9-56B3-4CAE-AEAC-(E-Mail Removed):
>>
>> > To keep everyone in the loop I was able to get it
>> > fixed by sending the offending database to a colleague who
>> > opened it and did a Save As to a new filename. He then sent
>> > the DB back to me. Strangely all has worked correctly since
>> > then.
>>
>> My copy of Access has a Save As menu item but it only allows me
>> to save a selected object under a different name.
>>
>> I suspect your friend created a new file and imported the
>> contents of your problematic file, which is part of what Allen
>> had suggested you try.
>
> No, he did a Save As on the entire database; saving it as a new
> file.

No, he didn't. There is no such functionality in Access, nor has
there ever been.

> He's
> not very au fait on the workings of Access so i talked him through
> the process over the phone. When you choose Save As one of the
> options is to save the database as a new 2007 DB, or a 2003 DB,
> etc. We simple chose 2007, gave it a new name and returned it
> back to me.

That is not SAVE AS -- that's TOOLS -> DATABASE UTILITIES -> CONVERT
DATABASE.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

I don't know how else to say it but you are WRONG. I'm looking at the screen
now. Click on the Office icon (or whatever its called top left of the
screen) choose Save As, and you are presented with five options.

Save The Current Database Object
* Save Object As
* Find Add-Ins for other file formats

Save The Database in Another Format
* Access 2007 Database
* Access 2002-2003 Database
* Access 2000 Database

I don't know how i can be more explicit than that. I know what I did; I was
there. I've been doing this stuff for a lot of years and certainly know how
to find my way around the software. Please get a copy of Access 2007 and
check it out for yourself. Do you want me to send you screen shots directly
or are you finally convinced?

H



"David W. Fenton" wrote:

> =?Utf-8?B?SHVtcGhyZXk=?= <(E-Mail Removed)> wrote
> in news:3269B8D7-C705-4823-A472-(E-Mail Removed):
>
> > "David W. Fenton" wrote:
> >
> >> =?Utf-8?B?SHVtcGhyZXk=?= <(E-Mail Removed)>
> >> wrote in news:891D4DB9-56B3-4CAE-AEAC-(E-Mail Removed):
> >>
> >> > To keep everyone in the loop I was able to get it
> >> > fixed by sending the offending database to a colleague who
> >> > opened it and did a Save As to a new filename. He then sent
> >> > the DB back to me. Strangely all has worked correctly since
> >> > then.
> >>
> >> My copy of Access has a Save As menu item but it only allows me
> >> to save a selected object under a different name.
> >>
> >> I suspect your friend created a new file and imported the
> >> contents of your problematic file, which is part of what Allen
> >> had suggested you try.
> >
> > No, he did a Save As on the entire database; saving it as a new
> > file.
>
> No, he didn't. There is no such functionality in Access, nor has
> there ever been.
>
> > He's
> > not very au fait on the workings of Access so i talked him through
> > the process over the phone. When you choose Save As one of the
> > options is to save the database as a new 2007 DB, or a 2003 DB,
> > etc. We simple chose 2007, gave it a new name and returned it
> > back to me.
>
> That is not SAVE AS -- that's TOOLS -> DATABASE UTILITIES -> CONVERT
> DATABASE.
>
> --
> David W. Fenton http://www.dfenton.com/
> usenet at dfenton dot com http://www.dfenton.com/DFA/
>

I believe this is new to Access 2007.

David is very knowledgeable about previous versions, but I'm not sure he's
an A2007 user.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Humphrey" <(E-Mail Removed)> wrote in message
news:0A96EA66-5F7C-46C2-838D-(E-Mail Removed)...
>I don't know how else to say it but you are WRONG. I'm looking at the
>screen
> now. Click on the Office icon (or whatever its called top left of the
> screen) choose Save As, and you are presented with five options.
>
> Save The Current Database Object
> * Save Object As
> * Find Add-Ins for other file formats
>
> Save The Database in Another Format
> * Access 2007 Database
> * Access 2002-2003 Database
> * Access 2000 Database
>
> I don't know how i can be more explicit than that. I know what I did; I
> was
> there. I've been doing this stuff for a lot of years and certainly know
> how
> to find my way around the software. Please get a copy of Access 2007 and
> check it out for yourself. Do you want me to send you screen shots
> directly
> or are you finally convinced?
>
> H
>
>
>
> "David W. Fenton" wrote:
>
>> =?Utf-8?B?SHVtcGhyZXk=?= <(E-Mail Removed)> wrote
>> in news:3269B8D7-C705-4823-A472-(E-Mail Removed):
>>
>> > "David W. Fenton" wrote:
>> >
>> >> =?Utf-8?B?SHVtcGhyZXk=?= <(E-Mail Removed)>
>> >> wrote in news:891D4DB9-56B3-4CAE-AEAC-(E-Mail Removed):
>> >>
>> >> > To keep everyone in the loop I was able to get it
>> >> > fixed by sending the offending database to a colleague who
>> >> > opened it and did a Save As to a new filename. He then sent
>> >> > the DB back to me. Strangely all has worked correctly since
>> >> > then.
>> >>
>> >> My copy of Access has a Save As menu item but it only allows me
>> >> to save a selected object under a different name.
>> >>
>> >> I suspect your friend created a new file and imported the
>> >> contents of your problematic file, which is part of what Allen
>> >> had suggested you try.
>> >
>> > No, he did a Save As on the entire database; saving it as a new
>> > file.
>>
>> No, he didn't. There is no such functionality in Access, nor has
>> there ever been.
>>
>> > He's
>> > not very au fait on the workings of Access so i talked him through
>> > the process over the phone. When you choose Save As one of the
>> > options is to save the database as a new 2007 DB, or a 2003 DB,
>> > etc. We simple chose 2007, gave it a new name and returned it
>> > back to me.
>>
>> That is not SAVE AS -- that's TOOLS -> DATABASE UTILITIES -> CONVERT
>> DATABASE.
>>
>> --
>> David W. Fenton http://www.dfenton.com/
>> usenet at dfenton dot com http://www.dfenton.com/DFA/
>>

"Allen Browne" <(E-Mail Removed)> wrote in
news:(E-Mail Removed):

> David is very knowledgeable about previous versions, but I'm not
> sure he's an A2007 user.

I missed the A2007 part of this somewhere along the line.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/