The problem is with accessing the database in VisData in VB, not with my program. It works fine, as always, which is why the error in VisData is puzzling.
On another application I ran into a new error. Basically this program simply reads and writes records to an Access DB. The only thing that ever changes is the number of fields. The average number of fields is usually about 70-80. With only 3 fields, in the past, I ran into similar behavior. I posted messages about it and you all helped me quite a bit, as to how to avoid this type of error due to a single form program utilizing initialize and load routines for code that belonged in a sub main. With 145 fields, similar behavior starts again. What happens is field.change fires when the first record is read, so I had to put a flag in to bypass that when the database is first loaded. I understand why, I just don't understand why it does it with certain numbers of fields in the field() array, and not with 70 or so. It is just puzzling because the code is exactly the same except the number of fields has changed. It makes sense to me that the change routine fires. What doesn't make sense to me is why didn't I ever get that kind of error before... [C] --- In [email protected], "HouseDad" <[EMAIL PROTECTED]> wrote: > > > > Hi all! > > I am using the first application I ever wrote in VB, which I > have used in modified forms many times, and something happened today > I've never seen in the past. > > After loading the Access DB, I try to open the table, and I get > an error: > > "Overflow Number: 6" > > then, > > "Object was unloaded, number 364" > > There is no help available that I have found, tried hitting F1 > to no avail. > > What could be going on here? The program itself seems to be > working fine, I just always load the DB in VisData to take a look at > the structure to see if I missed anything. All the fields seems to > be functioning and working in the application itself. > > What is the significance of the "6" in the error msg? > > As always, thanks in advance! > > [C] '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [email protected] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
