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
----- Original Message -----
From: "Janine Jakim" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, July 13, 2001 1:54 PM
Subject: RE: Out of Space? - More Info
: 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-----
: From: Erika Foster [mailto:[EMAIL PROTECTED]]
: 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
: [EMAIL PROTECTED]
: ----- Original Message -----
: From: "Erika Foster" <[EMAIL PROTECTED]>
: To: "CF-Talk" <[EMAIL PROTECTED]>
: 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" <[EMAIL PROTECTED]>
: : To: "CF-Talk" <[EMAIL PROTECTED]>
: : Sent: Friday, July 13, 2001 11:04 AM
: : Subject: RE: Out of Space?
: :
: :
: : : What kind of database is it?
: : :
: : : -----Original Message-----
: : : From: Erika Foster [mailto:[EMAIL PROTECTED]]
: : : 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
: : : [EMAIL PROTECTED]
: : :
: :
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
