I have a simple Access file with only 6 fields. When I try to set a field to Currency I get a message that I have too many fields.
What is the problem and what is the solution?
Novice
Windows 7 64bit 
Access 2010 64bit
I have a simple Access file with only 6 fields. When I try to set a field to Currency I get a message that I have too many fields.
What is the problem and what is the solution?
VIP
Windows XP Access 2010 32bit
Never run into that before. Have you run Compact & Repair? If that doesn't fix, try creating a new table with this field set to Currency. If that works, then copy records from the original table.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows 7 64bit Access 2010 64bit
The problem is resolved. Thank you for your help.
Administrator
Windows 7 64bit Access 2010 32bit
Care to share your solution with the others that read this Forum? You could also use the Thread Tools at the top of this thread and mark this thread as Solved.
Currency Vs Double
HELP! formatting currency
Posting Permissions
Reply With Quote