Our migration to a SQL Server back end has hit a snag. To most people's surprise working with the SQL Server back end has been difficult and slow. I can import a file into my Access table in less than a minute. Using SQL Server takes 10 to 20 minutes. Deleting data the same way. One of our main goals was to enhance performance. The IT guys are pointing at Access. I say they are wrong. Using a SQL Server back end has usually been dramatically faster. I think the problem is on their end.
Any thoughts? Your speedy reply will help me set them straight, maybe.