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}
Sna?
Date: 2004-08-18 06:07 pm (UTC)No, I think its just toast. I'm getting an error related to the System 32 folder . . .