linking access to mysql

[tedpottel]

Hi,
I have don this and it worcked. I switch over to a new database
server and change the dns to point to it.

All the fields in the table now say #deleted. What went wrong?
-Ted

 

[Clifford Bass]

Hi Ted,

Access often stores the database name also. If that changed, that
could by why. I would use the Linked Table Manager and relink all of them.
You may need to check the "Always prompt for new location" item.

Hope this helps,

Clifford Bass