Dec 12, 2006 - 11:32 AM
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 - 11:52 PM
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 - 11:54 PM
Dec 13, 2006 - 12:39 AM
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 - 01:32 AM
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 - 02:26 AM
Dec 13, 2006 - 02:42 AM
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 - 02:58 AM