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 derfloh 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: dforkin
  • Content: Threads
  • Order by date
  1. dforkin

    update from table to table

    How can I write a sql statement to update data in one table with data from another table. For example: I have a field named CALLER in a table called SURVEY. I have a field named SURVEYEDBY in a table called CONTFILE. These two tables are related as follows: Survey.Contid=Contfile.Contactid...
  2. dforkin

    odbc refresh

    I use access to view and odbc connection to mysql database. When I change fields within a table, I can reflect the changes in access by using the linked table manager and updating the information. However, this only seems to work for fields. What can I do to refresh my view to show new tables...
  3. dforkin

    I have an access view of a mysql da

    I have an access view of a mysql database, which I am linked to via odbc. Everything seems to work find. I can update and edit right from access. However, when I added a field to the database in my sql and then open the table in access, using my prior odbc connection, the field does not appear...
  4. dforkin

    access and mysql

    I have a question about using ms access to connect to a mysql databased. This may be very elementry, but please be patient, as we have just made a switch to mysql. I am a custom to using access as my day to day data processing tool for databases that we have connected to various web...
  5. dforkin

    Removing Duplicates

    I have a table in ms access that has duplicate records. The duplicates can only be identified by two fields. The record is a duplicate if it has the same value in the field "source" AND the same value in the field "source". This table only has 3 fields. The other field is...

Part and Inventory Search

Back
Top