Search results for query: *

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...

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...

Also, what about refeshing the view to see a new table? Is there somewhere for that? thanks

thank you. that did it.

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...

when opening in access, a lock file 9 is created. Could this cause any problems.

another question: when setting up the odbc, there is a section with 18 check boxes. this section is called "options that effect the behavior of myodbc". Should all of these, none of these be checked? What are the implications. Sorry if this is a stupid question.

Is there a specific driver version that is optimal.

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...

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...