A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

error when opening .accdb file



 
 
Thread Tools Display Modes
  #1  
Old April 19th, 2010, 11:04 PM posted to microsoft.public.access
joewb7
external usenet poster
 
Posts: 4
Default error when opening .accdb file

I don't think this is a new issue but I can't seem to find the resolution...
I get an error when opening my Access 2007 formatted database stating that
the file could not be found, though at the same time the file opens
successfully.

-- Error is intermittent. On occasions where the error does not occur, the
file opens normally (I have never had an occasion where the file did not open
at all)
-- I have only seen the error happen when I have a 'Display Form' set in the
Application Options for the 'Current Database'
-- The database contains macros, VBA modules etc. that all work normally
once I acknowledge the error and accept macros
-- The file was originally created in Access 2003 on XP. Never saw the error
until modifications were made to the 2003 version in Access 2007. I have
since converted the file to 2007 hoping to lose the error in the process, but
with no luck.

Hope this all makes since. I am currently running Windows Vista and using
Access 2007.

--
Joe
  #2  
Old April 20th, 2010, 12:15 AM posted to microsoft.public.access
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default error when opening .accdb file

Have you made a backup copy and run Compact & Repair?

(more difficult ... have you made a backup copy and launched it using the
/Decompile flag?)

(about as difficult ... have you created a new empty db and imported all the
pieces?)

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


"joewb7" wrote in message
...
I don't think this is a new issue but I can't seem to find the
resolution...
I get an error when opening my Access 2007 formatted database stating that
the file could not be found, though at the same time the file opens
successfully.

-- Error is intermittent. On occasions where the error does not occur, the
file opens normally (I have never had an occasion where the file did not
open
at all)
-- I have only seen the error happen when I have a 'Display Form' set in
the
Application Options for the 'Current Database'
-- The database contains macros, VBA modules etc. that all work normally
once I acknowledge the error and accept macros
-- The file was originally created in Access 2003 on XP. Never saw the
error
until modifications were made to the 2003 version in Access 2007. I have
since converted the file to 2007 hoping to lose the error in the process,
but
with no luck.

Hope this all makes since. I am currently running Windows Vista and using
Access 2007.

--
Joe



  #3  
Old April 20th, 2010, 09:14 PM posted to microsoft.public.access
joewb7
external usenet poster
 
Posts: 4
Default error when opening .accdb file

Thanks for the response Jeff,

I've run compact & repair without any luck.
I'm not familiar with using the \Decompile flag but I have created a new
database and slowly imported pieces of the database until I started seeing
the same behavior.

I started with the 'welcome' form that is set to come up when the database
opens & everything worked fine. I then added my login form, macros, modules,
and tables (both linked and embedded) without anything happening. it wasn't
until I started loading more of the remaining forms that I seemed to reach a
'breaking point' (when 8 of the forms were loaded). Playing with it I haven't
been able to nail down a single form that appears to be causing the problem
(I've got 24 forms in the complete database). I also tried importing the
entire database into a new file in one shot and the problem keeps coming
back.

Somewhere along the line I do have to include an additional library file to
get all the modules working again (Microsoft Office 12.0 Object Library) but
I haven't seen any evidence that turning this on caused any issues either.

When I pieced the database together into a new one, the file size was just
3.5 MB when the behavior started again. the full database import turns out to
be ~ 6MB so I don't believe file size should be an issue.

Other things to note: When a session of Access is already open and I double
click to open the database in a second session of Access, it never gives me
the error. It also never happens if I use the shift key (bypass) as I open
the database or if I set options to have no form to display on opening. Also
never get the error the first time I open after a compact & repair (but then
reappears on the second attempt).

Any other ideas? How do I use the \Decompile flag?

--
Joe


"Jeff Boyce" wrote:

Have you made a backup copy and run Compact & Repair?

(more difficult ... have you made a backup copy and launched it using the
/Decompile flag?)

(about as difficult ... have you created a new empty db and imported all the
pieces?)

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


"joewb7" wrote in message
...
I don't think this is a new issue but I can't seem to find the
resolution...
I get an error when opening my Access 2007 formatted database stating that
the file could not be found, though at the same time the file opens
successfully.

-- Error is intermittent. On occasions where the error does not occur, the
file opens normally (I have never had an occasion where the file did not
open
at all)
-- I have only seen the error happen when I have a 'Display Form' set in
the
Application Options for the 'Current Database'
-- The database contains macros, VBA modules etc. that all work normally
once I acknowledge the error and accept macros
-- The file was originally created in Access 2003 on XP. Never saw the
error
until modifications were made to the 2003 version in Access 2007. I have
since converted the file to 2007 hoping to lose the error in the process,
but
with no luck.

Hope this all makes since. I am currently running Windows Vista and using
Access 2007.

--
Joe



.

  #4  
Old April 20th, 2010, 09:16 PM posted to microsoft.public.access
joewb7
external usenet poster
 
Posts: 4
Default error when opening .accdb file

Thanks for the response Jeff,

I've run compact & repair without any luck.
I'm not familiar with using the \Decompile flag but I have created a new
database and slowly imported pieces of the database until I started seeing
the same behavior.

I started with the 'welcome' form that is set to come up when the database
opens & everything worked fine. I then added my login form, macros, modules,
and tables (both linked and embedded) without anything happening. it wasn't
until I started loading more of the remaining forms that I seemed to reach a
'breaking point' (when 8 of the forms were loaded). Playing with it I haven't
been able to nail down a single form that appears to be causing the problem
(I've got 24 forms in the complete database). I also tried importing the
entire database into a new file in one shot and the problem keeps coming
back.

Somewhere along the line I do have to include an additional library file to
get all the modules working again (Microsoft Office 12.0 Object Library) but
I haven't seen any evidence that turning this on caused any issues either.

When I pieced the database together into a new one, the file size was just
3.5 MB when the behavior started again. the full database import turns out to
be ~ 6MB so I don't believe file size should be an issue.

Other things to note: When a session of Access is already open and I double
click to open the database in a second session of Access, it never gives me
the error. It also never happens if I use the shift key (bypass) as I open
the database or if I set options to have no form to display on opening. Also
never get the error the first time I open after a compact & repair (but then
reappears on the second attempt).

Any other ideas? How do I use the \Decompile flag?

--
Joe

"Jeff Boyce" wrote:

Have you made a backup copy and run Compact & Repair?

(more difficult ... have you made a backup copy and launched it using the
/Decompile flag?)

(about as difficult ... have you created a new empty db and imported all the
pieces?)

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


"joewb7" wrote in message
...
I don't think this is a new issue but I can't seem to find the
resolution...
I get an error when opening my Access 2007 formatted database stating that
the file could not be found, though at the same time the file opens
successfully.

-- Error is intermittent. On occasions where the error does not occur, the
file opens normally (I have never had an occasion where the file did not
open
at all)
-- I have only seen the error happen when I have a 'Display Form' set in
the
Application Options for the 'Current Database'
-- The database contains macros, VBA modules etc. that all work normally
once I acknowledge the error and accept macros
-- The file was originally created in Access 2003 on XP. Never saw the
error
until modifications were made to the 2003 version in Access 2007. I have
since converted the file to 2007 hoping to lose the error in the process,
but
with no luck.

Hope this all makes since. I am currently running Windows Vista and using
Access 2007.

--
Joe



.

  #5  
Old April 21st, 2010, 07:01 PM posted to microsoft.public.access
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default error when opening .accdb file

Try searching on-line for MS Access and \Decompile for more detailed
explanations.

What you're describing sounds like there's some form of subtle corruption.

If Compact & Repair, plus import to new db isn't catching it, the \Decompile
is pretty much the last step I know of before starting from scratch (i.e.,
importing what DOES work, then rebuilding whatever object(s) 'munge' the
db).

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"joewb7" wrote in message
...
Thanks for the response Jeff,

I've run compact & repair without any luck.
I'm not familiar with using the \Decompile flag but I have created a new
database and slowly imported pieces of the database until I started seeing
the same behavior.

I started with the 'welcome' form that is set to come up when the database
opens & everything worked fine. I then added my login form, macros,
modules,
and tables (both linked and embedded) without anything happening. it
wasn't
until I started loading more of the remaining forms that I seemed to reach
a
'breaking point' (when 8 of the forms were loaded). Playing with it I
haven't
been able to nail down a single form that appears to be causing the
problem
(I've got 24 forms in the complete database). I also tried importing the
entire database into a new file in one shot and the problem keeps coming
back.

Somewhere along the line I do have to include an additional library file
to
get all the modules working again (Microsoft Office 12.0 Object Library)
but
I haven't seen any evidence that turning this on caused any issues either.

When I pieced the database together into a new one, the file size was just
3.5 MB when the behavior started again. the full database import turns out
to
be ~ 6MB so I don't believe file size should be an issue.

Other things to note: When a session of Access is already open and I
double
click to open the database in a second session of Access, it never gives
me
the error. It also never happens if I use the shift key (bypass) as I open
the database or if I set options to have no form to display on opening.
Also
never get the error the first time I open after a compact & repair (but
then
reappears on the second attempt).

Any other ideas? How do I use the \Decompile flag?

--
Joe

"Jeff Boyce" wrote:

Have you made a backup copy and run Compact & Repair?

(more difficult ... have you made a backup copy and launched it using the
/Decompile flag?)

(about as difficult ... have you created a new empty db and imported all
the
pieces?)

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


"joewb7" wrote in message
...
I don't think this is a new issue but I can't seem to find the
resolution...
I get an error when opening my Access 2007 formatted database stating
that
the file could not be found, though at the same time the file opens
successfully.

-- Error is intermittent. On occasions where the error does not occur,
the
file opens normally (I have never had an occasion where the file did
not
open
at all)
-- I have only seen the error happen when I have a 'Display Form' set
in
the
Application Options for the 'Current Database'
-- The database contains macros, VBA modules etc. that all work
normally
once I acknowledge the error and accept macros
-- The file was originally created in Access 2003 on XP. Never saw the
error
until modifications were made to the 2003 version in Access 2007. I
have
since converted the file to 2007 hoping to lose the error in the
process,
but
with no luck.

Hope this all makes since. I am currently running Windows Vista and
using
Access 2007.

--
Joe



.



  #6  
Old April 21st, 2010, 11:28 PM posted to microsoft.public.access
joewb7
external usenet poster
 
Posts: 4
Default error when opening .accdb file

Thanks Jeff, unfortunately the \decompile flag didn't do anything for me.
guess I'm going to have to start from scratch.

--
Joe


"Jeff Boyce" wrote:

Try searching on-line for MS Access and \Decompile for more detailed
explanations.

What you're describing sounds like there's some form of subtle corruption.

If Compact & Repair, plus import to new db isn't catching it, the \Decompile
is pretty much the last step I know of before starting from scratch (i.e.,
importing what DOES work, then rebuilding whatever object(s) 'munge' the
db).

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"joewb7" wrote in message
...
Thanks for the response Jeff,

I've run compact & repair without any luck.
I'm not familiar with using the \Decompile flag but I have created a new
database and slowly imported pieces of the database until I started seeing
the same behavior.

I started with the 'welcome' form that is set to come up when the database
opens & everything worked fine. I then added my login form, macros,
modules,
and tables (both linked and embedded) without anything happening. it
wasn't
until I started loading more of the remaining forms that I seemed to reach
a
'breaking point' (when 8 of the forms were loaded). Playing with it I
haven't
been able to nail down a single form that appears to be causing the
problem
(I've got 24 forms in the complete database). I also tried importing the
entire database into a new file in one shot and the problem keeps coming
back.

Somewhere along the line I do have to include an additional library file
to
get all the modules working again (Microsoft Office 12.0 Object Library)
but
I haven't seen any evidence that turning this on caused any issues either.

When I pieced the database together into a new one, the file size was just
3.5 MB when the behavior started again. the full database import turns out
to
be ~ 6MB so I don't believe file size should be an issue.

Other things to note: When a session of Access is already open and I
double
click to open the database in a second session of Access, it never gives
me
the error. It also never happens if I use the shift key (bypass) as I open
the database or if I set options to have no form to display on opening.
Also
never get the error the first time I open after a compact & repair (but
then
reappears on the second attempt).

Any other ideas? How do I use the \Decompile flag?

--
Joe

"Jeff Boyce" wrote:

Have you made a backup copy and run Compact & Repair?

(more difficult ... have you made a backup copy and launched it using the
/Decompile flag?)

(about as difficult ... have you created a new empty db and imported all
the
pieces?)

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


"joewb7" wrote in message
...
I don't think this is a new issue but I can't seem to find the
resolution...
I get an error when opening my Access 2007 formatted database stating
that
the file could not be found, though at the same time the file opens
successfully.

-- Error is intermittent. On occasions where the error does not occur,
the
file opens normally (I have never had an occasion where the file did
not
open
at all)
-- I have only seen the error happen when I have a 'Display Form' set
in
the
Application Options for the 'Current Database'
-- The database contains macros, VBA modules etc. that all work
normally
once I acknowledge the error and accept macros
-- The file was originally created in Access 2003 on XP. Never saw the
error
until modifications were made to the 2003 version in Access 2007. I
have
since converted the file to 2007 hoping to lose the error in the
process,
but
with no luck.

Hope this all makes since. I am currently running Windows Vista and
using
Access 2007.

--
Joe


.



.

  #7  
Old April 22nd, 2010, 05:04 PM posted to microsoft.public.access
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default error when opening .accdb file

Keep checking back here -- perhaps one of the other newsgroup readers has
run across this and has a less drastic solution...

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"joewb7" wrote in message
...
Thanks Jeff, unfortunately the \decompile flag didn't do anything for me.
guess I'm going to have to start from scratch.

--
Joe


"Jeff Boyce" wrote:

Try searching on-line for MS Access and \Decompile for more detailed
explanations.

What you're describing sounds like there's some form of subtle
corruption.

If Compact & Repair, plus import to new db isn't catching it, the
\Decompile
is pretty much the last step I know of before starting from scratch
(i.e.,
importing what DOES work, then rebuilding whatever object(s) 'munge' the
db).

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"joewb7" wrote in message
...
Thanks for the response Jeff,

I've run compact & repair without any luck.
I'm not familiar with using the \Decompile flag but I have created a
new
database and slowly imported pieces of the database until I started
seeing
the same behavior.

I started with the 'welcome' form that is set to come up when the
database
opens & everything worked fine. I then added my login form, macros,
modules,
and tables (both linked and embedded) without anything happening. it
wasn't
until I started loading more of the remaining forms that I seemed to
reach
a
'breaking point' (when 8 of the forms were loaded). Playing with it I
haven't
been able to nail down a single form that appears to be causing the
problem
(I've got 24 forms in the complete database). I also tried importing
the
entire database into a new file in one shot and the problem keeps
coming
back.

Somewhere along the line I do have to include an additional library
file
to
get all the modules working again (Microsoft Office 12.0 Object
Library)
but
I haven't seen any evidence that turning this on caused any issues
either.

When I pieced the database together into a new one, the file size was
just
3.5 MB when the behavior started again. the full database import turns
out
to
be ~ 6MB so I don't believe file size should be an issue.

Other things to note: When a session of Access is already open and I
double
click to open the database in a second session of Access, it never
gives
me
the error. It also never happens if I use the shift key (bypass) as I
open
the database or if I set options to have no form to display on opening.
Also
never get the error the first time I open after a compact & repair (but
then
reappears on the second attempt).

Any other ideas? How do I use the \Decompile flag?

--
Joe

"Jeff Boyce" wrote:

Have you made a backup copy and run Compact & Repair?

(more difficult ... have you made a backup copy and launched it using
the
/Decompile flag?)

(about as difficult ... have you created a new empty db and imported
all
the
pieces?)

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services
mentioned
in this post. Mention and/or description of a product or service
herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with
no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


"joewb7" wrote in message
...
I don't think this is a new issue but I can't seem to find the
resolution...
I get an error when opening my Access 2007 formatted database
stating
that
the file could not be found, though at the same time the file opens
successfully.

-- Error is intermittent. On occasions where the error does not
occur,
the
file opens normally (I have never had an occasion where the file did
not
open
at all)
-- I have only seen the error happen when I have a 'Display Form'
set
in
the
Application Options for the 'Current Database'
-- The database contains macros, VBA modules etc. that all work
normally
once I acknowledge the error and accept macros
-- The file was originally created in Access 2003 on XP. Never saw
the
error
until modifications were made to the 2003 version in Access 2007. I
have
since converted the file to 2007 hoping to lose the error in the
process,
but
with no luck.

Hope this all makes since. I am currently running Windows Vista and
using
Access 2007.

--
Joe


.



.



 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.