Database 'Agents' is not open

[duvys]

I was getting an error when packing that my agents.dbf (agentTRKpro) had a duplicate ID. I opened it in dbfutil and used tehir pack option which removed the duplicate ID. Now I no longer get the packing error, but if I try to add a new agent I get the following error.

Runtime error in Merchant2/4.20/modules/fulfill/agenttrkpro.mvc @ [000000a3:000003b2]: mvaagenttrkpro.mv: Line 2525: MvADD: Database 'Agents' is not open

I saved a backup, so if there is abetter way of getting rid of the original problem, I can try that.

[Vic - WolfPaw Computers]

If you used the dbfutils pack option, you have just irreparably damaged the database.

MIVA uses its own proprietary packing function. While DBFUtils is great for removing duplicate records, and using the Zap command to clean it out, the pack function will destroy the structure.

Restore from backup, re-edit the file, upload it, and pack within your admin.

[duvys]

Thanks. I will try it that way.