Unable to check if schema is available for sync........

Remote user returned from two week trip.  He was able to sync with Database before he left.  Now getting error - Unable to check if schema is available for sync.  Sychronization timed out.  Contact Admin . . .. .

I used actdiag to rebuild database schema and Sync objects.

Other remote users (2 of them ) can still sync without problem.

Any thoughts ?
tswagerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Try going File | Open
Changing the file type frm PAD to ADF and opening the database that way... it does a rebuild and check

Try it at BOTH server and remote - after doing a backup, of course

BTW: To you have other sync users? Do they get the same error?
What ACT! version - Standard or Premium?
What sync method - network, internet, etc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tswagerAuthor Commented:
Other sync users are having no problems.

We are using the Premium version.

We are using a network sync.  Our remote users connect to our LAN,  and sync as necessary with main database on server.

We have 6-8 users logged into main database on server at all times.  -

I will not be able to change the file type until early AM tomorrow.
0
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Let us know what happens when you try and open the ADF on the users machine

Here's another suggestion:
On the remote PC.
Go to Manage Connection Information.
Change the machine name from the IP address to the Name of the server, or
vice versa (if you already have the machine name in the box.)  If that doesn't work, change it back.
0
tswagerAuthor Commented:
I'm not technically savvy enough to tell you what was wrong but I found out my remote user had done a "system restore" to fix another problem.  At that point he was unable to sync - with a variety of error messages.  By the time I finally got my hands back on it the sync option was greyed out on the toolbar.

The remote database seemed to forget it was a remote.  It acted like a stand alone database and seemed to have some other very weird quirks.

I backed up the database into a different directory on the remote users machine.

The user had changed about 1200 contacts since his last successful sync.  I looked up the changed data and exported those contacts back into the main database on the server.  The merge looks to be successful with no lost data.

I then deleted all traces of the remote database.  ( except for the backup I had created )

I then  went back and restored  the remote database I had backed up in its new directory, and everything seemed to work.  It's behaving normally and syncing on demand.
0
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Yup... System Restore can cause more problems than it solves... it needs more warnings when using it
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Contact Management

From novice to tech pro — start learning today.