bluetongue
Registered User.
- Local time
- Tomorrow, 05:54
- Joined
- Jul 15, 2004
- Messages
- 34
I have a database in Access 2003 format with the backend on a network drive and the frontend on individual PCs.
I converted the backend to 2007 format. then converted the frontend and relinked all the tables. The code behind the forms no longer works giving a 'File not Found' error when controls on the form are clicked. The form code is visible in the VBA editor but seems no longer linked to the controls.
There were network drive problems before and after the conversion giving a "Could not send the command to the program" error message. I repeated the conversion on my own PC using backup copies on my own PC and relinked before the conversion, but with the same result. This leads me to believe the problem is with the conversion and not with the network drive.
Fortunately, I have backups and can restore to a working set of databases about 5 days old.
The message which appears after conversion seems to indicate that you cannot link tables between access 2003 and 2007 versions.
I also on occasions received a "Cannot convert attached files" message - could this be due to memo field in one of the tables?
I would be grateful for any assistance.
I converted the backend to 2007 format. then converted the frontend and relinked all the tables. The code behind the forms no longer works giving a 'File not Found' error when controls on the form are clicked. The form code is visible in the VBA editor but seems no longer linked to the controls.
There were network drive problems before and after the conversion giving a "Could not send the command to the program" error message. I repeated the conversion on my own PC using backup copies on my own PC and relinked before the conversion, but with the same result. This leads me to believe the problem is with the conversion and not with the network drive.
Fortunately, I have backups and can restore to a working set of databases about 5 days old.
The message which appears after conversion seems to indicate that you cannot link tables between access 2003 and 2007 versions.
I also on occasions received a "Cannot convert attached files" message - could this be due to memo field in one of the tables?
I would be grateful for any assistance.