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 wOOdy-Soft 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: *

  • Users: Slugmaster
  • Content: Threads
  • Order by date
  1. Slugmaster

    How to delete data that is duplicated in two different tables?

    I have two tables of the same structure in an Access DataBase. One table is linked from an ODBC source and the other is an Access table. I want to delete the data in the Access table that contains duplicate information from the ODBC table. The tables are joined by the primary key. When I try...
  2. Slugmaster

    Database synchroniztion between field and server?

    How can I synchronize my field laptops with my server machine on a periodic basis? My field laptops Retrieve/Modify/Add information to their local database. When that laptop gets back, I want to update the central server, then update the local laptop again. The central server is only used to...
  3. Slugmaster

    Creating an SQL statement that outputs data to a text file.

    I am trying to write an SQL query that selects specific records from an ODBC database and outputs them to a text file in a specified format. A co-worker of mine recently attended a workshop which gave us the idea. Unfortunately, he is not an SQL person and has no idea of how it is soppose to...
  4. Slugmaster

    How do I connect in VB with ODBC w/o having Sysbase client running?

    I am using a VB6 application to connect to a Sysbase SQL database. The problem I have is that I first need to launch the Sysbase DBClient.exe application in order for my VB code to connect. I desire to connect completely by code, without having any user interaction. I tried to use the VB...
  5. Slugmaster

    Access 97 Select Query using Date in Where clause not working.

    I have a very simple query based from a very simple table that I cannot get to work. Table1: Field1: TAG, Text Field2: TimeModified, Date Query1: SQL: SELECT Table1.TAG, Table1.TimeModified FROM Table1 WHERE (((Table1.TimeModified)=#4/12/2001 10:39:35#)); The output of the Query is nothing...
  6. Slugmaster

    How do I connect in VB with ODBC w/o having Sysbase client running?

    I am using a VB6 application to connect to a Sysbase SQL database. The problem I have is that I first need to launch the Sysbase DBClient.exe application in order for my VB code to connect. I desire to connect completely by code, without having any user interaction. I tried to use the VB...
  7. Slugmaster

    Remote replicate problem with netwoked linked tables.

    I have an Access database(DB1) that contains a couple of tables linked to another Access database(DB2). Both databases are on a network drive (ie: \\Computer1\folder\db1.mdb, \\Computer1\folder\db2.mdb). I then used the Access replicate feature on DB1 so that my technicians can use the...

Part and Inventory Search

Back
Top