#Deleted

[kmclane]

I have a table that got too big for Access 97, so I moved it to a mysql db. I still need to usa A97 as the front end for it. I used the same table name, installed MyODBC and set up a DSN. I unlinked my original table, linked the my sql table and tried to use my search form. Clicking the search button now has no effect. So I left the form up in the background, and ran the query. it return a result set full of #Deleted. If I go to the Mysql server, the table has data. I tried changing my query to a pass through, but it errored on my parameters that get pulled from the form,(still open). This is my first attempt at this, so I could use some suggestions. My first goal is to get the query to return results, the second is to get my form running the query again. I did add an autonumber field and made it the primary key when I moved the table to MySql, but I don't know why this would affect a query that isn't asking about it. Thanks, Ken

- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg

 

[kmclane]

I guess nobody has a clue either, thanks anyway. Ken

- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg

 

[petermeachem]

1) Can you see the data in Access when you double click the data?
2) Did you include the autonumber in the query?

http://www.accuflight.com

http://www.lettersdirect.co.uk

http://www.ourhouseinportugal.co.uk/

 

[kmclane]

I tried just opening the table, which came up all populated with #Deleted. I will try including the Autonumber in the query and let you know if it changes anything.
Ken

- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg

 

[petermeachem]

Delete the linked table from Access and put it in again. If it asks which is the unique column tell it the autonumber one. There is no point trying the query until access can display the table.
Forums a bit up and down isn't it?

http://www.accuflight.com

http://www.lettersdirect.co.uk

http://www.ourhouseinportugal.co.uk/

 

[kmclane]

What do you know, I haven't tried it for a couple of days, but in the mean time I had rebooted my Linux box. Now it worked without a hitch. Thanks, Ken

- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg

 

[danvlas]

This link may be of some help:

http://dev.mysql.com/doc/connector/odbc/en/faq_4.html

Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html