Transferring data to new computer


K

Kris

I am using Microsoft Office Accounting Express 2008

I need to import my company data (via backup file) on to a new computer.I
restored the company data on my new computer but when I try to open the
company file, I get a message "Microsoft Accounting cannot open this company
because it was created on a different computer"

Can someone help?

Thanks in advance.
 
Ad

Advertisements

J

Jesper [MS]

Hi Kris

If you select the old sbc-file the program will try to restore to that one
but it is pointing to the old computer.

When you do the restore you should enter a new name in the field for the
sbc-file (company-file) - then the program will create a new sbc-file for
you which points to the company on the new computer.
 
S

Solving a Problem

Dear Jesper:

I have a similar problem to Kris; the only difference is my computer crashed
and I am unable to open my file in Accounting Express 2007. The solution you
gave Kris was unhelpful to me. Please give me instructions on how to open my
file in Accounting 2007; thanks

Netti
 
J

Jesper [MS]

Hi

Well to solve the problem Ill first explain a few basics on how it works:

The company-file that you open (.sbc-file) is really just a shortcut which
points to the actual data. The data is stored in a database elsewhere on the
computer.
So since this is just a shortcut it can sometimes point to the wrong
location. That usually happens when the location changes i.e. if you change
computer name the shortcut will still point to the old computer and
therefore not work anymore. That can produce this error message.
Another scenario that can cause this error message is when everything has
been reinstalled and the database is no longer "attached".

I don't know the exact steps you have done so far but let's assume to begin
with that you have one or both of the above scenarioes.

First check if the sbc-file is pointing to the right location:
Use Notepad to open the sbc-file.
It will look something like this:
database=yourcompanyname
server=yourcomputername\mssmlbiz,5356
Verify that the computer name is the same name as your computer. If not then
change it and see if that works.

If the above is not enough check if your database is still attached:
Open the Data Tools installed with the product and open a dialog that will
list all the databases - i.e. open the Delete dialog (don't delete anything
of course).
Do you see your company in that list?
If not it means that your database is not attached anymore.

To re-attach the database open the Attach dialog and browse to the files
that contain your data.
They are located here: "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\yourcompanyname.sbd"
You will notice that the attach dialog will create a new sbc-file when it
attaches the database.

Let me know if this works for you.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


Solving a Problem said:
Dear Jesper:

I have a similar problem to Kris; the only difference is my computer
crashed
and I am unable to open my file in Accounting Express 2007. The solution
you
gave Kris was unhelpful to me. Please give me instructions on how to open
my
file in Accounting 2007; thanks

Netti
 
K

Kris

Jesper,

Excellent!!!

It worked and my company is up and running again!

I happened to change the Computer name of my new PC after I restored the
data from my old PC.I changed the computer name in the sbc file and it
recognized the company again.

Thank you so much, you saved my day & Company :)

Regards
Kris
 
Ad

Advertisements

K

Kris

Hi Jesper,

Got into some more issues :(

File>Manage Users still shows my old pc name , I am not sure how exactly I
could change it?

Also, old print templates do not show data now(after changing the computer
name in sbc file....

Any ideas how to fix these issues?

Thanks in Advance

Regards
Kris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top