Geoff Convery
Registered User.
- Local time
- Yesterday, 20:22
- Joined
- Jul 21, 2006
- Messages
- 33
I have an Access front end to a SQL Server db one function of which is to provide an export to Excel using a query and the OutputTo method of DoCmd. This works perfectly in my development environment (WinXP, Access2003) but, when I implement it on my clients computers on the same corporate network but with the Access2003 replaced by Access2003 Runtime the resulting file is always empty.
Anyone got any ideas? I thought that it might be something missing from the Office installation on the client computers but I'm by no means sure.
Found it, it does work but they had some blank columns in the data which made the query fail to return any lines!!!
Anyone got any ideas? I thought that it might be something missing from the Office installation on the client computers but I'm by no means sure.
Found it, it does work but they had some blank columns in the data which made the query fail to return any lines!!!
Last edited:
