Search results

  1. C

    Security Design Access 2007 FE and SQL server 2008 backend

    Can anyone please advise on a security design to use Database Roles in SQL server 2008 when using MS Acess 2007 as a front end. How can I integrated DB Roles into MS Access when the security use to be handled by the forms when the database was is Acsess? I link the database through ODBC. I...
  2. C

    Run-Time Error 91

    I have the following code that use to work fine when my front end was in a .ACCDB file. After I migrated the backend to SQL server I changed the fron end to a .adp file and now my code won't work. I get the following error message "Run-Time error 91". Can someone please help. Sub GetDBUsers()...
  3. C

    MS Access Front End to SQL Server Back End

    Is there a way I can connect SQL Server 2008 through MS Access 2007 application through an Application Role? If so how would I go about it?
  4. C

    CDO Message

    What Reference Library should I use if I wanted to send CDO messages through VBA? Thanks
  5. C

    MSysObjects Table Locked

    I have a database split into front end and back end(password secured). How can I prevent users from viewing the MSysObjects table in the front end.
  6. C

    New Member

    Hi everyone from Chicago. My name is Oscar and I have been programming fo 6 years of which 4 have been MS Access 2003 and 2007. I really enjoy this site and has helped me much in the past. Hopefully, I can share what I have learned here along with my experience to help others as well as to...
Back
Top Bottom