Results 1 to 2 of 2
  1. #1
    sberla is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    2

    Error Access

    Hello, I would have this problem when I run these queries:



    Code:
    CREATE TABLE clienti (idcliente AutoIncrement,nome string,cognome string,cap integer,provincia string,via string,citta string,partitaiva string,codicefiscale string,ragionesociale string,telefono string,cellulare string,email string);  CREATE TABLE about (id AutoIncrement,versione string);  insert into about(versione) values('3.1');  DROP TABLE Giacenze;  Create Table relazionecategorie(id AutoIncrement,idcategoria integer,idprodotto integer);  drop index idcategoria on prodotti;  ALTER TABLE prodotti DROP COLUMN idcategoria;  ALTER TABLE prodotti ADD COLUMN data DateTime;
    Errore message:

    "You selected the "Tables and Related Views" as database objects grouping modality. In order to create groups, you have to update the infos about the dependace between the objects. The necessary time for this operation depends from the database dimension."


    The error occurs when I close it and reopen access.

    Instead if I run directly from the IDE to access ("via interface") is not in exclusive mode when I close and reopen access did not generate any type of error. In the database there 'any kind of view or another. I HAVE already checked everything.

  2. #2
    Stingaway is offline Efficiency Junkie
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    The deep south. Keep going until you hit water basically.
    Posts
    224
    That "error" is related to the view you have chosen in Access by default. If you click on the drop down in the table / query / reports/ macros area - you can select "all dates" or "modified date" for example and get another view that should get rid of that message...

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

Similar Threads

  1. Replies: 2
    Last Post: 08-10-2012, 12:28 AM
  2. Replies: 3
    Last Post: 05-30-2012, 01:43 PM
  3. Replies: 6
    Last Post: 09-28-2011, 09:20 PM
  4. Error 438 error in Access 97
    By Bones in forum Access
    Replies: 3
    Last Post: 01-05-2011, 10:12 PM
  5. Access Error
    By 90awdturbo in forum Access
    Replies: 2
    Last Post: 11-18-2010, 01:09 PM

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