MS Access 2007 Office Button

[Dave]

I have an issue with a Access program that was written in Access
2000. I have tried to move it into Access 2007 and run the
application with not much success. I didn't write the original DB but
most of it appears to be in VB code. I have seen in this group that
you need to move it to a Trusted Location by clicking on the Office
Button then clicking on Access Options. When I click on the Office
Button all I get is close application, am I missing something here?

Like I said most of the application will run but it misses alot of
data items. Anybody have any tips?

Thanks in advance

Dave

 

[Albert D. Kallal]

You don't have to use a trusted location, just change the code "macro"
settings to low...

So, don't launch or open that application....

Just launch a2007, then go:

office button->access options (lower right corner)

then on left pane, select Trust center

on right side...click button Trust center settings

then from left nav pane select macro settings.

now choose bottom option "enable all macros"

Doing the above will eliminate the need for a trusted location....

 

[Dave]

You don't have to use a trusted location, just change the code "macro"
settings to low...

So, don't launch or open that application....

Just launch a2007, then go:

office button->access options (lower right corner)

then on left pane, select Trust center

on right side...click button Trust center settings

then from left nav pane select macro settings.

now choose bottom option "enable all macros"

Doing the above will eliminate the need for a trusted location....

Thanks for the quick reply, that stopped the issue of the annoying
Issue with opening the database but I’m still not getting all the data
I should. From my limited experience using Access 2003, all the data
should be contained within application. However when I try to access
the clients section of the DB I am able to search and retrieve the
general client information. However, when I select view payments off
of that page, I get no data at all and I know that there should be
data there.

I have seen several posts here that refered to de-compling and
recompling the app under Access 2007. I'm wondering if that should be
my next move.

Any ideas or suggestions are appreciated..

Dave

 

[Albert D. Kallal]

I’m still not getting all the data

I should.

You have to explain more details as to what you mean by the above...

when I select view payments off

of that page, I get no data at all and I know that there should be
data there.

Is the above using code, or simply sql quires to retrieve the data? Is
perhaps system date settings effecting this?

refered to de-compling

You can try that, but really doubt that is the issue. Does the existing code
compile now?

Are you using mdb format, or have you converted to accDB (it not, try
converting to accDB format and see if that helps).

If you want, you can try the de-compile idea, but do make a copy first.

here info on de-compile:
http://www.mvps.org/access/bugs/bugs0008.htm

Without additional info it hard to "guess" what the problem here is. You
have to start narrowing down what that data is not being returned. If the
data relies on code to grab + process the data, then look at that specific
code first. If not using code, then find out how the criteria is being
generated or setup to restrict the data. As mentioned, if there things like
date fields involved, that is the FIRST area I would concentrate my efforts
in that area.