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
miziriAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lee555J5Commented:
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
0
miziriAuthor Commented:
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
0
Helen FeddemaCommented:
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.
0
Webinar: Miercom Evaluates Wi-Fi Security

It's not just about Wi-Fi connectivity anymore. A wireless security breach can cost your business large amounts of time, trouble, and expense. Plus, hear first-hand from Miercom how WatchGuard's Wi-Fi security stacks up against the competition in our upcoming webinar!

Helen FeddemaCommented:
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
0
miziriAuthor Commented:
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
0
lee555J5Commented:
If you convert your db to Access 2007 so its extension is .accdb, only people running Access 2007 can open/use it. People still at 2003 or before CANNOT open it.
If you leave the db as a 2003 db so its extension is .mdb, people running 2003 or 2007 can open/use it.
Lee
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.