MS Access, help!
Aug. 18th, 2004 09:47 am![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
dancerjodiI'm having this annoying problem in MS Access that I've been having for a while (only today did I work on it enough to figure out yes its a problem, and not just me being forgetful).
Each month I read in large database files (.txt format) into an Access database. They aren't so huge that Access can't handle them however. In Access I have templates saved to format the file in the proper layout - you know 'file - get external data - import' and then click advanced in the wizard to select a template.
Each year these templates change - the insurance companies add new data fields to the files. In the past I've been able to open an old template, make changes and then "save as". I should be able to either overwrite the old template or make a completely new one. This isn't working - my changes aren't saving.
Its extending to new templates too . . . I tried to just start from scratch and I wasn't able to save a new template (it saved the template under the requested name, but only saved the first field). Dammit! I need to read these files in . . . they are too big for me to manually put in column markers (40 data fields).
Has anyone ever seen this before? Perhaps its Access being buggy? Maybe I have a virus (this is the only problem I've been having)? I'm in the process of compounding/repairing the database, hoping perhaps it will help (its a large file - 1,064,512 K). It shouldn't be this big mind you . . . and trying to compact/repair just freezes everything in my computer!
Each month I read in large database files (.txt format) into an Access database. They aren't so huge that Access can't handle them however. In Access I have templates saved to format the file in the proper layout - you know 'file - get external data - import' and then click advanced in the wizard to select a template.
Each year these templates change - the insurance companies add new data fields to the files. In the past I've been able to open an old template, make changes and then "save as". I should be able to either overwrite the old template or make a completely new one. This isn't working - my changes aren't saving.
Its extending to new templates too . . . I tried to just start from scratch and I wasn't able to save a new template (it saved the template under the requested name, but only saved the first field). Dammit! I need to read these files in . . . they are too big for me to manually put in column markers (40 data fields).
Has anyone ever seen this before? Perhaps its Access being buggy? Maybe I have a virus (this is the only problem I've been having)? I'm in the process of compounding/repairing the database, hoping perhaps it will help (its a large file - 1,064,512 K). It shouldn't be this big mind you . . . and trying to compact/repair just freezes everything in my computer!
![[identity profile]](https://www.dreamwidth.org/img/silk/identity/openid.png){kind=small}
no subject
Date: 2004-08-18 07:23 am (UTC)One thing I'd try is to copy the database to a new directory, and then see whether overwriting or creating new templates works.
My access issues
Date: 2004-08-18 08:53 am (UTC)see whether overwriting or creating new templates works. "
Thanks for the advice, its worth trying anything :)
I copied the DB over and its not working. I even created a new DB from scratch, and that's not working either.
Its weird - the DBs aren't that small (don't have a lot of data in them) but my PC is making them huge. When I try to compact/repair it freezes or crashes my computer.
I think its my PC and not a network thing perhaps. Grr!
I'll keep plugging. At least my nice IS friends will be coming by this afternoon.