RE: Views accessed as table in MS Access

2006-11-12 Thread Christopher Lewis
Interesting. I also tried using views in Access, and found that it only gives data from the first table specified. However, when I tried accessing the same view from OpenOffice using ODBC, it worked fine. Are there any other ways we can find out if this is a MyODBC error or Access/MSJET? -

[#Deleted] records in Access

2001-03-14 Thread Christopher Lewis
and I see that it still has not been fixed, or has not been reported. Please let me know what I can do to help solve this problem. Christopher Lewis - Before posting, please check: http://www.mysql.com/manual.php (the m

Re: [#Deleted] records in Access

2001-03-15 Thread Christopher Lewis
suppose if it still doesn't work right, I will just have to install some 3.22 version of MySQL. Christopher Lewis >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 3/14/01, 10:

connecting Microsoft Access to MySQL (Formerly Re: [#Deleted]records in Access)

2001-03-15 Thread Christopher Lewis
working with Access 97 and MySQL 3.22, and everything worked fine with that combination. Well, whatever works. Christopher Lewis -- Previous Message -- The "trick" is that while an autoincrement field is a nice thing to have as a primary key, is to put a timestamp field