TransferSpreadsheet no longer works in Access 97.

[RayProud]

An Access97 database than has been in use for several years has suddenly developed a problem when running VBA code. The command 'DoCmd.TransferSpreadsheet' fails with the error message "3027 - Can't update database or object is read only". This command is creating an XLS file on the user's C drive so permissions is not an issue and the folders have write access.

The only thing that has changed is an update on user's PCs of a commercial software package which includes many DLLs and OCXs. I suspect this command is now incompatible with a particular DLL or OCX. I have proved conclusively that prior to this update the command worked okay.

Has anyone come across this problem and a solution please? A reinstall of Office97 did not resolve the problem. Any suggestions would be greatly appreciated.

Thanks,
Ray.

 

[RayProud]

I've found a resolution to this problem so I thought I'd share it with you just in case it helps anyone else.

The problem was the length of the filename being generated. It must not exceed 37 characters excluding ".XLS". If it does then that error is generated.

Phew! I can relax again.

Cheers,
Ray.