Access 2007 does not show existing data when opening form with linkedtable

[YehudaK]

I created a linked table in Access 2007 using a UserDSN for a MySQL
database (MySQL ODBC 5.1 Driver from mysql.com).
The link works correctly.

I created a form to manage the data in this table using the Form
Wizard.
The form also works properly, most of the time.

If I close and reopen Access, the form no longer has any data.
The data is still visible in the table and I can add new records using
the form, but I can not see any old records until I create a filter
and then remove it.

I am trying to design this for someone who is non-technical to the
extreme and can not give her instructions to create and remove a
filter.
How can I get around this?

When I give it to her I will turn of the Navigation panel on the side
and create a switchboard.
I am not sure if this is related to my problem, but I noticed that
when I open the file the forms are not listed in the correct
categories until I open them and close them again. (Each form should
be in the category with its linked table.)

I can supply screenshots if that will help.

 

[Klatuu]

Check the form's Data Entry property. Sounds like it is set to Yes.
When the Data Entry Property is set to Yes, you will not see existing
records. You will see only those records added in the current session.

 

[YehudaK]

Data Entry for all forms and subforms is set to No.
Any other ideas?
Anyway, that would not explain why the data is visible once you enable
and disable a filter.

 

[Klatuu]

It may not be Access. It may be MySQL, but since I am not familiar with it,
I may not be able to help.
But, how are you setting and removing the fliter?

 

[YehudaK]

The MySQL driver should be just like any other ODBC Connector.
How I set the filter:
1. http://gallery.ymkatz.net/temp/1.jpg
2. http://gallery.ymkatz.net/temp/2.jpg
3. http://gallery.ymkatz.net/temp/3.jpg
(Note: data has been removed for privacy reasons, where there was data
has been made gray, anything white was actually blank.)

Notice how the total count changes in each step.

 

[Klatuu]

Sorry, but I don't see anything there that gives me any ideas.

I would try connecting with a different mdb and maybe recreating the ODBC
connection. Other than that, I don't think I can help.

 

[maxsal]

Hi YehudaK,

I have the same problem, trying to access data from sharepoint lists;

I have tried to remove the filter via VBA on opening the form, but this also does not work.

did you find a solution already?

Max

 

[maxsal]

i do not understand where the problem comes from, but i found a solution now:

the VBA-Code

Private Sub Form_Load()
Me.Requery
End Sub

makes all data appear!

attention: this only works with data entry set to "no", which is a pity - any better solutions would be appreciated!

 

[Guest]

Sorry, but I don't see anything there that gives me any ideas.

I would try connecting with a different mdb and maybe recreating the ODBC
connection. Other than that, I don't think I can help.