troubleshooting Question

Using MySQL ODBC to Overwrite a table.

Avatar of jdwango12
jdwango12 asked on
DatabasesMicrosoft AccessMySQL Server
2 Comments1 Solution541 ViewsLast Modified:
Hi, I have a table that I have exported to an MySQL database sucessfully using the ODBC connector. Works like a dream.
Now that I have exported it, I have made changes in access and I want to update it again.
When I use the same procedure that I used to export it, It tells me it caznt becasue that table already exists.
How can I tell Access that it is okay to overwrite it?
Please advise. --JM
ASKER CERTIFIED SOLUTION
Muhammad Khan
Manager, IT

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros