House of Fusion
Search over 2,500 ColdFusion resources here
  
Home of the ColdFusion Community

Mailing Lists 		Home /  Groups /  ColdFusion Talk (CF-Talk)

Out of Space?

  << Previous Post |  RSS |  Tree View |  Sort Oldest First |  Subscribe to this Group Next >> 

Access 2000 and SQL 2000 Query Question

I think so, but you have to be very careful to use ODBC for anything Jann VanOver 07/13/2001 06:02 PM
We changed the setting in the regedit file for maxfilelock and it seems to Erika Foster 07/13/2001 05:47 PM
Anybody know a site where one can view the CF 5.0 docs online? Dick Applebaum 07/13/2001 05:32 PM
Question about SQL 2000 and Access 2000. Rich Tretola 07/13/2001 05:16 PM
If it's just one table, check this: Braver, Ben 07/13/2001 04:58 PM
Have you looked at the Windows Swap file?  On an NT server, sometimes Shawn Grover 07/13/2001 04:58 PM
Thanks, Janine Erika Foster 07/13/2001 04:57 PM
Shot in the dark, but can you try this: Saidi; Marwan 07/13/2001 04:27 PM
What about the boot drive of the PC?  Access creates temp files there. Howie Hamlin 07/13/2001 04:24 PM
Do you have the exact error message?  Maybe try this: Todd Ashworth 07/13/2001 04:24 PM
are there any other drive dependencies? for logs? for file writes? Dylan Bromby 07/13/2001 04:23 PM
1.It may actually be something with the table itself and not the disk space. Janine Jakim 07/13/2001 04:22 PM
Okay, troubleshooting this from 1000 miles away over the phone bites. Erika Foster 07/13/2001 02:52 PM
Its an Access Database and its about 6mb in size. Erika Foster 07/13/2001 01:26 PM
What kind of database is it? Kevin Gilchrist 07/13/2001 01:12 PM
Erika, Braver, Ben 07/13/2001 01:12 PM
What database software?  Some light weight software packages have size Brian Fox 07/13/2001 01:12 PM
I have a client who is getting an Disk Space error when trying to add or Erika Foster 07/13/2001 12:55 PM

07/13/2001 06:02 PM
Author: Jann VanOver Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:5021#21972 I think so, but you have to be very careful to use ODBC for anything "special" in the SQL.  If your dates are in ODBC Date Format, they should work for both.  I haven't done this for a long long time so I don't remember the syntax, but I'm mostly positive that it CAN be done. Question about SQL 2000 and Access 2000. Is it possible to have an application that will run using either Access 2000 or SQL 2000 DB? I am having trouble with datatypes when it comes to money. For example I have an update query that updates a money SQL datatype and a currency Access datatype. I have to use the single quotes '#whatever#' for Access and no single quotes #whatever# for SQL 2000.  So is it possible to have an app run on both databases without any code changes or is the way I am doing it now the only way possible. Thanks, Rich ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
07/13/2001 05:47 PM
Author: Erika Foster Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:5021#21971 We changed the setting in the regedit file for maxfilelock and it seems to have taken care of the problem.... hopefully. Thanks to all for the help on this! Erika : Do you have the exact error message?  Maybe try this: : : http://support.microsoft.com/support/kb/articles/Q209/9/40.ASP?LN=EN-US&SD=g : n&FR=0&qry=disk%20space&rnk=4&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000 : : Todd Ashworth -- : Certified ColdFusion Developer : Network Administrator : : Saber Corporation : 314 Oakland Ave. : Rock Hill, SC 29730 : (803) 327-0137 [111] : ----- Original Message ----- : From: "Erika Foster" <efoster@e2m.net> : To: "CF-Talk" <cf-talk@houseoffusion.com> : Sent: Friday, July 13, 2001 9:58 AM : Subject: Re: Out of Space? - More Info : : : | Okay, troubleshooting this from 1000 miles away over the phone bites. : | : | 1. Its an Access 2000 DB : | 2. The DB is only 1.5 MB : | 3. It will insert records into all tables but one. : | 4. This particular table has 4762 records : | 5. They are able to update records in that table. : | 6. The .mdb and the .ldb files are on the same drive, in the same : directory. : | 7. The drive its on has many GIG of free space. : | 8. We've stopped CF services and restarted, and we've rebooted. : | : | Under the gun here because they need to teach a class on this app tomorrow : | morning! : | : | Any ideas? : | : | THANK YOU! : | Erika Foster : | engineering-environmental Management : | Applications Developer : | (505) 866-1654 : | efoster@e2m.net : | ----- Original Message ----- : | From: "Erika Foster" <efoster@e2m.net> : | To: "CF-Talk" <cf-talk@houseoffusion.com> : | Sent: Friday, July 13, 2001 6:46 AM : | Subject: Re: Out of Space? : | : | : | : Its an Access Database and its about 6mb in size. : | : : | : Ben, I'll check out the .ldb possibility. : | : : | : Thanks! : | : : | : Erika : | : : | : ----- Original Message ----- : | : From: "Kevin Gilchrist" <KGilchrist@redsiren.com> : | : To: "CF-Talk" <cf-talk@houseoffusion.com> : | : Sent: Friday, July 13, 2001 11:04 AM : | : Subject: RE: Out of Space? : | : : | : : | : : What kind of database is it? : | : : : | : : -----Original Message----- : | : : : | : : Sent: Friday, July 13, 2001 8:16 AM : | : : To: CF-Talk : | : : Subject: Out of Space? : | : : : | : : : | : : I have a client who is getting an Disk Space error when trying to add : or : | : : update the database.  They have a couple GIG of empty space on this : | disk. : | : : I'm off site right now and can't do any troubleshooting on the : machine. : | : : : | : : Any suggestions?  What's going on? : | : : : | : : Thanks! : | : : : | : : Erika Foster : | : : engineering-environmental Management : | : : Applications Developer : | : : (505) 866-1654 : | : : efoster@e2m.net : | : : : | : : | : ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
07/13/2001 05:32 PM
Author: Dick Applebaum Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:5021#21970 Anybody know a site where one can view the CF 5.0 docs online? I have a quick question about cfobject and don't want to go through a download and install to get an answer. Dick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
07/13/2001 05:16 PM
Author: Rich Tretola Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:5021#21967 Question about SQL 2000 and Access 2000. Is it possible to have an application that will run using either Access 2000 or SQL 2000 DB? I am having trouble with datatypes when it comes to money. For example I have an update query that updates a money SQL datatype and a currency Access datatype. I have to use the single quotes '#whatever#' for Access and no single quotes #whatever# for SQL 2000.  So is it possible to have an app run on both databases without any code changes or is the way I am doing it now the only way possible. Thanks, Rich ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
07/13/2001 04:58 PM
Author: Braver, Ben Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:5021#21964 If it's just one table, check this: You can set the AllowAdditions property under the Data tab of the form's property sheet. The default setting is Yes (True or -1), and this setting allows the user to add new records. If you set this property to No (False or 0), the user cannot add new records. The No setting disables the New Record indicator on the toolbar and the Data Entry command on the Records menu. (Article ID: Q208586) -Ben What about the boot drive of the PC?  Access creates temp files there... Howie ----- Excess quoted text cut - see Original Post for more ----- directory. ----- Excess quoted text cut - see Original Post for more ----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
07/13/2001 04:58 PM
Author: Shawn Grover Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:5021#21965 Have you looked at the Windows Swap file?  On an NT server, sometimes it can grow to be too large, and eat up all the space on the drive it's located on. Reboot should have fixed it though. Try this - use a CFABORT on the page that throws the error.  Start at the top, try the page.  After each successful try, move the abort down past the next logical block of code (i.e. CFSET shouldn't throw this error, so you might be able to skip a bunch of lines at once.)  Keep doing this until you hit the error.  When the error occurs, you've just identified the line (or area) that is throwing the error. At this point, you can look into that command some more.  See if there is anything odd with it.  Dump any variables that you may be using in that command, are the values being passed likely to cause errors? I'm sure you have already done this, but we need to start someplace. Next, if you are on an NT server, look at the event log.  See if anything helpful can be found there. Try a scandisk, see if any problems are present on the drive. That's about all I can think about off the top of my head.  Good luck in your search. Shawn Okay, troubleshooting this from 1000 miles away over the phone bites. 1. Its an Access 2000 DB 2. The DB is only 1.5 MB 3. It will insert records into all tables but one. 4. This particular table has 4762 records 5. They are able to update records in that table. 6. The .mdb and the .ldb files are on the same drive, in the same directory. 7. The drive its on has many GIG of free space. 8. We've stopped CF services and restarted, and we've rebooted. Under the gun here because they need to teach a class on this app tomorrow morning! Any ideas? THANK YOU! Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 efoster@e2m.net : Its an Access Database and its about 6mb in size. : : Ben, I'll check out the .ldb possibility. : : Thanks! : : Erika : : ----- Original Message ----- : From: "Kevin Gilchrist" <KGilchrist@redsiren.com> : To: "CF-Talk" <cf-talk@houseoffusion.com> : Sent: Friday, July 13, 2001 11:04 AM : Subject: RE: Out of Space? : : : : What kind of database is it? : : : : -----Original Message----- : : : : Sent: Friday, July 13, 2001 8:16 AM : : To: CF-Talk : : Subject: Out of Space? : : : : : : I have a client who is getting an Disk Space error when trying to add or : : update the database.  They have a couple GIG of empty space on this disk. : : I'm off site right now and can't do any troubleshooting on the machine. : : : : Any suggestions?  What's going on? : : : : Thanks! : : : : Erika Foster : : engineering-environmental Management : : Applications Developer : : (505) 866-1654 : : efoster@e2m.net : : : ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
07/13/2001 04:57 PM
Author: Erika Foster Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:5021#21963 Thanks, Janine Upon further troubleshooting, we've figured out that we can delete a record, and then add it back in.  But, we cannot add anymore than the one we deleted.  If we delete 10 records, we can add 10 more.  So, this leads me to believe it has everything to do with the size of the table - am I correct in assuming this?? So we just edited the maxfilelock property in the regedit.exe file according to the MS article that Todd sent (thanks Todd!). Waiting on a return call to see if that fixes the problem. Erika : 1.It may actually be something with the table itself and not the disk space. : What type of fields are being used?  Is is a local table or does it have a : different database backend?  I have seen weird things happen depending on : what datatypes are being used. (In access I stay strictly with text/number). : For example regular checkboxes on Access upsized to SQL become bit datatype. : And bit couldn't have a null so suddenly lots of error/no data entry : allowed. : 2.  Has anyone changed any field sizes? Make sure those all match up between : tables and between tables and forms. (again because the integrity isn't : there simple things like field size matters) : 3.  Are they trying to update/insert through the table or through a form? : If it's through a form it may actually be the query that is causing the : problem. : : I don't know how many fields are included in your table but one thing you : can do is make a new table and dump the data into it. : : I really doubt it has anything to do with the amount of records you have in : the database.  I've seen bigger tables run smoothly.  Don't know if this is : any help, good luck! : : : -----Original Message----- : : Sent: Friday, July 13, 2001 9:58 AM : To: CF-Talk : Subject: Re: Out of Space? - More Info : : : Okay, troubleshooting this from 1000 miles away over the phone bites. : : 1. Its an Access 2000 DB : 2. The DB is only 1.5 MB : 3. It will insert records into all tables but one. : 4. This particular table has 4762 records : 5. They are able to update records in that table. : 6. The .mdb and the .ldb files are on the same drive, in the same directory. : 7. The drive its on has many GIG of free space. : 8. We've stopped CF services and restarted, and we've rebooted. : : Under the gun here because they need to teach a class on this app tomorrow : morning! : : Any ideas? : : THANK YOU! : Erika Foster : engineering-environmental Management : Applications Developer : (505) 866-1654 : efoster@e2m.net : ----- Original Message ----- : From: "Erika Foster" <efoster@e2m.net> : To: "CF-Talk" <cf-talk@houseoffusion.com> : Sent: Friday, July 13, 2001 6:46 AM : Subject: Re: Out of Space? : : : : Its an Access Database and its about 6mb in size. : : : : Ben, I'll check out the .ldb possibility. : : : : Thanks! : : : : Erika : : : : ----- Original Message ----- : : From: "Kevin Gilchrist" <KGilchrist@redsiren.com> : : To: "CF-Talk" <cf-talk@houseoffusion.com> : : Sent: Friday, July 13, 2001 11:04 AM : : Subject: RE: Out of Space? : : : : : : : What kind of database is it? : : : : : : -----Original Message----- : : : : : : Sent: Friday, July 13, 2001 8:16 AM : : : To: CF-Talk : : : Subject: Out of Space? : : : : : : : : : I have a client who is getting an Disk Space error when trying to add or : : : update the database.  They have a couple GIG of empty space on this : disk. : : : I'm off site right now and can't do any troubleshooting on the machine. : : : : : : Any suggestions?  What's going on? : : : : : : Thanks! : : : : : : Erika Foster : : : engineering-environmental Management : : : Applications Developer : : : (505) 866-1654 : : : efoster@e2m.net : : : : : : ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
07/13/2001 04:27 PM
Author: Saidi; Marwan Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:5021#21960 Shot in the dark, but can you try this: Open CF Administrator Open ODBC Open the datasource in question Open CFSettings Remove the check for "Maintain Database Connections" Check the box for "Disable Database Connection" Update. You should(?) get a verification failed. Reopen the Datasource Uncheck "Disable...." Recheck "Maintain...." It should now work. Maybe. Just ran into something similar, and this worked for me. Marwan Okay, troubleshooting this from 1000 miles away over the phone bites. 1. Its an Access 2000 DB 2. The DB is only 1.5 MB 3. It will insert records into all tables but one. 4. This particular table has 4762 records 5. They are able to update records in that table. 6. The .mdb and the .ldb files are on the same drive, in the same directory. 7. The drive its on has many GIG of free space. 8. We've stopped CF services and restarted, and we've rebooted. Under the gun here because they need to teach a class on this app tomorrow morning! Any ideas? ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
07/13/2001 04:24 PM
Author: Howie Hamlin Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:5021#21957 What about the boot drive of the PC?  Access creates temp files there... Howie ----- Excess quoted text cut - see Original Post for more ----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
07/13/2001 04:24 PM
Author: Todd Ashworth Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:5021#21958 Do you have the exact error message?  Maybe try this: http://support.microsoft.com/support/kb/articles/Q209/9/40.ASP?LN=EN-US&SD=g n&FR=0&qry=disk%20space&rnk=4&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000 Todd Ashworth -- Certified ColdFusion Developer Network Administrator Saber Corporation 314 Oakland Ave. Rock Hill, SC 29730 (803) 327-0137 [111] | Okay, troubleshooting this from 1000 miles away over the phone bites. | | 1. Its an Access 2000 DB | 2. The DB is only 1.5 MB | 3. It will insert records into all tables but one. | 4. This particular table has 4762 records | 5. They are able to update records in that table. | 6. The .mdb and the .ldb files are on the same drive, in the same directory. | 7. The drive its on has many GIG of free space. | 8. We've stopped CF services and restarted, and we've rebooted. | | Under the gun here because they need to teach a class on this app tomorrow | morning! | | Any ideas? | | THANK YOU! | Erika Foster | engineering-environmental Management | Applications Developer | (505) 866-1654 | efoster@e2m.net | ----- Original Message ----- | From: "Erika Foster" <efoster@e2m.net> | To: "CF-Talk" <cf-talk@houseoffusion.com> | Sent: Friday, July 13, 2001 6:46 AM | Subject: Re: Out of Space? | | | : Its an Access Database and its about 6mb in size. | : | : Ben, I'll check out the .ldb possibility. | : | : Thanks! | : | : Erika | : | : ----- Original Message ----- | : From: "Kevin Gilchrist" <KGilchrist@redsiren.com> | : To: "CF-Talk" <cf-talk@houseoffusion.com> | : Sent: Friday, July 13, 2001 11:04 AM | : Subject: RE: Out of Space? | : | : | : : What kind of database is it? | : : | : : -----Original Message----- | : : | : : Sent: Friday, July 13, 2001 8:16 AM | : : To: CF-Talk | : : Subject: Out of Space? | : : | : : | : : I have a client who is getting an Disk Space error when trying to add or | : : update the database.  They have a couple GIG of empty space on this | disk. | : : I'm off site right now and can't do any troubleshooting on the machine. | : : | : : Any suggestions?  What's going on? | : : | : : Thanks! | : : | : : Erika Foster | : : engineering-environmental Management | : : Applications Developer | : : (505) 866-1654 | : : efoster@e2m.net | : : | : | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
07/13/2001 04:23 PM
Author: Dylan Bromby Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:5021#21956 are there any other drive dependencies? for logs? for file writes? Okay, troubleshooting this from 1000 miles away over the phone bites. 1. Its an Access 2000 DB 2. The DB is only 1.5 MB 3. It will insert records into all tables but one. 4. This particular table has 4762 records 5. They are able to update records in that table. 6. The .mdb and the .ldb files are on the same drive, in the same directory. 7. The drive its on has many GIG of free space. 8. We've stopped CF services and restarted, and we've rebooted. Under the gun here because they need to teach a class on this app tomorrow morning! Any ideas? THANK YOU! Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 efoster@e2m.net : Its an Access Database and its about 6mb in size. : : Ben, I'll check out the .ldb possibility. : : Thanks! : : Erika : : ----- Original Message ----- : From: "Kevin Gilchrist" <KGilchrist@redsiren.com> : To: "CF-Talk" <cf-talk@houseoffusion.com> : Sent: Friday, July 13, 2001 11:04 AM : Subject: RE: Out of Space? : : : : What kind of database is it? : : : : -----Original Message----- : : : : Sent: Friday, July 13, 2001 8:16 AM : : To: CF-Talk : : Subject: Out of Space? : : : : : : I have a client who is getting an Disk Space error when trying to add or : : update the database.  They have a couple GIG of empty space on this disk. : : I'm off site right now and can't do any troubleshooting on the machine. : : : : Any suggestions?  What's going on? : : : : Thanks! : : : : Erika Foster : : engineering-environmental Management : : Applications Developer : : (505) 866-1654 : : efoster@e2m.net : : : ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
07/13/2001 04:22 PM
Author: Janine Jakim Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:5021#21955 1.It may actually be something with the table itself and not the disk space. What type of fields are being used?  Is is a local table or does it have a different database backend?  I have seen weird things happen depending on what datatypes are being used. (In access I stay strictly with text/number). For example regular checkboxes on Access upsized to SQL become bit datatype. And bit couldn't have a null so suddenly lots of error/no data entry allowed. 2.  Has anyone changed any field sizes? Make sure those all match up between tables and between tables and forms. (again because the integrity isn't there simple things like field size matters) 3.  Are they trying to update/insert through the table or through a form? If it's through a form it may actually be the query that is causing the problem. I don't know how many fields are included in your table but one thing you can do is make a new table and dump the data into it.   I really doubt it has anything to do with the amount of records you have in the database.  I've seen bigger tables run smoothly.  Don't know if this is any help, good luck! Okay, troubleshooting this from 1000 miles away over the phone bites. 1. Its an Access 2000 DB 2. The DB is only 1.5 MB 3. It will insert records into all tables but one. 4. This particular table has 4762 records 5. They are able to update records in that table. 6. The .mdb and the .ldb files are on the same drive, in the same directory. 7. The drive its on has many GIG of free space. 8. We've stopped CF services and restarted, and we've rebooted. Under the gun here because they need to teach a class on this app tomorrow morning! Any ideas? THANK YOU! Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 efoster@e2m.net : Its an Access Database and its about 6mb in size. : : Ben, I'll check out the .ldb possibility. : : Thanks! : : Erika : : ----- Original Message ----- : From: "Kevin Gilchrist" <KGilchrist@redsiren.com> : To: "CF-Talk" <cf-talk@houseoffusion.com> : Sent: Friday, July 13, 2001 11:04 AM : Subject: RE: Out of Space? : : : : What kind of database is it? : : : : -----Original Message----- : : : : Sent: Friday, July 13, 2001 8:16 AM : : To: CF-Talk : : Subject: Out of Space? : : : : : : I have a client who is getting an Disk Space error when trying to add or : : update the database.  They have a couple GIG of empty space on this disk. : : I'm off site right now and can't do any troubleshooting on the machine. : : : : Any suggestions?  What's going on? : : : : Thanks! : : : : Erika Foster : : engineering-environmental Management : : Applications Developer : : (505) 866-1654 : : efoster@e2m.net : : : ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
07/13/2001 02:52 PM
Author: Erika Foster Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:5021#21941 Okay, troubleshooting this from 1000 miles away over the phone bites. 1. Its an Access 2000 DB 2. The DB is only 1.5 MB 3. It will insert records into all tables but one. 4. This particular table has 4762 records 5. They are able to update records in that table. 6. The .mdb and the .ldb files are on the same drive, in the same directory. 7. The drive its on has many GIG of free space. 8. We've stopped CF services and restarted, and we've rebooted. Under the gun here because they need to teach a class on this app tomorrow morning! Any ideas? THANK YOU! Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 efoster@e2m.net : Its an Access Database and its about 6mb in size. : : Ben, I'll check out the .ldb possibility. : : Thanks! : : Erika : : ----- Original Message ----- : From: "Kevin Gilchrist" <KGilchrist@redsiren.com> : To: "CF-Talk" <cf-talk@houseoffusion.com> : Sent: Friday, July 13, 2001 11:04 AM : Subject: RE: Out of Space? : : : : What kind of database is it? : : : : -----Original Message----- : : : : Sent: Friday, July 13, 2001 8:16 AM : : To: CF-Talk : : Subject: Out of Space? : : : : : : I have a client who is getting an Disk Space error when trying to add or : : update the database.  They have a couple GIG of empty space on this disk. : : I'm off site right now and can't do any troubleshooting on the machine. : : : : Any suggestions?  What's going on? : : : : Thanks! : : : : Erika Foster : : engineering-environmental Management : : Applications Developer : : (505) 866-1654 : : efoster@e2m.net : : : ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
07/13/2001 01:26 PM
Author: Erika Foster Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:5021#21931 Its an Access Database and its about 6mb in size. Ben, I'll check out the .ldb possibility. Thanks! Erika : What kind of database is it? : : -----Original Message----- : : Sent: Friday, July 13, 2001 8:16 AM : To: CF-Talk : Subject: Out of Space? : : : I have a client who is getting an Disk Space error when trying to add or : update the database.  They have a couple GIG of empty space on this disk. : I'm off site right now and can't do any troubleshooting on the machine. : : Any suggestions?  What's going on? : : Thanks! : : Erika Foster : engineering-environmental Management : Applications Developer : (505) 866-1654 : efoster@e2m.net : ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
07/13/2001 01:12 PM
Author: Kevin Gilchrist Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:5021#21924 What kind of database is it? I have a client who is getting an Disk Space error when trying to add or update the database.  They have a couple GIG of empty space on this disk. I'm off site right now and can't do any troubleshooting on the machine. Any suggestions?  What's going on? Thanks! Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 efoster@e2m.net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
07/13/2001 01:12 PM
Author: Braver, Ben Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:5021#21925 Erika, Have seen problems where the db is on a D: drive, but temp directory is on C: and the C: drive is almost full. If something needs space in a temp file and can't get it, the whole operation can fail. HTH. Ben I have a client who is getting an Disk Space error when trying to add or update the database.  They have a couple GIG of empty space on this disk. I'm off site right now and can't do any troubleshooting on the machine. Any suggestions?  What's going on? Thanks! Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 efoster@e2m.net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
07/13/2001 01:12 PM
Author: Brian Fox Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:5021#21926 What database software?  Some light weight software packages have size limits.  For example, there is a 2 GB file size limitation on Access databases not using linked tables.   ----- Excess quoted text cut - see Original Post for more ----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
07/13/2001 12:55 PM
Author: Erika Foster Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:5021#21923 I have a client who is getting an Disk Space error when trying to add or update the database.  They have a couple GIG of empty space on this disk. I'm off site right now and can't do any troubleshooting on the machine. Any suggestions?  What's going on? Thanks! Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 efoster@e2m.net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
<< Previous Thread Today's Threads Next Thread >>

Search cf-talk

May 24, 2012

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
     1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31     

Designer, Developer and mobile workflow conference

Latest Fusion Authority Articles

Designer, Developer and mobile workflow conference

Want a number like 800-ColdFusion?

My Toll Free 800 Number provides a vanity phone number service to clients who want more than just digits. How would you like 800-coldfusion?

www.MyTollFree800Number.com