Yes, but it is something that should be considered temporary. No idea how it will work in the long run. Upsize your tables into SQL Server. Rename all of your tables in Access. Create linked tables in Access that point to the SQL Server tables. Match the names of the linked tables in Access to what you originally had. This will in effect move all of your data and the management into SQL Server. However, your application will still be hitting Access just like it does not. What Access will do is simply pass through the queries to SQL Server. SHould get you switched over and working, but you obviously have another layer in the middle of the communucations that can create problems.
Dig Deeper on Microsoft SQL Server Installation
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.