One our network we have an Access front end and back end. The front end contains the queries, forms and other non-table objects. The back end is where the tables are maintained.
I ran the migration utility and converted the access tables to SQl Server. Next I converted the linked tables in the front end to SQL and renamed them so they can reference the existing queries and VBA code.
My sup suggested I move the queries to the back end. Does that make sense? Of course if I did that the front end code would have to be modified. Personally I don't think it's worth the effort.
The database is relatively small - less than 250 g.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.