MySQL Forums
Forum List  »  Microsoft Access

Linking MySQL tables into Access
Posted by: Peter Weir
Date: October 06, 2005 10:52AM

Hi,

All a bit new to the world of MySQL. However do know a bit about access.

At work we have an MySQL database and I am tring to use Access to run queries from it.

I have set up the ODBC and linked the tables into access but it seems that if the SQL table has a primary key all the cells state #Deleted.

If I import the table the data can be viewed fine.

Can anyone help. It would be really useful to be able to write queries and reports that will run of the linked table and as a result be bang up to date.

Any help will be great.

Peter

Options: ReplyQuote


Subject
Views
Written By
Posted
Linking MySQL tables into Access
2241
October 06, 2005 10:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.