I have an Access 2000 DB thats table content is based soley on Linked tables from a SQL2K DB. I have set up the System DSN information in ODBC (Windows XP Pro) to include all the login info etc etc. I have also tried File DSN just in case it was that.
Periodically though when running a report / query it asks for the login information again. Obvioulsy I can't give this out to the users cause 1. It is a breach of security and 2. It is unprofessional to have to expect users to do it.
Has anybody had a similar experience or does anybody have any ideas as to why this is happening?
Many Thanks
Periodically though when running a report / query it asks for the login information again. Obvioulsy I can't give this out to the users cause 1. It is a breach of security and 2. It is unprofessional to have to expect users to do it.
Has anybody had a similar experience or does anybody have any ideas as to why this is happening?
Many Thanks
