Pos3/Pos5/FNB: : How to attach Database file from Accounting or POS Backend

From AutoCount Resource Center

Question :

I have copied raw database from old PC, because it already can’t do normal backup action. How can I do restore or attach the database to new computer? Now my PC is not yet installed with Microsoft Management Studio

(https://wiki.autocountsoft.com/wiki/Others:_How_to_attach_Database_file_from_SQL_Management_Studio).


Solution :

If you are yet to install Microsoft Management Studio, try to use AutoCount Accounting or POS Backend attach. Make sure your files access right is everyone with full control.

000258-a.png


1.If not please Right click your .mdf & .ldf files > Properties

000258-b.png


2.Go to Security tab > Advanced > Change > enter Everyone > Check Names > OK

000258-c.png


3.Click on Add

000258-d.png


4.Click on Select a Principal > enter Everyone > Check Names > OK

000258-e.png


5.Tick Full control > OK > OK

000258-f.png


6.Login Accounting or POS Backend > File > Manage Account Book

000258-g.png


7.Click on Attach Account Book > Attach Database File

000258-h.png


8.Fill in ‘.\A2006’ on Server Name: column > click Browse under Physical DataFile > Find your correct .mdf file > Open > OK

000258-i.png


9. Fill in ‘.\A2006’ on Server Name: column > click Get Available Databases > select your new DB > OK > OK

000258-j.png


By: CK 20210923, Jacky 20211022, P211025 [000258]


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations