How do I run a query on Access?
I have a query that I'd like to run, I dumped this from my MySQL.
I want to just copy and paste the sql into something, but I can't find where!
CREATE TABLE News_Authors (
author_id int(4) NOT NULL auto_increment,
username varchar(255) NOT NULL,
password varchar(255) NOT NULL,
author_name varchar(255) NOT NULL,
PRIMARY KEY (author_id)
CREATE TABLE News_Stories (
story_id int(4) NOT NULL auto_increment,
author_id int(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (story_id)
I know this is a really basic question and it is probably blaringly obvious but I can't seem to find it!