sub form records causing errors

  • Thread starter Thread starter JamesSF
  • Start date Start date
J

JamesSF

Hello

I have a database i just converted from 97 to 2k3.

there are some forms with child forms on them that when a user adds a new
record to a subform, an error occurs saying 'you and another user are
trying to change the data'. the entry #names out and the record selector
shows the circle with a slash.

this was not happening under 97. the tables have refential entegrity
enforced. If you crash out of the database and re-enter, the data is there
in the subform and additional records can be added, its just the first
record.

any ideas?

thanks
JamesSF
 
Your symptoms suggest that there is no good reason for the multi-user clash
issue, so it is likely that this is the result of a corruption. This kind of
corruption is fairly common in Access 2000 and later if you have Name
AutoCorrect enabled.

To fix the problem:
1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get completely rid of this junk:
Tools | Database Utilities | Compact

3. Close Access. Make a backup copy of the mdb file.

4. Decompile a copy of the database by entering something like this at the
command prompt while Access is not running. It is all one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

5. Compact again.

6. Press Ctrl+G to open a code window. Choose References on the Tools menu.
Remove any references you do not need. If your database came from Access 97,
you probably need only:
VBA
Access 11
DAO 3.6
More info on references:
http://allenbrowne.com/ser-38.html

7. Close the References dialog, and choose Compile from the Debug menu. If
Access reports any problem, fix it, and repeat until it compiles okay.

At this stage you should have a database without the corruption. Post back
for further instructions of the above sequence does not solve the issue.
 
Back
Top