How to create Access tables without Access?

Results 1 to 2 of 2

Thread: How to create Access tables without Access?

  1. #1
    Marty Blase Guest

    Default How to create Access tables without Access?

    I can&#039t get Access to install on my work computer, but I&#039m trying to do ASP work without it. I know how to do the following:<BR><BR>- use the ODBC control panel to create a new Access database<BR>- use SQL to create a new table in a database file<BR><BR>What I *don&#039t* know how to do is identify columns of data -- that is, I don&#039t know all the different data types Access supports. I know that you can use SQL&#039s CREATE TABLE command to create a new table called "Messages" that has one autonumbered column, one short text column, one long text column, one currency column and one integer column, but I don&#039t know the actual syntax to do so.<BR><BR>Is there a reference somewhere online, or on paper in a quick reference, that lists all the different data types Access supports and how to use them in SQL&#039s CREATE TABLE command?

  2. #2
    Joel Nelson Guest

    Default RE: How to create Access tables without Access?

    Try this URL: http://support.microsoft.com/support/kb/articles/Q180/8/41.ASP<BR><BR><BR>Good luck.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •