Search results

  1. A

    Docmd.Openquery requires more than read/write?

    Hi, I have a client-server setup with a SQL Server 2005 backend, with an Access 2003 client front-end forms. On this front-end I have several pass-through queries which basically transfer some records from another SQL Server 2005 database to this database, on different servers. Through VBA, i...
  2. A

    ODBC Error in query (client/server SQLServer)

    Hi, I have a problem with my query which works fine prior to upsizing to SQL Server. Now I have an Access Front-end with SQL Server (2005) back-end client/server setup. This problem has bugged me for over one full day and I can't find anything that seems to solve it. Any suggestions is...
  3. A

    DSN File Required for Linked Table Front-end Access?

    Hi, I have an Access Front-end and a SQLServer (2005) back-end setup. The tables are basically linked into the Access front-end via ODBC link with a DSN file. In addition, the authentication is through Windows Authentication. My question is, once the Front-end Access file has established the...
  4. A

    Access' Source Control with TFS???

    Hi, I am trying to source control my modules and macros for my Access 2007 databases. I have installed the office developer's kit which enables the Source Control feature. In the features of Source Control, MS mentioned that developers may use Visual Source Safe or 'other' source control apps...
  5. A

    Moving new data to already upsized SQL Server

    Hi, I have upsized my Access 2000 back-end tables into SQL Server 2000 successfully and did a simple table-link of those to my Access front-end. I did many testing with test data, but now it's time to move in the live data (in Access). Is there a way to move just the Access data into the...
  6. A

    Importing excel file ...too slow

    Hi, I have a relatively slow machine and it seems to be affecting the way I import an excel file data to a temp table, while immediately looking into that temp table afterwards. DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, "tmpStudentImport", "C:\StudentImport.xls", True Do...
  7. A

    Easy way to Export Modules?

    Hi, in Access (2003)(VB) there's an export feature to export module/macro code onto text. Unfortunately there is no easy way to export all modules/macros at once. Further more, macros need to be converted to VBA code first, then exported. Is there a wizard or some sort that does this all at...
  8. A

    Limited to same usergroup per workstation?

    Hi, I want to secure my Access (2000) database with Access' built-in user-level securities, but my consultant tells me that the limitation to that is once that's set up, I will be required to use the same workgroup file for every other Access dB that I secure? Is that true? I need user-level...
Back
Top Bottom