RE: Access XP: "Invalid Argument" error in make table, append queries

  • Thread starter Janet Chisholm [MSFT]
  • Start date
J

Janet Chisholm [MSFT]

Hi,

What is the size of the database when you attempt to complete one of these
tasks? You can experience this error if you are reaching the size limit
(Access XP - 2 GIG) of the database.

If this is the case, then you might want to make a copy of the database and
try to compact the copy (Tools/Database Utilities). This may reduce the
size of the file so that you can complete the action items that you need.
However, you will then want to examine splitting the database or moving to
another program (such as SQL Server) that has greater storage capabilities.

Hope this helps!

Thank you,
Janet Chisholm

This posting is provided "AS IS" with no warranties, and confers no rights.
 

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

Top