Hi,

I'm converting a program that uses different types of files to store data. IE. Flat files, random access files, MS Access files. Many of the files stores record numbers of other files to access.

It's quite a mess but I think I can convert the to Sql Server 2008.

One problem I have is that the user can save and load individual files and if the file they load in causes inconsistancies the program still works, it just doesn't find certain pieces of information.

So, has anybody else had to deal with this type of problem?

Or, do you have any ideas that would help me structure the database to work correctly?

I'm planning on LLBLGen for the Dal (of course )

Thanks,

Fishy.