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.

My access issues

[dancer.livejournal.com]

"One thing I'd try is to copy the database to a new directory, and then
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.

[slickgothgurl.livejournal.com]

is the scratch disc full?

Sna?

[dancer.livejournal.com]

I'm not sure what a scratch disk even is. Brian said in Mac speak its a separate hard drive for temp space. Do you mean my temp folder? I've deleted everything out of that :)

No, I think its just toast. I'm getting an error related to the System 32 folder . . .