Re: cant save database
- From: John Nurick <j.mapSoN.nurick@xxxxxxxxxxxxxx>
- Date: Thu, 01 Mar 2007 06:11:55 +0000
How many columns (fields) are in the table? Does the problem go away
when you compact and repair the database?
On Wed, 28 Feb 2007 14:37:11 -0800, JRS <JRS@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
I am importing a refreshed table that I import every month. The next thing I
do is change a few of the fieds from 255 to 2. when I attempt to save it I
get a message that I don't have enough memory or disk space and that is not
the case. The help message is like below....I did not change any index.
what can I do? thank you
This error can appear if:
You have exceeded the maximum number of columns allowed in a table or the
maximum number of locks for a single file.
The indexed property of a field was changed from Yes (Duplicates OK) to Yes
(No Duplicates) when duplicate data is already present in the table.
If a table exceeded the maximum number of columns, close the database,
select Compact and Repair from the Tools - Database Utilities menu option.
This will remove column references from a table definition that were marked
as deleted (deletions do not actually occur until the database is compacted
and therefore they contribute to the column count).
If the maximum number of locks per file was exceeded, you can increase the
number by editing a registry entry for the local computer. However, this is
not a recommended option.
Find the MaxLocksPerFile registry value using the Windows registry editor
(regedit.exe) and increase the value.
The MaxLocksPerFile value is stored as part of the following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0
If you edit a value in the Windows registry, there is no guarantee that the
change will not corrupt the registry and render Windows unusable. Edit the
registry at your own risk. If you do, it is highly recommended you make a
backup of the registry before performing any edits.
If you have changed the Indexed property of a field and duplicate data
already exists in the table, you can either reset the Indexed property back
to the previous setting, or remove the duplicate records from the table.
--
John Nurick [Microsoft Access MVP]
Please respond in the newsgroup and not by email.
.
- Prev by Date: Re: Problem with repeated Replace function editing HTMLBody
- Next by Date: Re: Archive data to another Access DB ?
- Previous by thread: Re: Problem with repeated Replace function editing HTMLBody
- Next by thread: Re: cant save database
- Index(es):
Relevant Pages
|
