Re: Disk or Network Error
What version of Access are you using? 97 / 2000 or later?
Is your setup an EXE connecting to an Access database, all on the same machine?
Re: Disk or Network Error
Hello!
I faced this problem earlier while working with Access database. In my case this problem occurred when hard disk (in which database is located) goes out of space.
Re: Disk or Network Error
The database is Access XP and it is on the same PC. Upon further testing, the problem only occurs when going to runtime with VB. If I compile the program and run the exe from the same folder there is no problem. So it looks like the end user will not see this problem and therefore a solution would be nice but not essential.
Re: Disk or Network Error
how much emory does the ide use up when you run this query? how long does it take?
access.. hmm.. have you thought about MSDE?
Re: Disk or Network Error
As you have mentioned that this issue usually occurs on a server (dealing with the Temp directory
being utilized by Access and other programs). It could be that the system is running low on
resources? Perhaps thats why it fails on large recordsets?