Results 1 to 2 of 2
  1. #1
    Phred is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Dec 2009
    Posts
    246

    Excessive Requests for SA login to SQL during Access development.

    Access 2007, SQL Server 2008 R2, All architecture developed in ModleRight and Generated to SQL Server successfully, ODBC established, I can link to, and see, all tables in Access, ODBC requires my SA and password witch works fine. I am building my queries on SQL Server Query Editor and then save them, I copy the SQL and paste it in a Access Pass-Through query. My setup is virtualized using VMware. I have a Virtual SQL SERVER and a Virtual Access 2007 workstation. Everything seems to work fine. When I open the database I have to log on as SA. All that seems normal to me.

    I AM AN EXPERIENCED ACCESS DEVELOPER BUT THIS IS MY FIRSTTIME USING SQL SERVER AS A BACKEND. I AM JUST STARTING ON MY FRONT END SCREEN DEVELOPMENT.

    I am getting hit hundreds of times to reenter my SA password. Every move I make, every touch, every modification, moving back and forth from design to view form, everything causes the SA logging to fire. This is a completely isolated environment, there are no other users. I am in complete control of SA and am the administrator and can do anything on SQL Server. It seems to me the problem is on the Access side in sustaining my SA login.

    There is no VBA code at this point to even post. I am not sure what other information to give you. Please ask.



    I must be missing something basic.

    Thanks

    Phred

  2. #2
    Dal Jeanis is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    Hmmm. I don't know VMware, but one question I'd ask is, are you holding open a connection to a "fake" table on the backend, to keep the connection open, or is it possible that the different applications are "helping" you by dropping the connection to the back end whenever it "isn't needed"?

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

Similar Threads

  1. Replies: 3
    Last Post: 09-17-2012, 09:53 AM
  2. Access Runtime 2007 & Development App
    By EddieN1 in forum Access
    Replies: 2
    Last Post: 10-12-2011, 11:08 AM
  3. Access Runtime Development
    By crowegreg in forum Access
    Replies: 2
    Last Post: 08-09-2011, 09:22 AM
  4. Vacation Requests
    By MFS in forum Queries
    Replies: 3
    Last Post: 07-09-2011, 09:03 PM
  5. Excessive 'sums'
    By Captain Database ...!! in forum Queries
    Replies: 3
    Last Post: 06-23-2011, 02:37 PM

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