Hi Martin65:

If your data is stored on a server you must install Sage 50 on the server. There are 2 types of installs, one where you only are acting as a single user and using all features on that computer (meaning a full install of Sage 50), or the second one is just a server installation. I think you may not have installed the server version of Sage 50 on your server. The network drive has to be set up as a shared drive as well.

Hope this helps!

We are switching from the server version to a standalone version.  As I understand it, I should just be able to move the files from the server to a local drive and have it work, which its not.

Can you open the sample file?

If not, then you may need to click on the link in the message to go to the Knowledgebase and look for information on changing the firewall settings.

Did the computer open the file on the server ok before it was moved?

Where did you put the file, which path?  It should have been put in some location like c:\Sage50Data.

Yes, I can open the sample file just fine (picked a C:\ location).  Also the prior version was able to open the files before being moved.  The prior file location was X:\Sage (mapped network drive that was shared from the server)  the new location is G:\Sage (a networked drive from our file server) 

I did a test by moving the main database to C:\Sage and I can open it just fine. 

It seems to have an issue with the file server location, which should appear to Sage as a local drive.  Is Sage not able to use a networked drive without its own server?

Agate already gave you the answer to that one.  Your original message indicated you copied the file from a server to a network drive.  Typically the definition of a network drive is that it is on another computer eg. a file server.

Then you said

Martin65 said:

Since its a local copy of the file, I don't get this error.  Any ideas ?

so I just assumed you meant the network drive was your local c: drive and everything is fine because you don't have an error now.

A network drive that exists on a different computer is not a local drive.  Any drive specifically attached to your workstation computer is a local drive.  Having said that I would not be running Sage 50 files from a memory stick because they will eventually become too full to run properly.

However the local c: drive as you have indicated c:\location should be fine.

If you store the files on a different computer, the Connection Manager must be installed on it as Agate said.  It does not matter if the other computer is a true Windows Server or if it is a peer-to-peer networked workstation being used as a server.  It still has to have the Connection Manager installed through the process Agate mentions.  You can use the Full Install or Server install.  Full install allows you to run Sage 50 on that computer (assuming all licensing requirements are met).

Thanks for the responses.  I think I figured out that Sage needs the connection manager even with a file server as I was typing my my last reply!  Thanks again!

Thanks for the responses.  I think I figured out that Sage needs the connection manager even with a file server as I was typing my my last reply!  Thanks again!

Technically Sage 50 uses the Connection Manager on each computer, even when you open the sample file that resides on your local workstation hard drive.  It is installed with each installation and you can see it in your systray and display it from the Start Menu as well.  The Connection manager installed where the files are located is used to open and access the database.