|
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
|
|
Expert:
|
xarcus
|
|
Date:
|
Dec 12, 2006
|
|
Time:
|
14:32
|
|
|
|
Votes: Good (0) | Bad (0)
Login to rate this answer
|
|
|
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.
|
|
Expert:
|
john2
|
|
Date:
|
Dec 13, 2006
|
|
Time:
|
02:52
|
|
|
|
Votes: Good (0) | Bad (0)
Login to rate this answer
|
|
|
What software do you need to create a MySql database?
|
|
Expert:
|
john2
|
|
Date:
|
Dec 13, 2006
|
|
Time:
|
02:54
|
|
|
|
Votes: Good (0) | Bad (0)
Login to rate this answer
|
|
|
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.
|
|
Expert:
|
john2
|
|
Date:
|
Dec 13, 2006
|
|
Time:
|
03:39
|
|
|
|
Votes: Good (0) | Bad (0)
Login to rate this answer
|
|
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/en/...
|
|
Expert:
|
xarcus
|
|
Date:
|
Dec 13, 2006
|
|
Time:
|
04:32
|
|
|
|
Votes: Good (0) | Bad (0)
Login to rate this answer
|
|
|
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.
|
|
Expert:
|
john2
|
|
Date:
|
Dec 13, 2006
|
|
Time:
|
05:26
|
|
|
|
Votes: Good (0) | Bad (0)
Login to rate this answer
|
|
|
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.
|
|
Expert:
|
dustPuppy
|
|
Date:
|
Dec 13, 2006
|
|
Time:
|
05:42
|
|
|
|
Votes: Good (0) | Bad (0)
Login to rate this answer
|
|
|
I have MS enterprise on my computer, will that work at a "database engine"? Also, where can I get mysqladmin?
James
|
|
Expert:
|
john2
|
|
Date:
|
Dec 13, 2006
|
|
Time:
|
05:58
|
|
|
|
Votes: Good (0) | Bad (0)
Login to rate this answer
|
|
|
john2, please close this question and distribute the points.
If you didn't get a solution to your problem or you found it yourself, please leave a comment here to let the experts know.
Thanks,
Quomon Admin
|
|
Expert:
|
admin
|
|
Date:
|
Jun 04, 2007
|
|
Time:
|
11:37
|
|
|
|
Votes: Good (0) | Bad (0)
Login to rate this answer
|
|
|
|
|
|
|
This question has been answered, and points have been rewarded to the following experts:
You're welcome however to comment or give additional information or if you wish, you have the ability to write an Answer Summary for this question by clicking on the "Answer Summaries" Tab.
|
|