I'm using the same licensed software disks- registered it to the new computer on install.
Main Topics
Browse All TopicsOBJECTIVE: Restore an Act!2007 database onto a different computer.
Hardware/software:
OLD- Dell PC with Win XP home edition and Act! 2007 for Workgroups.
NEW- Macbook with Bootcamp/ Win XP Pro
I created a database backup on the Dell backup and restore to another computer and put the file on my FTP. I did not select password protect. (The DB does have a password to open it.)
I installed ACT! 2007 from original disks on the new laptop. I can create a new DB and program works fine. I select restore DB and get this error:
System.NullReferenceExcept
I read about some instance errors elsewhere, but have not seen a workable solution.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
OK- I ran checks again and there was an update on new. They are almost same now:
ACT! by Sage Premium for Workgroups 2007 (9.0) (EX Edition) Version 9.0.1.162, Hotfix 1, on new;
ACT! by Sage Premium for Workgroups 2007 (9.0) (EX Edition) Version 9.0.1.162 on Dell- does not have the hotfix, but when I try to update it says none are available.
I backed up the DB again and to RESTORE AS. It went further before erroring out.:restore detected error on page ,....(10496:150995273) in database "macbook07" (that's the new DB name) as read from the backup set. Restore database is teriminating abnormally.
PRC_MAINT_RESTOREDB:ERROR EXECUTING DATABASE RESTORE STATEMENT ---> Ssytem.Data.SqlClient.SqlE
Its about 30 lines long and I have a screen capture of it.
Did you try a restore as on the same machine first to determine the backup worked? Or is this from that machine?
Maybe try the suggestions here - http://itdomino.act.com/ac
Hotfixes do not roll out from the auto updater... it shouldn't effect this issue (but worth trying). It's available here - http://itdomino.act.com/ac
Ok... you can create and use database in ACT! on the MAC?
How about trying this:
Stop the SQL services on the DEL - Start | Reun - stop SQL Server (ACT7)
Then copy the Database folder (and all sub folders) onto the MAC
Delete the PAD file (databasename.pad)
Open the ADF (databasename.pad)
Close ACT!
Copy the new PAD file from the database are to My Doc
Open ACT!
File | Open - select the PAD
you lost me on: Stop the SQL services on the DEL - Start | Reun - stop SQL Server (ACT7)
Am I supposed to reboot the PC and press DEL button?
FYI- I did a demo backup on mac, and tried to restore to PC. RESTORE detected an error on page 3075:1399 in databaase as read from the backup set. database terminating abnormally. it's about 50 lines long for the error info, but that's the main point.
OK- I have it working, but not the way you said. (open & close ACT several times to get this to work)
I copied the DB file folder over
deleted pad file
opened adf file (won't open by click, have to use ACT, Open)
then it says, sorry already DB file by that name. tries to update DB anyway & fails
Changed the 2 file names by adding a 1
updates the file, and asks for user/pass
now opens DB
clicked around, but when I clicked on Documents folder, It though it crashed program, but 5 min later it opened the folder and you can see file names, 0 bytes, probably because path to folder may not be same.
Thank you for your assistance. Any last tips about this or going back to other computer before I close out problem are appreciated.
I'll update this problem when I roll back to the other computer in 2 weeks when I return.
Obviously the MAC bootcamp XP is not the same as a normal XP in some areas.
I would guess that, unlike your other Windows programs, ACT! is using more Microsoft technologies (.Net framework, SQL, etc)... and if these are not properly handled in the Windows system, the types of errors you've been having may continue and may get worse.
I would make absolutely sure you have a good backup procedure (not using the one in ACT! as this is an area that seems problematic for you). You could try AutoAdmin III or something similar - http://www.glcomputing.com
XP Home limits concurrent users (when used as a server) to 5. It shouldn't make a difference to the Restore functions.
http://www.act.com/go/2007
Business Accounts
Answer for Membership
by: GLComputingPosted on 2007-06-20 at 15:07:24ID: 19328752
Are you sure the two systems have the same exact version of ACT!? t.nsf/doci d/14596
See - http://itdomino.act.com/ac