Sage Error a Company File with the Same ID is Currently Being Shared

Sage Error a company file with the same ID is currently being shared when trying to share the file with Remote Data Access. The error message also says “if you want to share this company you need to open the other company and stop sharing”. The most probable cause is- if the file with the same company name is already shared when opening a file that was uploaded to Remote Data Access (RDA).

Don’t fret, as this blog discloses all the possible ways that help you to fix the Sage Error a company file with the same ID is currently being shared with much ease.

Causes of Sage Error a Company File with the Same ID is Currently Being Shared

The main reason for this error is that there is some other file with the same name that is already being shared. The other main reason for the Sage Error a Company File With The Same Id is Currently Being Shared could be that a user has been trying to share a file via Remote Data Access-RDA. This is when the user might encounter this error. So what are the solutions for this error? Well, let us take a look at some of them:

Read More : Sage Error Cannot Open Company File A Required Data File is Missing

6 Different Methods to Resolve Sage Error a Company File with the same ID is currently being shared

To make this error easily rectified, you can try to implement the methods described below one by one.

Method 1: Stop Sharing the File Currently Shared for this Company

• Go to the File or Connect to a Shared Company
• Or, simply select the “Connect shared Company” in the Sage 50 Startup menu
• Next, login with the Sage account email address if asked
• Now, if the company name that you were trying to share is listed in the “Shared Company” list and select the same
• After that, click “Connect” if you do not see the company listed and continue with method 2
• Modify the file name and therefore you don’t overwrite the existing company file and then click on the “Save” button
• Move to the File / Remote Data Access when the shared file is open and then click on the “Stop Sharing”
• (To do this, you must be logged in with the file owner’s Sage ID)
• Close this file after it is no longer shared, then reopen the updated copy of the company file that you were unable to share previously
• Share the company file with others.

Method 2: The File Menu and Save a Copy of the File with a New Name

• Move to the File menu and save a Copy of the file with a new name
• Next, go to the Setup >>> Settings >>> Information and then change the company name to something different
• Try to share the file once again “Remote Data Access”
• Continue with method 3 if this does not work or do not resolve the error.

Method 3: Restored File Convert the Company File

• Restore from a backup from before the company file was converted to Sage 50 2020.0
• On the fourth page of the restore from backup wizard, click on the Browse to modify the location or name that you’re restoring too
• It allow you to keep an open the file and then run reporting on any transactions that you may required to be reentered into the restored file Convert the company file to 2020.2 just by clicking the “Start” button
• Share the company file once the file is open
• You can do this by going to the File >>> Remote Data Access >>> Share company.

Method 4: Make sure that the SAJ folder Belonging to the Company File is Clean

• Go to the File Menu
• Next, click on Properties
• Click on the Blue link within the location line to access the folder that contains the company data. 
• In case you do not have a folder ready, then you need to create a Backup.
• For this, you can check for the following:
• The Version 2013 and Previous:
  • Folders: mysql; simply 
  • Files: ib_logfile0, ib_logfile1, ibdata1, you might also find a couple of text files.
• For version 2014 and beyond
  • Folders: mysql; simply; performance_schema
  • Files: ib_logfile0, ib_logfile1; ibdata1, auto.cnf, and some other text files as well.
• In the case of a newly created backup folder, you need to copy all of the (.CAB) files; these are essentially compressed backup files. 
• Likewise, you also need to ensure that there are no other folders within each subfolder. This includes the MySQL, Simple, and the Performance Schema. This is because they can also comprise the CAB files. If this is the case, then you need to delete them from the (.SAJ) folder also. 
• Next, you are required to create another backup and ensure to adjust the path to point it to the newly created ‘Backup’ folder. Be sure to create another backup as well to adjust the path.
• After this, go to Setup
• Now click on ‘Settings’
• Click on Company.
• Click on Backup to verify the location of the automatic backup.
• Finally, make sure that the ‘Scheduled Backup’ path does not lead to another (.SAJ) folder.

Method 5: Make sure that the Data File is Not located within the Cloud Synced Folder such as DropBox, One Drive, or Google Drive among others

This step is crucial if you wish to check out the status of the synced files. For this, you need to use the Creative Cloud Desktop application.

• Start by launching the desktop software in the case of the Creative Cloud.
• Go to the upper right corner and click on the Cloud Activity option
• You can check the status of your Creative Cloud files sync status as displayed within the in-context menu.

Method 6: To Move the SAJ and the SAI File In case they are Located within the Cloud Synced Folder

• Start by launching the SharePoint document library that contains those Folders and files that you need to move. 
• Now select any of the following:
• Go to the Library option within the SharePoint Server 2016, SharePoint Server 2013, or SharePoint Server 2010, and open Explorer
• Now Click on Actions within the SharePoint Server 2007, to open the Windows Explorer and check if it is selected.
• The SharePoint might launch the library within a different tab in the regular SharePoint experience along with opening it within the File Explorer.
• This Library window can also be closed and dismissed if needed.
• Now click on allow to check out for an Internet Explorer Security Dialogue.
• Likewise, the ‘Do Not Display Me’ warning for this program can be checked according to the requirements of the user.
• Next, repeat Step 2 all over again to open the required folder.
• This could either be a library located within a separate site or a site collection; a folder or library within the same site or both the case. 
• Now both the destination and the source document libraries are open within the File Explorer. This way you can easily move or copy the folders and files between them.
• Next, Select one of the following:
• Click on Ctrl+ C to copy. Likewise, you can do the same by right-clicking on the files and folders within the source and selecting Copy.
• Next, select the source of the folder and files and either click press on the Ctrl+X to cut or right-click and select ‘Cut’ to relocate them.
• Also, bear in mind that you can simply select the files you wish to move and drag them from one File Explorer Window to another instead of having to cut and paste to do the same. 
• Likewise, you can also press Ctrl + V or right-click and select Paste for the required folder. 
• Next, you need to close both the File Explorer Windows after all the files have been either copied or moved. 
• This way all the modifications done by you to any folders or files are instantly uploaded over to SharePoint. 
• Finally, go back to the required SharePoint library and refresh the page to check on the new folders, files, or modifications in case they have not been displayed yet.

Related article : How to Fix Sage 50 Error: “This shared company is already open”

Conclusion

Hopefully, with these methods the Sage Error a company file with the same ID is currently being shared will be resolved easily. And you can continue to start sharing your company file within Sage 50 on cloud.

Frequently Asked Questions (FAQs)