I have an error situation that I cannot resolve. I have a number of MySQL
DBs on a FreeBSD server and use MyODBC to hook into them via an MS-Access
front end. All goes well in that setup. Recently I had a few site migrate
to a RedHat server. I set up MySQL on the new server and all went wel
I have two table I need to join in a query. The second table needs to be
join twice (I think) to the first. Details as follows (tables pared down)...
Table games
gameid
hometeamid
guestteamid
Table team
teamid
sponsor
I want a query to return game.gamid, team.sponsor (hometeam), team.spons
I am using Access as a front end to a MySQL database via MyODBC. All is well except
when I try to delete a record from a table that contains a dat field. I get various
results, all not the desired result. Most often I get prompted to verify that I want
to delete the current form. Is this a
Is there a way in MySQL to limit the values that a (numeric) field can hold. For
example if I want a given field to only have the values 1 - 10 can I do this and can
it be done in the definition of the field when the table is created?
---
I have a database that I am manipulating with Access through an MyODBC reference. All
is well except for tables that contain any date/time fields. When I click the
(standard) delete record button on forms that use these tables, I get prompted asking
if I want to delete the form from my Access
I want to be able to add a number field to a table and limit the values that the user
can enter. For example if it is an integer filed I may want the user to only enter
the value from 1 to 10. Can I do this within the definition of the field/table or do
I have to do this level of validity che
