I am experiencing a problem with all of my queries that are sorted by a field. I am getting an "Invalid Argument" message whenever there are other users in the database when trying to run the query. When I take the sort off, the query runs with no problem. Anyone have an idea as to what this is and how to solve it?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sorting
- Thread starter bob120579
- Start date
Yes, (well an educated guess)
When you sort, Access must scan through all records in your database to work out the sorted order.
One or more of your users are opening a record with deny read so you cannot read it.
If your sort works when no other users are in the database then I have a fair chance of being right.
When you sort, Access must scan through all records in your database to work out the sorted order.
One or more of your users are opening a record with deny read so you cannot read it.
If your sort works when no other users are in the database then I have a fair chance of being right.
- Thread starter
- #3
- Thread starter
- #5
I really do not think it is due to a deny read, because even with other users accessing the same table, you can still read the data from the table, just not sort it. I tend to think it is the way the RecordSet is opened when the the open form is accessing it. Does anyone have any suggestions?
ProgramError
Programmer
I think PCLewis is right regarding the access to all records. When a database is opened, it is opened in lock all records or lock record being edited. You my need to check this.
help also says...
I get the message "Invalid argument."
In the regional settings of Microsoft Windows Control Panel, your location is set to a region that uses a character other than a period (.) as a decimal separator. The settings for properties in data access pages require that the decimal separator be a period for all languages. Either change the region or set the decimal symbol to a period in Windows Control Panel regional settings.
The value you typed in the property sheet does not match the data type of the property. For example, the Width property of a section can be set to any number, but if you type a string such as Narrow, you will get the "Invalid argument" message
Ian M
Program Error
Programmers do it one finger at a time!
help also says...
I get the message "Invalid argument."
In the regional settings of Microsoft Windows Control Panel, your location is set to a region that uses a character other than a period (.) as a decimal separator. The settings for properties in data access pages require that the decimal separator be a period for all languages. Either change the region or set the decimal symbol to a period in Windows Control Panel regional settings.
The value you typed in the property sheet does not match the data type of the property. For example, the Width property of a section can be set to any number, but if you type a string such as Narrow, you will get the "Invalid argument" message
Ian M
Program Error
Programmers do it one finger at a time!
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question