Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jan 2003
    Central Florida, USA
    Thanked 0 Times in 0 Posts
    I have an mdb that runs on three workstations. All workstations are running Windows 7 Enterprise and Office 2007. On one of the machines the user is prompted for the SQL Server Login every time a recordset is created in VB. Yet the others are not. The others open the program, click on the control that calls VB code that creates some recordsets, updates some tables and other things and are not prompted.

    FWIW - there is an autoexec macro that opens a form (hidden) based on a query where the connection, username and password are included. The form works fine on all but one machine, and prevents the user from being prompted everytime the program needs to access the tables.

    Any ideas where to look? Is there a setting some place that I missed?

    As always, your ideas and suggestions are greatly appreciated.


  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Cambridge, UK
    Thanked 3 Times in 3 Posts
    Is it using SQL Server Authentification, or Windows Authentification for the Connection?
    If it is the latter, then the permissions might be missing from the SQL Server.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts