Saving File in Access 2007

G

Guest

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.
 
G

Guest

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).
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Maximum Columns in a table in Access 2
How many fields can you have in an access 2007 database 2
'Property value is too large' error message 3
Maximum Columns in Table 10
Col Limit in a table 3
"Maximum Number of fonts exceeded" 2
A strange error - Shouldn't it occur only while saving ? 2
Access Access 2003 - max fields in table error 2

Top