Your company has decided to migrate its local Microsoft Access database to a remote SQL Server database. The current application uses DAO for data access. Your task is to evaluate whether to continue using DAO or switch to RDO for data access in the new setup.

Submit your decision along with a brief explanation supporting your choice, considering the characteristics and use cases of both DAO and RDO.