Search results

Hello all. I really hope you can help me. I have a replicated database - see attached for its structure. Most people have no problem synchronising but I have one user in the US who regularly gets the following error when trying to synchronise with the US Server: "The field is too small to...

Hello. I am getting the following error when synchronising between 2 replicas: The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. (Error 3163) I have no idea what is causing this, since there have been no design changes since the last...

Hi. I am running a form on top of a query with around 1500 records in it. The query mostly uses tables that are joined with referential integrity. The form has buttons and conditional formatting. It was fine until today, when suddenly the form has stopped loading properly. It looks all...

I have a database which i regularly synchronise with another. Recently some conflict errors appeared in tblPartNumbers: 3 of them had the following conflict message against them: "Delete/RI conflict. The primary key record has been deleted by another replica, therefore this referencing record...

Hello. I have a replicated database, and I synchronise with other members of the replica set using Access's own synchronisation tool. Everything was fine until recently, but now it keeps telling me that there is a conflict bur when I click to resolve the conflict it tells me that there are no...

Hi All, I have a replicated database which has puzzled me for some time because it is growing in size extremely quickly. After doing some research I have found that this is because I have a number of delete queries running but because the KeepDesignChangeHistory property defaults to 1000, the...

I have a query that currently generates about 20,000 records. When I tried to write code to output it to excel using DoCmd.OutputTo acOutputQuery, "qryStockTurns4", acFormatXLS, , True It comes up with the following error: "Run time error '2306' There are too many rows to output, based on...

I have a design master with 6 replicas. Historically there were more replicas which have now been deleted but how do I go about deleting the file paths of these deleted replicas from the list of possible synchronisation partners? Is it as simple as just deleting them from MsysReplicas? Thanks.