Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old August 8th, 2003, 11:36 AM
Registered User
 
Join Date: Jul 2003
Location: Monroe, CT, USA.
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Invalid Argument....

We are having problems running Access 2000 under XP. I have run Access since the days of ver 2 and have never ran into the problems in previous versions. I do a lot of number crunching so my db's get up there in size but I have never lost one. but just today I was working way in one and got this message(again) ... invalid argument which from recent problems tells me exit the db cold boot the pc and go back in.. to get back as much of the ram as I can before the system crashes. I don't have this problem running under windows 98 with access 2000 just xp. any thoughts out there?
Thanks
Bill

Reply With Quote
  #2 (permalink)  
Old August 8th, 2003, 12:07 PM
Friend of Wrox
 
Join Date: Jul 2003
Location: Houston, Texas, USA.
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

What does your XP system have on it? Although MS states (http://support.microsoft.com/default...b;en-us;314865) you only need 64 megs of RAM (preferably 128), At home I have XP on XP and my system has 256 megs and I wouldn't go any lower as it can still be slow... At the office I use XP/XP and Access 2K with 512 megs of RAM. XP is especially slow when checking on properties.

Anyway, check your RAM & processor speeds and if needed, increase. When you upsize your OS, you usually need to add more RAM.

HTH,

Beth
PS I haven't had any of the errors arise which you are referencing and I've been using the Win XP OS with Access 2K and Access XP on the same system for over a year.
Reply With Quote
  #3 (permalink)  
Old August 8th, 2003, 03:27 PM
Friend of Wrox
 
Join Date: Jul 2003
Location: Houston, Texas, USA.
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I don't know if this would be relevant to you, but as a follow up, MS also acknowledged and issue with Jet. Memory Use Climbs with Multiple Recordsets Under a Single Jet Session/Connection http://support.microsoft.com/default...b;EN-US;247140
"Microsoft Jet 4.0 is not releasing cached resources until the parent database connection is closed. Note that this is not a memory leak; rather, this is a resource allocation that is never freed until the parent object is closed."
You might also want to look at the "References" at the bottom of http://support.microsoft.com/default...b;en-us;239114
regarding Jet 4.0 SP7.

Regards,

Beth
Reply With Quote
  #4 (permalink)  
Old September 15th, 2003, 08:58 AM
Registered User
 
Join Date: Sep 2003
Location: Ft. Lauderdale, Fl, .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I was wondering if you found a solution to your invalid argument problem. I am getting it now on updating my Access database. I have never had trouble updating before, but these are new tables, but can't imagine what I could have set up wrong. I have tried keyset, dynamic and static for cursor types. Nothing works, on my first update I keep getting that error with no specific code numbers. Very frustrating!!!!

Resistance is Futile!
Reply With Quote
  #5 (permalink)  
Old April 27th, 2004, 06:18 AM
Registered User
 
Join Date: Apr 2004
Location: Petaling Jaya, Selangor, Malaysia.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Try to implement one of the solution.

http://support.microsoft.com/default...b;EN-US;835416

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Invalid argument supplied for foreach() codejockey Beginning PHP 4 September 24th, 2010 03:40 AM
Invalid postback or callback argument mallikalapati ASP.NET 2.0 Professional 4 February 20th, 2008 08:38 AM
Invalid Argument ppenn Access VBA 2 May 14th, 2007 10:11 AM
Invalid postback or callback argument everest ASP.NET 2.0 Professional 2 January 9th, 2007 08:28 AM
Invalid postback or callback argument. kingw BOOK: Professional Ajax ISBN: 978-0-471-77778-6 1 January 1st, 2007 09:49 PM



All times are GMT -4. The time now is 09:59 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.