Forum Discussion

SureshB64's avatar
SureshB64
Copper Contributor
May 15, 2023

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 ...
2010
access
developer
office 365
George_Hepworth's avatar
George_Hepworth
Silver Contributor
May 15, 2023

SureshB64 

 

A. You can't "convert" the back end from SQL Server 2000 to something else from Access. You'll need to install whatever newer version you choose, and then migrate the data to it.

 

B. Same steps as now, except the new tables will be in the new database with a new connection.

 

C. Unlike Access, SQL Server has "schemas" which are like separate buckets, or containers for tables. DBO is the default schema. We all get used to seeing it, but you can create other schemas in SQL Server and segregate tables among them if you wish. Because Access doesn't follow the schema.table method, it changes the dot . to an underscore _ and uses schema_table for the default name in Access. No big deal. You can change the names in Access if you want to retain the original names.

Resources