access and vista problem

[skamanchero]

Hi, i have a problem with an access database, well 2 problems. first is i don't know much about databases. the second is at work we installed 3 computers in an office with windows vista o/s. they then had a company come in and install software for their business. They were using office 2000 access database on xp previously. The company installing their software copied the access 2000 database to the vista target machines, i believe they may have converted the database to access 2003 version when doing this. The problem is the database doesn't work and they have called us back in to sort out the problem. Well we installed service packs, fixes, patches etc and googled a lot but found no simlar problems or solutions, in short we are stumped. I think the database is compiled into an app or something with switchboard etc, which i think means i can't access it? anyway it opens up with a logon form to get into DB, i enter the username and password and click ok and it gives a message saying:

"the expression on click you entered as the event property setting produced the following error"

it goes on to say there may be problem with an "event,function or macro"

on vista with office 2003 it lists several possible causes which i havent access to right now.

i have now tried it on my own pc with xp pro and office 2007 and it basically gives the same message as above but the list of possible causes is reduced to this one:

"This error occurs when an event has failed to run because Microsoft Office Access cannot evaluate the location of the logic for the event. For example, if the OnOpen property of a form is set to =[Field], this error occurs because Access expects a macro or event name to run when the event is fired"

Can anyone explain or point me in the right direction of where to get a solution. I think this is something for a programmer to solve and possibly something that the original database programmers should be looking at rather than me. am i right?

cheers all!

 

[boblarson]

First thing to check is that you need to set Microsoft Access (C:\Program Files\Microsoft Office\MSAccess.exe) as Run As Administrator when used on Vista machines. If you have multiple versions installed, each MSAccess.exe file that exists and it can be in something like C:\Program Files\Microsoft Office\Office10\MSAccess.exe need to be set to run as administrator. To do so, on each machine you would need to go find those files and right-click on them and select the Compatibility tab and check the Run As Administrator box.


Then, you may also have some reference issues that we might have to address if that doesn't take care of it, but that is something that does need to be done on Vista. You can also avoid the security messages by going into Access 2007 and using the big Windows Logo in a circle to drop down the menu, you can go to Access Options and then go to set the Trusted Locations.

 

[Zigzag]

Maybe something Silly

Hi,

This might sound really lame But...

When the DB was installed did it instal itself (self extraction) or was it just coppied from a disc or similar?

If it installed itself maybe it has been installed in a location that is read only?

What size is the DB, can it be posted on here?

 

[skamanchero]

Hi thanks for the replies. unfortunately i cant try the solution on vista until tomorrow. I have tried it on xp with office 2007 now and it still gives the same response.

it was just copied over from a disk to the target computer.

 

[skamanchero]

Hi again, i should say that when the logon form comes up it doesn't matter if user and password are entered or correct as it never goes to check it seems to crash on the onclick of the ok button.

 

[skamanchero]

hi, well i tried run as administrator this morning on vista and it just came up with the same response. Is there anything else i can do?

 

[Dennisk]

In my experience of converting Access97/2000 to 2003 (done about 80-90 so far), just opening the db with 2003 and selecting convert does not work correctly as I think it does not update the references.

To convert open Access 2003 join the correct workgroup then select convert and go from there.