paulS30berks
Registered User.
- Local time
- Today, 16:17
- Joined
- Jul 19, 2005
- Messages
- 116
I have a SQL server 2000 db and using MS access 2003 as a front end.
Report maintenance is handled within a seperate directory. We then release the .mde's to a directory from where Users have access.
Reports all work fine until we release an .mde. Some users experience an ODBC Connection Failed error. Each user is set up with an ODBC connection to the server and we are constantly having to re-export tables + setting up Primary keys for various tables each time.
Has anyone else experienced this problem? Any help would be great.
Thanks
Report maintenance is handled within a seperate directory. We then release the .mde's to a directory from where Users have access.
Reports all work fine until we release an .mde. Some users experience an ODBC Connection Failed error. Each user is set up with an ODBC connection to the server and we are constantly having to re-export tables + setting up Primary keys for various tables each time.
Has anyone else experienced this problem? Any help would be great.
Thanks
