November 2, 2005 at 10:49 am
heres the problem, I have an SQL database and it has certain tables, sp's and queries in it that contain 15000 records, now I know that by default it will only display 10000 and I know how to reset that to 0 so that it should always return all records, however it always defaults back to the 10000 when the table/sp/query is closed.
I have spoken to the host company and they keep saying that its because the object need to exist on the server, and as far as I can see they do, I can see them in the Access adp and in EM. Does anyone have the faintest idea what they are referring to?
I'm stumped as we have done similar things before and reset the defaults and they have been saved no problem.
November 2, 2005 at 11:54 am
Where are you resetting that 10K limit?
I know you can do it form by form, and you can also set for the whole application.
November 2, 2005 at 12:33 pm
where can you set the 10k limit for the whole app? at the moment i am only doing it form by form
November 2, 2005 at 12:37 pm
Tools / Options / Advanced / Max default records at the top right of the form.
November 2, 2005 at 12:56 pm
I have tried that and while you have the app open it works if you close it and reopen it it defaults back to 10k, any other ideas?
November 2, 2005 at 1:02 pm
How can that option revert back to something else???
Sounds you have a problem with access or someone's erasing the file you're working with (assuming your modifications are saved in the first place).
November 2, 2005 at 1:06 pm
I have no idea I have been tearing my hair out all day on this. the hosting company claim its because certain objects aren't on the server, but I have my doubts as to wether they know what they are talking about.
November 2, 2005 at 1:09 pm
Stop having doubts... they don't know. The number of records limitation works CLIENT SIDE and has nothing to do with the server (excluding the part where less data is fetched). Can you try to create a new blank form, save it. Close and reopen access to see if it's still there (maybe you could play with the limit while you're there).
Do you have the latest office service packs too?
November 2, 2005 at 1:23 pm
I'll give that a whirl I'll also check to see if we have the latest office packs
November 3, 2005 at 7:32 am
You can set the row limit programmatically using VBA per the following examples.
To limit the number of rows sent to the client to 100:
Application.SetOption "Row Limit", 100
To allow unlimited rows to be sent to the client:
Application.SetOption "Row Limit", 0
These examples are setting the row limit for the entire application. Note that this Application "Option" can be set over and over again. However, for your need execute this once when your application opens.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply