Quick question

Results 1 to 2 of 2

Thread: Quick question

  1. #1
    Join Date
    Dec 1969

    Default Quick question

    I just need a yes or a no...if the answer is a yes i can look around and see if i can find out how to do this, but, is it possible to have an asp page create a new table in an existing database (acces)? thanks

  2. #2
    Join Date
    Dec 1969

    Default Yes...easy

    The problem is that the documentation that comes with Access2000 and Access2002 and AccessXP is *VERY* inadequate about the SQL language supported by Access.<BR><BR>*IF* you can find a copy of Access97, get the *HELP* files from it and you&#039;ll find all sorts of wonderful stuff on what SQL is available to you! I have OfficeXP on this machine, but I kept my old copy of Access97 *just* for the documentation!<BR><BR>There is an ASPFAQ on this (and shame on you for not looking there first!):<BR>http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=8<BR><BR>But it doesn&#039;t go into much detail. <BR><BR>MSDN also has *some* of the Access97 docs online:<BR>http://msdn.microsoft.com/library/en-us/office97/html/output/F1/D2/S5A318.asp<BR><BR>And if you look in left panel of that page for "CREATE TABLE" you find:<BR>http://msdn.microsoft.com/library/en-us/office97/html/output/F1/D2/S5A320.asp<BR><BR>and some support here:<BR>http://msdn.microsoft.com/library/en-us/office97/html/introduction.asp<BR><BR>But getting a copy of the Access97 HELP files is really the ideal thing.<BR><BR><BR>

Posting Permissions

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