Running ACT! 2008 Database on two Laptops

Hi guys,
Hope some of you SQL database experts out there can help me, 'cos at the
moment I'm going mad!
I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
my own (Vista) and the other is a company laptop. I can't synchronse using a
network connection between the two machines because the work laptop has all
manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
off that ACT! 2008 can only synchronise using a network connection. When I
bought ACT! 2008 I was told synchronisation is really simple. Can't use the
Internet sync as this is only available with ACT! for Workgroups.
I suddenly thought of the ideal solution; as I am the only user and I only
want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
and use that on either Laptop - very simple, convenient and actually even
easier than having to connect the two laptops to synchronise.
You guessed it - bloody problems, I can copy the Database onto the memory
stick and access it from the comuter that saved it.
If I try to open it from the OTHER Laptop I get an error message that I am
unable to open the database and to check my network connections, SQL Server
etc!!
Help, I'm going mad, there must surely be a simple solution to allow me to
transfer the Database backwards and forwards quickly between the two
machines using the memory stick?
Thanks in advance,
Best Regards,
CharlesHi Charles
You don't say how you have restored the database on the second machine? My
guess is that the login you have created on the restoring machine is either
not present has been orphaned, and that is why you can not connect. You coul
d
use SQL Profiler on the machine that works to see how it connects.
John
"Charles Turner" wrote:

> Hi guys,
> Hope some of you SQL database experts out there can help me, 'cos at the
> moment I'm going mad!
> I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one i
s
> my own (Vista) and the other is a company laptop. I can't synchronse using
a
> network connection between the two machines because the work laptop has al
l
> manner of hidden firewalls etc. so this is not an option. I'm really pi**e
d
> off that ACT! 2008 can only synchronise using a network connection. When I
> bought ACT! 2008 I was told synchronisation is really simple. Can't use th
e
> Internet sync as this is only available with ACT! for Workgroups.
> I suddenly thought of the ideal solution; as I am the only user and I only
> want to use ACT! on 2 Laptops I simply save the Database onto a Memory Sti
ck
> and use that on either Laptop - very simple, convenient and actually even
> easier than having to connect the two laptops to synchronise.
> You guessed it - bloody problems, I can copy the Database onto the memory
> stick and access it from the comuter that saved it.
> If I try to open it from the OTHER Laptop I get an error message that I am
> unable to open the database and to check my network connections, SQL Serve
r
> etc!!
> Help, I'm going mad, there must surely be a simple solution to allow me to
> transfer the Database backwards and forwards quickly between the two
> machines using the memory stick?
> Thanks in advance,
>
> Best Regards,
>
> Charles
>|||Merge repl will give you grief and may cause app to fail. Merge adds a
rowguid column to each replicated table. Bi-directional trans repl will work
for you - but the admin overhead may cause headaches.
I've worked w/ act before - they finally have the db in sql which is a huge
improvement, but there is still some growing pains.
You really need to contact act support - or find an act consultant and have
heshe develop a customized solution for you.
Good Luck.
ChrisB MCDBA
MSSQLConsulting.com
"Charles Turner" wrote:

> Hi guys,
> Hope some of you SQL database experts out there can help me, 'cos at the
> moment I'm going mad!
> I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one i
s
> my own (Vista) and the other is a company laptop. I can't synchronse using
a
> network connection between the two machines because the work laptop has al
l
> manner of hidden firewalls etc. so this is not an option. I'm really pi**e
d
> off that ACT! 2008 can only synchronise using a network connection. When I
> bought ACT! 2008 I was told synchronisation is really simple. Can't use th
e
> Internet sync as this is only available with ACT! for Workgroups.
> I suddenly thought of the ideal solution; as I am the only user and I only
> want to use ACT! on 2 Laptops I simply save the Database onto a Memory Sti
ck
> and use that on either Laptop - very simple, convenient and actually even
> easier than having to connect the two laptops to synchronise.
> You guessed it - bloody problems, I can copy the Database onto the memory
> stick and access it from the comuter that saved it.
> If I try to open it from the OTHER Laptop I get an error message that I am
> unable to open the database and to check my network connections, SQL Serve
r
> etc!!
> Help, I'm going mad, there must surely be a simple solution to allow me to
> transfer the Database backwards and forwards quickly between the two
> machines using the memory stick?
> Thanks in advance,
>
> Best Regards,
>
> Charles
>