Data Table Issues

[Luvflt]

I am using a .adp data base program. I have a data table that is just now starting to give me trouble. When I do an advanced filter by form search and try to make a change to a record and then save the table it times out. I have currently 18,630 records in this table. I got a temporary work around by exporting the table to an .xls file, changing the record then importing the table back in (under a different name so as not to corrupt the original table). I noticed that when it did the import it only imported 10,000 records. Am I over the limit some how or is there a place I need to adjust the size of the table? I seem to remember awhile back I had to make an adjustment to a data table size but I can't seem to remember how I did that or if that is even the issue. Any help would be appreciated. I am not real fluent in all this database stuff but know enough to be dangerous!!

[ssanfu]

18,630 records in this table

For a database, that is nothing.

Am I over the limit some how or is there a place I need to adjust the size of the table?

I would guess you are connected to a SQL Server dB. There is no limit on the number of records; just limited by the amount of drive space.

You can read data, but not write data. That is a hard one to diagnose remotely.
Could be a permissions issue. Have there been any changes made to the location of the server?

[Luvflt]

For a database, that is nothing.


I would guess you are connected to a SQL Server dB. There is no limit on the number of records; just limited by the amount of drive space.

You can read data, but not write data. That is a hard one to diagnose remotely.
Could be a permissions issue. Have there been any changes made to the location of the server?

I found this situation is intermittent. I am also coming up with "Query Timeout expired". I now realize it has nothing to do with the size as another table only had 267 records and there were issues with adding to this table as well. I read where one could increase the time out from 60 seconds to 120 seconds. I saw the command to do that but not sure where one would use that command. The other things was I shut down and restarted the server as we do run with a SQL Server. I wish I could add more but for now I just need to see if resetting the server made the difference or not. Other than that nothing has changed and server location is the same as always. There are no apparent permission issues as I have full access. Thanks for your assistance.

[Perceptus]

I would start with Profile it in SQL with query analyzer(might have a new fancy name). Look for issues in your transaction history log.