Access "Invalid Argument"

[JVID720]

My access DB grew and now I can't open it. I get the error "Invalid Argument".

Any ideas on how I can open it so I can shrink it?

I tried compacting it... same error
I tried creating a new DB to export certain tables... same error

Help please

JV
Soli deo Gloria

 

[ranman256]

"Invalid Argument" is not a db error, something in a form or code is causing it.

hold the shift key down then open the db, keeping it down.
do you still get the error?
do you normally have a form open upon start?

 

[JVID720]

I held it down and still there. No form just a bunch of data tables and queries.

Thanks in advance,

JV

 

[Norie]

Any expressions in any of the queries?

 

[Micron]

AllowBypassKey property may be set to false. When you get to the point where you can see the tables, queries, etc., you could open any module in the vb editor, type Ctrl+F (find) and paste AllowBypassKey into the dialog, choose 'current project' and click 'Find Next'. If you find this term, keep clicking 'find next' while checking the code to see how it's being set. Alternately, you could simply copy and use the code from here MS Access 2003: Re-enable the Shift key when logging into a secure database and follow the directions on how to employ it. You will likely have to step through any startup code to find the problem and fix it. It is not clear if you don't see a form on opening because there is a problem, or if you just aren't supposed to. You may have to look at the design options to see if there is supposed to be a form opening on startup.

 

[Micron]

False alaram. Thought I made a pasting boo-boo. No changes.