Hallo Claudius, danke da bin ich erst recht beruhigt. Hast Du die Mail von heute Nacht mal gelesen, die mit dem vb Absturz ? Was meinst Du dazu ?
J�rg Schwalenberg _______________________________ Extensions and Basics for Macromedia "Dreamweaver Ultradev" .............................................................. www.ultradevextensions.de www.udex.de [EMAIL PROTECTED] _______________________________ ----- Original Message ----- From: "Claudius Ceteras" <[EMAIL PROTECTED]> To: "AspGerman Kaffeehaus" <[EMAIL PROTECTED]> Sent: Monday, January 21, 2002 10:29 AM Subject: [aspdecoffeehouse] RE: Wieviel Tabellen verkraftet Access Ausgesuchte theoretische Maxima: Microsoft Access database (.mdb) file size = 2 gigabytes minus the space needed for system objects. Number of objects in a database = 32,768 Number of characters in an object name = 64 Number of characters in a password = 14 Number of characters in a user name or group name = 20 Number of concurrent users = 255 Number of characters in a table name = 64 Number of characters in a field name = 64 Number of fields in a table = 255 Number of open tables = 2048; the actual number may be less because of tables opened internally by Microsoft Access Table size = 2 gigabyte minus the space needed for the system objects Number of characters in a Text field = 255 Number of characters in a Memo field = 65,535 when entering data through the user interface; 1 gigabyte of character storage when entering data programmatically Size of an OLE Object field = 1 gigabyte Number of indexes in a table = 32 Number of fields in an index = 10 Number of characters in a record (excluding Memo and OLE Object fields) = 2,000 Number of enforced relationships = 32 per table minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationships Number of tables in a query = 32 Number of fields in a recordset = 255 Recordset size = 1 gigabyte Sort limit = 255 characters in one or more fields Number of levels of nested queries = 50 Number of ANDs in a WHERE or HAVING clause = 99 Number of characters in an SQL statement approximately = 64,000 Claudius > > > Hallo Leute, > > Eine Frage am Morgen. > > Wieviel Tabellen verkraftet Access den eigentlich problemlos ? > Ich habe derzeit 30 Tab in einer Access2000 DB, noch geht das alles > reibungslos. Es sind ca. 12 Tabellen drin, die nur Jumpwerte > besitzen, also > auch nicht gr��er werden. > > Irgendwie habe ich in Erinnerung, dass bei 30 das Ende > erreicht ist , oder ? > > J�rg Schwalenberg | [aspdecoffeehouse] als [EMAIL PROTECTED] subscribed | http://www.aspgerman.com/archiv/aspdecoffeehouse/ = Listenarchiv | Sie k�nnen sich unter folgender URL an- und abmelden: | http://www.aspgerman.com/aspgerman/listen/anmelden/aspdecoffeehouse.asp | [aspdecoffeehouse] als [email protected] subscribed | http://www.aspgerman.com/archiv/aspdecoffeehouse/ = Listenarchiv | Sie k�nnen sich unter folgender URL an- und abmelden: | http://www.aspgerman.com/aspgerman/listen/anmelden/aspdecoffeehouse.asp
