Access 2010 is a disaster

[DaveJJ]

I am working with Access 2010 on Win7 Ultimate. I am having to
constantly repair and compress my database as the functions and sub-
procedures keep breaking. The coding is very simple so there is no
reason for this.

Also the Microsoft office built-in online help is useless, almost
every inquiry turns up with "not found". I have to use Google to find
basic help topics. For example looking for help topics on "object
dependencies" turned up "not found"

What the hell are Microsoft thinking?

 

[David-W-Fenton]

m:

I am working with Access 2010 on Win7 Ultimate. I am having to
constantly repair and compress my database as the functions and
sub- procedures keep breaking. The coding is very simple so there
is no reason for this.

Is is split into front end/back end?

Have you decompiled recently?

Do you have COMPILE ON DEMAND turned OFF?

Do you compile regularly?

Do you have OPTION EXPLICIT in all your modules?

Have you tried creating a new blank database and importing
everything into it?

Also the Microsoft office built-in online help is useless, almost
every inquiry turns up with "not found". I have to use Google to
find basic help topics. For example looking for help topics on
"object dependencies" turned up "not found"

Turn off the OFFLINE help and make sure it uses the local help -- I
don't have 2010 on this PC so can't give you exact instructions, but
this is something Albert Kallal has been telling people to do, and
he works all the time in A2010. I always do that in any copy of
Access, since the online help is almost always completely useless.

 

[DaveJJ]

Is is split into front end/back end?

Have you decompiled recently?

Do you have COMPILE ON DEMAND turned OFF?

Do you compile regularly?

Do you have OPTION EXPLICIT in all your modules?

Have you tried creating a new blank database and importing
everything into it?


Turn off the OFFLINE help and make sure it uses the local help -- I
don't have 2010 on this PC so can't give you exact instructions, but
this is something Albert Kallal has been telling people to do, and
he works all the time in A2010. I always do that in any copy of
Access, since the online help is almost always completely useless.

There is no option to turn off online help as far as I can see and no
option called "Compile on demand"

 

[David-W-Fenton]

m:

There is no option to turn off online help as far as I can see and
no option called "Compile on demand"

When I open a database in A2007 and hit F1, I get a help window. At
the bottom right of the window is a button that indicates the
ONLINE/OFFLINE mode for Help. Mine originally said OFFLINE, and when
I clicked it, I saw these options:

- Show content from Office Online
- Show content only from this computer

I believe the default is to use Office Online, which would mean your
button likely says CONNECTED TO OFFICE ONLINE. Click the button and
choose the second choice and see if you get better answers from
Help.

For A2003, if you open the help, there is a link in the Task Pane
for ONLINE CONTENT SETTINGS, which are pretty much self-explanatory.
The UI in A2003 and A2007 is not exactly the same, but the
functionality basically is. And both default to using Online
content, and I always turn that OFF, not because I'm not connected
to the Internet, but because the Online content is USELESS.

COMPILE ON DEMAND is an option in the VBE (since it applies to VBA
code). So, in the VBE, on the TOOLS menu, choose OPTIONS and on the
GENERAL tab, uncheck COMPILE ON DEMAND. This works identically in
A2007 and A2003.

 

[DaveJJ]

Thank you very much!

When I open a database in A2007 and hit F1, I get a help window. At
the  bottom right of the window is a button that indicates the
ONLINE/OFFLINE mode for Help. Mine originally said OFFLINE, and when
I clicked it, I saw these options:

- Show content from Office Online
- Show content only from this computer

I believe the default is to use Office Online, which would mean your
button likely says CONNECTED TO OFFICE ONLINE. Click the button and
choose the second choice and see if you get better answers from
Help.

For A2003, if you open the help, there is a link in the Task Pane
for ONLINE CONTENT SETTINGS, which are pretty much self-explanatory.
The UI in A2003 and A2007 is not exactly the same, but the
functionality basically is. And both default to using Online
content, and I always turn that OFF, not because I'm not connected
to the Internet, but because the Online content is USELESS.

COMPILE ON DEMAND is an option in the VBE (since it applies to VBA
code). So, in the VBE, on the TOOLS menu, choose OPTIONS and on the
GENERAL tab, uncheck COMPILE ON DEMAND. This works identically in
A2007 and A2003.