Make table queries- getting invalid argument message

K

KeithZ

Hi all-
I have a simple query
SELECT UnionImpInst.* INTO MktblUnionImprintInst
FROM UnionImpInst;

that will run in my database as a select query. when I change the type to a
make table query, it returns the invalid argument message. Anyone have any
thoughts on why this might be happening? I have had the problem in the past
and did a compact and repair of the database and that fixed it. That doesn't
seem to help anymore.
Thanks

keith
 
J

Jerry Whittle

If compact and repair fixed it in the past, you have corruption issues. Your
best bet is to import everything from the old database into a new mdb file.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp
 

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

"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Invalid Argument - Append Query 1
invalid argument 3
make table queries not working 1
Link to Outlook Contacts Query Invalid Argument 0
Invalid Argument (error 30001) 9
Invalid argument 4
Access 2003 - "Invalid Argument" error message 1

Top