0
votes
1answer
61 views

Can i give foreign key relationships of ODBC tables from ms sql to ms access

I have a question regarding the ODBC relationships between SQL and MS ACCESS as i have migrated several tables from SQL to ms access and i performed some operations but the problem occured in ...
1
vote
0answers
114 views

MS Access ignores confirmation dialog when updating linked MySQL table

I have a MySQL database (Version 5.1.63) which is connected to MS Access (2002) via ODBC (MySQL ODBC 5.1 Driver). In MySQL I created a simple table like this: CREATE TABLE IF NOT EXISTS `test` ( ...
3
votes
2answers
5k views

MySQL form builder like MS Access

Are there any good tools out there (don't have to be be free) that provide functionality analogous to MS Access but for non-MS databases like MySQL? I'm looking for more than just a query builder ...
1
vote
4answers
666 views

Export Microsoft Access tables to MySQL

I have a database that was created in Microsoft Access and I'm trying to replicate it in a MySQL database. Is there some sort of tool that can do it? Historically, I've exported to CSV and then used ...
3
votes
3answers
7k views

MySQL query builder? (like Access has in Design View)

Is there any free tools that would let me build queries like one can in Access?
2
votes
4answers
188 views

What is the best way to convert a MySQL database to an access database?

I need to convert databases both directions and I also need to grab subsets of data on occasion. Is there an easy way to do this?