Software

Ask something
Discussion Locked

invalid argument

0 helpful
3 replies

by tababcock

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am experiencing a recurring problem with Windows 2000 Access; "invalid argument". I went to Technet at Microsoft.com and was told that the error would be resolve by loading SR1a. I found that not to be successful, eventhough the problem was exactly what they described at their site. Background... this table is mainly for reports whereby, it is linked to a databased Access table, where in turn is refreshed nightly via a Unix box (oracle 7.34 ver 2.5 ODBC driver). I had this working properly until my hard drive filled up unexpectantly. I had to clean up the drive to allow for the tables. After I moved some files and uninstalled Microsoft Office and reinstalled it to a different drive, I started to get the error. The peculiar part isthat everything functions well locally. The reports, refresh and linkage perform nicely. But when I try to link to the Report tables, I recieve the menu or the initial report screen, but when i initiate a query, I start to get the "Invalid Argument". A few times I recieved a network or disc error. I checked all the permissions and access rights... they are correct. I also viewed the properties and unchecked the read only options to the tables. Just the archive is checked. The share naming convention is correct, which really doesnt matter with Win2000 stand alone desktops. I also installed the SP2 for Office 2000, as well as SR1a.

I would appreciate any help.

Thank you for your time and consideration.

3 replies

by timwalsh

It sounds to me that when you reorganized your drives, all the linked files did not end up back in the same locations relative to the database. Therefore, Access is looking for an argument that either has a bad reference or the argument itself is located where Access thinks it should be. Since it appears that you have narrowed you problem down to a specific set of operations, I would relcheck all the links and references relevant to those operations.

Hope this helps.

by tababcock

I emailed Tim and thanked him.... I will again go through and relink everything again. I want to thank you folks for the prompt answer to my question. You were a great help... thank you.

Tim

This discussion is closed to new replies.