Update won't run w/Access 07

[jim]

My company just went through a conversion. I rewrote all the database
software to satisfy managements requirements. Everything works fine on my
computer, which has Office 2003 but on one user's machine very little works.
She has Office 2007 installed. Previously all the objects worked on her
machine but after the conversion just one object works. I refernced
something new, DAO 3.6 Object Library to use in some programming. All
programming was developed on my computer with Access 03. Do I have to
recompile or convert something on the user's computer to mesh with Access 07?
TIA

 

[Tom Wickerath]

Hi Jim,

You should ensure that there are no references marked as "Missing", when you
examine the references using the PC with Access 2007. If you see any missing
references, you must first correct this situation:

Solving Problems with Library References (Allen Browne)

http://allenbrowne.com/ser-38.html



Access Reference Problems (Doug Steele)
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html



With the Visual Basic Editor still open, make sure that any VBA code compiles
without an error.

Also, in Access 2007, if there is any VBA code (which there likely is, if you
developed using A2003), then you should run the application in a Trusted folder:

Dealing with the Trust Center (Access 2007 only)

http://www.accessmvp.com/TWickerath/articles/trust.htm





Tom Wickerath

Microsoft Access MVP

http://www.accessmvp.com/TWickerath

__________________________________________________


My company just went through a conversion. I rewrote all the database
software to satisfy managements requirements. Everything works fine on my
computer, which has Office 2003 but on one user's machine very little works.
She has Office 2007 installed. Previously all the objects worked on her
machine but after the conversion just one object works. I refernced
something new, DAO 3.6 Object Library to use in some programming. All
programming was developed on my computer with Access 03. Do I have to
recompile or convert something on the user's computer to mesh with Access 07?
TIA