Answers
Dec 12, 2006 - 10:32 AM
You can't generate your tables from an sql file in MSAccess.
In MSAccess you have the ExecuteSQL action in "macros" where you can write a 256 characters limited SQL String.
You need the pricey SQL Server to generate your tables from an sql file with MS stuff.
An alternative way to work with Access is:
create a MySql database with it
create a Windows database source for it : Control panel -> Administrative tools -> Data sources (ODBC)
and then from Access create a database
and through the File menu -> Get External Data ->set links to the MySql tables
In MSAccess you have the ExecuteSQL action in "macros" where you can write a 256 characters limited SQL String.
You need the pricey SQL Server to generate your tables from an sql file with MS stuff.
An alternative way to work with Access is:
create a MySql database with it
create a Windows database source for it : Control panel -> Administrative tools -> Data sources (ODBC)
and then from Access create a database
and through the File menu -> Get External Data ->set links to the MySql tables
Dec 12, 2006 - 10:52 PM
Gotcha,
I dont really have a ton of knowledge with the server side languages and database work, so I pulled an open source tool for a forum off the web hoping that it would be easy to implement. All I had on my computer is Access so I may just look for another resource. Thanks.
I dont really have a ton of knowledge with the server side languages and database work, so I pulled an open source tool for a forum off the web hoping that it would be easy to implement. All I had on my computer is Access so I may just look for another resource. Thanks.
Dec 12, 2006 - 10:54 PM
What software do you need to create a MySql database?
Dec 12, 2006 - 11:39 PM
Is that a stupid question? I'm guessing that a MySql database is created in MySql...
Dont really know. Is there any easy way to accomplish this for somebody who doesn't have a clue about creating/linking/manipulating databases? I'm in the "learning phase" of the server side stuff. Most of my experience is for design.
Dont really know. Is there any easy way to accomplish this for somebody who doesn't have a clue about creating/linking/manipulating databases? I'm in the "learning phase" of the server side stuff. Most of my experience is for design.
Dec 13, 2006 - 12:32 AM
Just try and find out.
After installing MySQL, open "MySql Administrator" click on Restore and specify your sql file.
if it failed because of database was not defined in the sql file, follow this link instructions http://dev.mysql.com/doc/world-setup/...
After installing MySQL, open "MySql Administrator" click on Restore and specify your sql file.
if it failed because of database was not defined in the sql file, follow this link instructions http://dev.mysql.com/doc/world-setup/...
Dec 13, 2006 - 01:26 AM
I didnt realize that MySql cost so much money. Think I may just skip out on this one, cant really invest that much at this point.
Dec 13, 2006 - 01:42 AM
as far as i know, you can get MySQL for free.
You need to download the database engine to run on your computer and then f.ex. the mysqladmin, which is a web interface to administrate the database.
Both might not be easy for you to install, but that should work... and for free.
You need to download the database engine to run on your computer and then f.ex. the mysqladmin, which is a web interface to administrate the database.
Both might not be easy for you to install, but that should work... and for free.
Dec 13, 2006 - 01:58 AM
I have MS enterprise on my computer, will that work at a "database engine"? Also, where can I get mysqladmin?
James
James
Add New Comment