Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Dad0AEW

    Making Access app multi-user

    I have a client who has an application that was originally written in Access 2010 and is now in 2013. It is set up now so that only one user at a time can use it. I want to be able to make this multi-user. Anyone have any tips/tricks/ideas? Would I be better off to export the tables into...
  2. Dad0AEW

    Setting ODBC Timeout Value

    I have an Access97 app (they're not in a position to upgrade) that has links to data in a SQL Server database. There are some pretty intense queries that are in it that ran fine when the interface and data was all Access, but now the the data is in SQL Server I'm getting error messages that...
  3. Dad0AEW

    Access 97 report using SQL Server linked tables

    This is my query. The Select and From clauses are the same, yet the WHERE clause is built programmatically based upon what the user selects on a screen. SELECT DISTINCTROW I.TAG, K.Tag AS KTag, I.GAUGE, K.MetalEval, (IIf(I.TYPE="EMBSD" Or I.TYPE="MTRLAM" Or I.TYPE="MIXED" Or I.TYPE="TRANS" Or...
  4. Dad0AEW

    Access 97 report with linked SQL Server Data

    This is my query. The Select and From clauses are the same, yet the WHERE clause is built programmatically based upon what the user selects on a screen. SELECT DISTINCTROW I.TAG, K.Tag AS KTag, I.GAUGE, K.MetalEval, (IIf(I.TYPE="EMBSD" Or I.TYPE="MTRLAM" Or I.TYPE="MIXED" Or I.TYPE="TRANS" Or...
  5. Dad0AEW

    Access 97 report using SQL Server linked tables

    I have a report in an Access 97 app that has as its data source a query that is built programmatically. The query can get rather long, as the Where clause is built programmatically and can have several different conditions. When the data was all Access I was able to run it without error. I now...
  6. Dad0AEW

    Access 97 report with linked SQL Server Data

    I have a report in an Access 97 app that has as its data source a query that is built programmatically. The query can get rather long, as the Where clause is built programmatically and can have several different conditions. When the data was all Access I was able to run it without error. I...
  7. Dad0AEW

    Migrating from Access to SQL Server

    A client has an Access 97 database that I am looking to migrate the data to SQL Server 2005. The Access database uses the mda/mdw security, so when I try to import the data via the import task in SQL Server or when I try the SSMA tool I get errors because of the security. Does anyone know of a...

Part and Inventory Search

Back
Top