FMDesktop

Reply
New Member
Posts: 1
Registered: ‎10-06-2006
Message 1 of 4 (128 Views)

Facility Manager - SQL

128 Views, 3 Replies
10-06-2006 12:57 PM
I have recently installed Facility Manager - SQL on my laptop. Can I access my database I created originally with Facility Manager - ACCESS with this?
Member
Posts: 3
Registered: ‎10-06-2006
Message 2 of 4 (128 Views)

Re: Facility Manager - SQL

10-06-2006 02:20 PM in reply to: Jennifer.Eckert
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
*clintonG
Message 3 of 4 (128 Views)

Re: Facility Manager - SQL

10-06-2006 05:50 PM in reply to: Jennifer.Eckert
Can't the Access SQL Update Wizard be used in this context?

<%= Clinton Gallagher
NET csgallagher AT metromilwaukee.com
URL http://clintongallagher.metromilwaukee.com/
MAP 43°2'17"N 88°2'37"W : 43°2'17"N 88°2'37"W

wrote in message news:5353941@discussion.autodesk.com...
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
New Member
Posts: 1
Registered: ‎01-31-2007
Message 4 of 4 (128 Views)

Re: Facility Manager - SQL

01-31-2007 08:04 AM in reply to: Jennifer.Eckert
Steve,
How best can I contact you about a business proposal?

I was in the FM Desktop training you did in Southfield, MI last week.
Thanks,
Bill Orlowski
william.orlowski@arvinmeritor.com

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you interested in helping shape the Autodesk Community?
We’re looking at a few different ways to improve the “All Forums” landing page and need your feedback! If interested, please take a few minutes to fill out the following Usability Study. Thank you for your time!

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community