Hello.

I really need help with the following problem:

When I create a Remote Database and finish attaching the remote database to the remote client Microsoft SQL database system. The 1 custom table contains no data. This was working before for the same remote user and now I have discovered this problem. The table is setup to be synced to the remote uses and even if I create another a remote database for a different user the same problem happens.

Any help and solutions to this problem I will most grateful for.

Thanks

first thing to look for is bad data......NULL's or duplicates in a constraint field, badly formatted dates.....

Now that you are able to replicate this for any\all user's it's kind of a guessing game as to what changed.....

What's the NAME of the table?

What does the table look like in DB Manager? Can you add a field to it?

check for Duplicate Joins

Missing SECTABLEDEFS records in the table

SECCODEID not populated in the table

No (eventual) link to Account.ACCOUNTID that meets a Subscription rule

ACCOUNTID not populated...

If this worked at one time and now no longer works.....DOH: something has changed to break it....

What version of SLX (and hotfixes), Database, Client OS, et al are you on? Since this is ONE table only environmental variables should be neutral (right?) but you never know....