....without loosing the interface within Access which everyone is comfortable with. Our issues lie with a comfort of the Access interface. We seem to be having a problem with performance when multiple users are in and we happen to be dumping data from another system into a table in our Access Application.
We thought that maybe we could send the data to a SQL and it would end any problem with performance we just do not want to loose the interface. Can this be done with relative ease. If so how ......?