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
