Results 1 to 2 of 2
  1. #1
    MiaAccess is offline Advanced Beginner
    Windows 7 32bit Access 2003
    Join Date
    Mar 2011
    Location
    Texas
    Posts
    31

    Design tab, Data Definition

    I am feeling around my database which was upgraded from Access 2003 to Access 2013. I am getting error messages and I was trying to figure out why a particular query gave an error. I clicked on "data definition" and I think it opened a new query, but it will not let me close it. The message is invalid SQL statement, expected Delete, Insert, Procedure, Select or Update. There is no way to cancel this.


    I had to use the task manager to close the database, not what I like to do.
    What do you do with "data definition"?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    See this link for more info.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Changing Field definition within a query
    By gm_lowery in forum Queries
    Replies: 5
    Last Post: 08-30-2012, 09:19 AM
  2. first create table in MS access data definition sql view
    By learning_graccess in forum Access
    Replies: 1
    Last Post: 10-14-2011, 06:23 AM
  3. Definition Tables using a Query?
    By AccessMaccess in forum Access
    Replies: 5
    Last Post: 03-22-2011, 10:01 AM
  4. Need help in finding Macro definition
    By sdondeti in forum Access
    Replies: 11
    Last Post: 10-31-2009, 04:52 PM
  5. Criteria Definition
    By claing in forum Access
    Replies: 1
    Last Post: 12-19-2005, 07:46 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums