MS Access, help!

[dancerjodi]

I'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!

Comments

[rojagato.livejournal.com]

This will be absolutely no help: I've had problems like this in a networked environment, and it's generally due to something being changed on the server.

One thing I'd try is to copy the database to a new directory, and then see whether overwriting or creating new templates works.

[slickgothgurl.livejournal.com]

is the scratch disc full?