problems in access after upgrading word/excel

[BPBP]

Hi,

Have anyone of you encountered problem with access that is running on 2003 after you have upgraded MS office basic 2007, which is only just upgrading excel and word?

I do not really see how would word/excel affect access which was untouched? How would you rectify it?

thanks,
BP

 

[HiTechCoach]

it would really help to know what "problem" you are having.

Have anyone of you encountered problem with access that is running on 2003 after you have upgraded MS office basic 2007, ...

It sure can. If you are using early binding in some automation code.

Have you check the references?

 

[BPBP]

I had some simple code in forms that checks if all required fields are filled and then performs some arithmetric and updating some other tables based on the entries in the field in the form before update.

another error i had was "unreserved error" when i tried to save/exit a form. Sometimes i get "run-time" error too.

Anyhow i installed 2007 Access and ran the database on it, it works fine now. However i noted i lost user level security.

Is it possible to implement some form of user level security if i want to restrict users from entering certain forms? (without any additional software like sql-server etc...)

 

[HiTechCoach]

I had some simple code in forms that checks if all required fields are filled and then performs some arithmetric and updating some other tables based on the entries in the field in the form before update.

another error i had was "unreserved error" when i tried to save/exit a form. Sometimes i get "run-time" error too.

Anyhow i installed 2007 Access and ran the database on it, it works fine now. However i noted i lost user level security.

I use Access 2003 with Office 2007 apps without any issues.

Have you checked the VBA reference to see if there are ones set to the 2003 libraries?

Have you trying compiling the VBA code or making an MDE?

Is it possible to implement some form of user level security if i want to restrict users from entering certain forms? (without any additional software like sql-server etc...)

Yes it is possible. Part of the reason Microsoft dropped User Level Security (ULS) in 2007 was that most developers write their own version of ULS with VBA.

Would you like to see an example?

 

[BPBP]

Yes it is possible. Part of the reason Microsoft dropped User Level Security (ULS) in 2007 was that most developers write their own version of ULS with VBA.

Would you like to see an example?

Yes please show me an example. Thanks.

 

[HiTechCoach]

Yes please show me an example. Thanks.

Check out this:
Boiler Plate Ddatabase