Why do I get Invalid Argument just like that after 429 links

[Guest]

Everything was going good with a program that I have built and suddenly after
entering 429 links to pdf, it started to give me an invalid argument that it
doesnt want to save anymore. Is there any reasons? It sais invalid Argument
and don't and stops saving everything regarding the program.

Got any suggestions??

Thanks

 

[Guest]

I suggest you post the code so we can have an idea of what is happening.

 

[Guest]

it sais

Invalid argument. (Error 3001)
You tried to perform an operation that involves a routine in a DLL, and one
of the arguments to the routine is invalid. Check your entry to make sure you
have specified the correct arguments, and then try the operation again.

This error also occurs when you attempt to use mutually exclusive constants
in an argument to a method, such as specifying both dbConsistent and
dbInconsistent in the options argument to the OpenRecordset method.

Can you help me understand what this meens.??

 

[Guest]

It sais

Invalid argument. (Error 3001)
You tried to perform an operation that involves a routine in a DLL, and one
of the arguments to the routine is invalid. Check your entry to make sure you
have specified the correct arguments, and then try the operation again.

This error also occurs when you attempt to use mutually exclusive constants
in an argument to a method, such as specifying both dbConsistent and
dbInconsistent in the options argument to the OpenRecordset method.

 

[Guest]

If the code was working previously and you have made no changes to the code,
you may want to check your VBA Library References don't have any marked
missing.

It would still be helpful if you posted the actual code that is failing,
pointing out the line where it fails.

 

[Guest]

The program won't alow me to go in the startup menu and be able to add the
info in the tables. like the full menu etc. I have no access to my table at
all. It won't allow me to save or nothing.

 

[Guest]

If you are not going to post the code, I can't help you. I have asked twice,
but you are not working with me on this.

 

[Guest]

I don't understand what you are asking me, There are no codes, I cannot go in
my program cause it won't allow me to go inside de program. The problem is
that it won't let me save nothing else in my program. I have no access to
look at the codes, save or nothing. How can I get the codes give me the
guidelines and I will follow.

 

[Guest]

You said you built the program. This is a news group for Microsoft Access, A
database program.

If you program is not Access, this is not the correct place to ask the
question. If you are using Access and you built the program, why can't you
get into design mode?

 

[Guest]

YES, I am talking about Access. I have built the program but for some reason,
it won't allow me to go in the design mode at all. It keeps on telling me
invalid argument. That is what i'm asking. There is no macros or visual basic
attached to the form. Its just a plain form that I have linked to another
form that when I want to see the original document I press on it, it shows me
the pop up form and then I click on the link and it gives me the PDF link. We
have added over 400 and more PDF document to the program and just suddenly it
stopped saving. It give me the response that I have in invalid Argument and
will not be able to save. I don't know what to tell you more. I wish you
could see it cause I don't know anyone but me that knows something about
Access. I hope that this info will help you understand my situation. If you
think you can help, tell me what you want me to show you and I will but i'm
really stuck and very frustrated with the access program.

 

[Guest]

If you have either an AutoExec macro or a form running at startup, then you
can keep it from running if you hold down the Shift key when you open the
database.

When you say you are linking to the pdf files, how are you doing that? Are
you importing them into your database, are you storing the path to them, or
are you creating a Hyperlink?

 

[Guest]

Thanks, I didn't know about the shift key, now I can have access to the
inside of my database. When we want to add a pdf document what we do is we
right click on the image box and we click in insert object. We go on browse
and shoose what we need then we put a check mark on link and press ok. This
is how we insert them in the program. I'm trying to save anything on my
database and nothing seems to want to save a all, everything keeps on telling
me invalid argument and that only started after I added over 400 links to the
program. Is there something that I did wrong or didn't connect them right. I
know that I did a querry to connect the form to the pdf link form. Please
help.

thanks

 

[Guest]

Check the size of the mdb file. It coud be that the pdf files are being
imported into your mdb. The maximum size for an mdb is 2Gig.

I don't follow the process you are describing. The only time I see an image
is in form design and then it just puts the image on the form as a control.

 

[Guest]

I checked the pdf files and they only come up at 60mb but my program is a
total of 2,095,632 KB. does that make a difference. It just started to acte
weird for the last couple of days.

 

[Guest]

That is the problem. You are embedding all those pdf into your mdb. it is
over the 2 gig limit.

 

[Guest]

Well how can I keep all the data base info without loosing everything. For
the PDF, I can connect them a different way. My data base is very big and
didn't know that the Data base can only hold 2 gigs.

 

[Guest]

First, you are going to have to start over. Until you remove the PDF files
from the database, you will not be able to do anything.

You will have to create a table that has a Hyperlink data type and use that
to store a link to the files. The files will have to be external to the mdb.
I would suggest you create a folder to keep them in.

 

[Guest]

I see what you meen, I have stored them as a OLE object but they are not
really in my mdb they are in a folder and What I do is link them from there.
Doesn't it do them same cause when I add them I always go on insert object
and then put a check on link and then add the destination to where the file
is located.

 

[Guest]

I deleted all all the data that I had with pdf and I still have 1.7 gigs
left, I have lots of info in this systems. over 2000 data lines in my table.
I don't understand why it would take so much space.

 

[Dirk Goldgar]

I deleted all all the data that I had with pdf and I still have 1.7
gigs left, I have lots of info in this systems. over 2000 data lines
in my table. I don't understand why it would take so much space.

Did you compact the database after deleting?