Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MS Access as front end on a MySQL Database
- Thread starter lonchi
- Start date
install MyODBC on your system, then configure it and create a DSN to your MySQL database.
Open blank access database and create a linked tables to your mysql database.
You can download MyODBC from
Bye
Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)
Open blank access database and create a linked tables to your mysql database.
You can download MyODBC from
Bye
Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)
I have just begun experimenting with Access and MySQL and would love to hear what anyone has to say on this topic.
I have MyODBC installed. And it works fine for me. (now that I have MySQL 4.05 installed)
But I'm wondering about using forms. If I have a data entry form that let's you add records. Do I need to use SQL statements? Like 'INSERT INTO' or can you also use the DAO.Recordset?
I have noticed that there is an Add-In for Access on the MySQL website. I don't remember the name of it. But it sounds like it is an Add-In for Access that lets you manage the database. Instead of using MySQL-CC or MySQL-Front.
I'm going to download it myself and try it. But I don't think it's meant to be a development tool, only a DB management tool. (I'll find out)
tgus
____________________________
Families can be together forever...
Do you mean using HTML forms?
If yes I can send you an example of form page and action page to insert records in a MySQL table.
I unfortunaltely use ASP and not PHP but it will do the job anyway.
Bye
Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)
If yes I can send you an example of form page and action page to insert records in a MySQL table.
I unfortunaltely use ASP and not PHP but it will do the job anyway.
Bye
Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)
Unfortunately, I don't know anything about doing ASP or HTML in Access. If you were doing something in PHP, I might be interested.
My question was more related to using Access as a frontend (forms, reports, etc...) for the MySQL DB.
QatQat, it doesn't sound like you're doing anything like this.
Is there anyone who has had any experience doing any of this sort of thing?
Can you maybe direct us to some links or tutorials on this?
tgus
____________________________
Families can be together forever...
My question was more related to using Access as a frontend (forms, reports, etc...) for the MySQL DB.
QatQat, it doesn't sound like you're doing anything like this.
Is there anyone who has had any experience doing any of this sort of thing?
Can you maybe direct us to some links or tutorials on this?
tgus
____________________________
Families can be together forever...
- Status