Link to home
Start Free TrialLog in
Avatar of miziri
miziri

asked on

Ms-access 2003 to MS2007

Hi,
I have design file ms access in 2003 and i try to run run in ms access 2007 it did not work why?
I need some tell reason?is there big chnage ?

betwwen 2003 and 2007
Avatar of lee555J5
lee555J5
Flag of United States of America image

There could be many reasons.
One thing that got me:
I was using ADODB stuff in 2003, but the ADODB library 'Microsoft ActiveX Data Objects x.x Library' is NOT checked by default in 2007 in the VBA IDE under Tools | References.... Once I added the reference (2.8, actually), everything in my code that needed that reference worked correctly.
This is just an example--it could be many things. Can you provide more information--where it fails, how it fails, error messages, etc.?
Lee
Avatar of miziri
miziri

ASKER

Hi Lee555J5:
many thx for you,
I have made page onclick in that page the form load,so when I click on it nothing happen as it no code or event inside that page,

ur advise
Avatar of Helen Feddema
Security may be set too high for macros (VBA code) to run.  Check your Macro Security settings as follows:
Office button, Access Options button, Trust Center in left pane, Trust Center Settings button, Macro Settings.  
Change to a lower setting if necessary, then restart Access.
I am attaching a document with some items that typically need updating when upgrading to a higher version of Access (especially one that was originally created years ago).
Updating-a-Database.doc
Avatar of miziri

ASKER

Hi Helen,
  It means is i want share databse betwwen many user with differnt version like 2003,and 2007 it will not work,
i have to upgrade my databse all to same version

is that correct!
thx
ASKER CERTIFIED SOLUTION
Avatar of lee555J5
lee555J5
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial