Access 2003 problem with Trim and Format$ functions after moving Database to new computer with Windows 7
Posted on 2013-01-05
Got a new computer 64 bit with Window 7 bit Home Premium. Installed Office 2003 Professional and made sure all of the updates were applied. Moved my database file (which was created in 97 and converted to 2000 and finally to 2003). The current database runs on a windows XP machine with Office 2003.
On the new PC, the database will open and process correctly but whenever the code utilizes a TRIM or FORMAT$ functon it gives you and error and stops. I don't convert things very often but I sorta recall when I converted to Office 2003 back when I had to do somethng with the MSJET40.dll program and then everything started to work correctly. I do have a the MSJET40.dll module version 4.0.9756.0 created 7-13-09 in 2 directories. Windows\sysWOW64 and Windows\Winsxs\X86_microsoft-windows-M..-components-jetcore......... . I have also tried to see if I have any missing references in my database and I can't find anything that says something is missing.
Appreciate any help - hope this is not a question asked before but in just a different format.