Results 1 to 2 of 2
  1. #1
    torunsu is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2011
    Posts
    9

    Access application always prompts for ODBC data source on open

    Hi!



    I have an Access 2003 application with some tables linked from SQL Server 2005. Recently, it has started prompting for Data Source on open. Does anybody have a clue why?

  2. #2
    torunsu is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2011
    Posts
    9
    After looking some more, I discovered that this happens when the following query is run:
    "SELECT SYSTEM_USER AS <name>"

    How do I set a permanent odbc data source for this?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 30
    Last Post: 06-26-2011, 10:47 PM
  2. Open a specific Excel application in Access
    By Hobbes29 in forum Programming
    Replies: 1
    Last Post: 02-14-2011, 06:48 PM
  3. Replies: 1
    Last Post: 06-02-2010, 10:05 AM
  4. Data migration open source tool
    By pgdabler in forum Import/Export Data
    Replies: 0
    Last Post: 10-07-2009, 08:46 AM
  5. Replies: 0
    Last Post: 08-30-2006, 02:50 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums