Luke,

That would be good if I have small amount of data. Unfortunately, there is more than 1500 tables and the user need to be able to search for the records...

that does make a lot of sense. Thanks for all the help

thanks for the reply. I did what you said and now i got the fail to create error. Operating system error 5.

I use to have an external where i back...