Make table queries- getting invalid argument message

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top