|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 13th, 2007, 06:49 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Saving File in Access 2007
I created a database and then wanted to add a field but got an error message:
You have exceeded the maximum number of columns allowed in a table or the maximum number of locks for a single file. I only used about 30 columns. 
|
|
#2
November 13th, 2007, 07:31 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Saving File in Access 2007
Try doing a Compact and Repair. That may fix it.
-- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "befuddled" wrote: I created a database and then wanted to add a field but got an error message: You have exceeded the maximum number of columns allowed in a table or the maximum number of locks for a single file. I only used about 30 columns.
|
|
#3
November 13th, 2007, 09:20 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Saving File in Access 2007
How do I do that? Can't find it in any of the menus. This is my first
experience with Access 2007. I was able to add fields without difficulty in the older version (98). "Jerry Whittle" wrote: Try doing a Compact and Repair. That may fix it. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "befuddled" wrote: I created a database and then wanted to add a field but got an error message: You have exceeded the maximum number of columns allowed in a table or the maximum number of locks for a single file. I only used about 30 columns.
|
|
#4
November 14th, 2007, 02:41 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Saving File in Access 2007
Click the Microsoft Office Button, point to Manage, and then, under Manage
this database, click Compact and Repair Database. That's from Help. I didn't know how to do it in A07 either! If that doesn't help, I have a couple of other trick up my sleeve. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "befuddled" wrote: How do I do that? Can't find it in any of the menus. This is my first experience with Access 2007. I was able to add fields without difficulty in the older version (98). "Jerry Whittle" wrote: Try doing a Compact and Repair. That may fix it. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "befuddled" wrote: I created a database and then wanted to add a field but got an error message: You have exceeded the maximum number of columns allowed in a table or the maximum number of locks for a single file. I only used about 30 columns.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
