Make table queries- getting invalid argument message

[Guest]

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

 

[Guest]

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