Forum Discussion
Migration Access DB to Latest Version of Access DB dbo. vs dbo_
Hi All, I am migrating an older version of access db to a latest version. My database is split into two frontend and backend. The backend is stored in a 2000 SQL Server. While doing so the frontend ...
Given the possibility that I misinterpreted your reference to not being able "to convert the back end SQL Server DB", here's a second option.
Assuming that what you meant was that you want to link the newly created accdb to the same SQL Server 2000 database, you can do that by using the External Data tab on the ribbon to locate and link to it.
That said, SQL Server 2000 is long out of support. You might want to consider upgrading it to a more recent version as well. SQL Server Express is free. For most Access-level applications is it perfectly adequate.