limited number of db in a project?

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

Guest

Access 2003

I have many(21) Db and queries etc in a project (what do you call the
overall collection of these objects?)

I am attempting to creat another "Make Query Table" but I am olny allowed to
enter 4 fields on the design page. If I enter more there is error message:
"invladi argument." Could I have exceeded the number of db, queries, form in
my project?
 
An Access database (mdb file) generally contains tables, queries, code,
forms, reports,... You should be able to add 100s of each of these with no
issues. Tables can contain up to 255 fields (about 230 too many).
 
Thanks, you're right I can have many tables, etc.
Funny, thing is I still get the error message if a "run" a query multiply
times in a rowbecaue I'm adding creteria a little at a time to review the
results. If I exit access, then return to access, I am able to sidesteep the
problem. What's with that?
 
"That" is:
if I run an "Append Query" multiple times in a row, I get an error "Invalid
Argument." If I log out of ACCESS then log back in, it clears the problem. It
must have something to do with the clipboard being full?
 
It sounds like you might have an issue with corruption. Is there anything
special about the append query(s)? What's up with the "clipboard" comment?
There was no mention earlier about using the clipboard.
 
I thought that maybe the program used a clipboard-like proocess to make the
append table. After all it seems to be the repetition that cause the problem.
It seems like if I run a query with a large data result the error occures
quicker than if I run a smaller one.
the query I can't see that there is anything specvial about the append
queries I have created. They are simple enough that even I, with limited
experiance, was able to creat them.
By corruption you mean a virus or a program issue or.....
 
So should I just start over? The information on the link is too complicated
for me to undersdtand.
 
If you think you have corruption, try create a new, blank mdb and import all
your objects into it.
 
Back
Top