Use Access to create SQL Editors for Databases

[markb]

Administer your SQL Server database with MS Access. Those who are familiar with Access might find this more appealing and you won't have to install SQL Server on your local machine to administer a remote SQL database.

Firstly you need to install the mysql ODBC connection driver

get it from here http://dev.mysql.com/get/Downloads/M...netmirror.com/


follow the these set up procedures
MySQL AB :: MySQL 5.0 Reference Manual :: 23.1.3.2 Configuring a Connector/ODBC DSN on Windows

A completed DSN configuration may look like this:
change to the following
Data Source Name antrix
Description Connects to Antrix Database
Server Localhost
User user sql username
Password password for sql login

press the test button
connect should be established

now using the database button select the database antrix

now press the ok button

How to get access 2007share our sql database

1. Call up access 2007
2. Create a blank database
3. Select the extental data tab
4. Select the more button and choose ODBC Database
3. Click on link to data source by creating a link table
4. Select the tab Machine Data Source
5 You will see a data source name called antrix. Select it and press the ok button
6. you will now have access to all antrix tables
7. Press the select all button all tables will be selected. Pess the ok button
8. keep pressing the ok button untill all is processed


Now the best bit
Using acess to create forms to create character ,creature ,weaons , items and spell editors.
Create a autoboot menu to load your forms

View screenshot here
Box.net - Free Online File Storage, Internet File Sharing, RSS Sharing, Access Documents & Files Anywhere, Backup Data, Share Files

remember any other tables created in access are not in mysql only the ones that are linked.

Happy programming

[MentaL]

[markb]

Tested and working

[markb]

How about some you tightasses atleast saying thank you are something.

THIS IS A USEFULL TOOL DONT THROW OUT THE DOOR.

[aceindy]

Yeah dude, it's nice, but it's simple ODBC.
The whole point of ODBC was to get access by any program, including Access and Excel.
You could even use the SQL query builder from MS, but what's the point in accessing MySQL by using MS-SQL queries??

Besides, Navicat will always be faster as it uses native mySQL, and keep in mind, ODBC ain't build for speed but for compatibility.

[markb]

my point was to use it to make your editors like creature editor etc not as a sql front end like sqllog and navicat