No each back end database maintains it's own data. The data in the access database would need to be ported over to MS-SQL. Be advised that this process needs to follow the database schema rules. For example Properties, Buildings, Floors, must be imported before spaces can be linked. Also remember each database maintains its own tracking information, so you will need to make sure the records import correctly.
Stephen Komisarek
FM Solutions Consultant
Building Solutions Division
www.autodesk.com
www.fmdesktop.com