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 conflict tables.
What is causing the database to think there is a conflict? If there is a conflict then why is it not showing me where it is when I click to resolve it?
How can I resolve the conflict if I can't see what it is?
I am considering creating an MDE file version of my database and I understand that this comprssed version of the DB will contain no editable source code but can improve resource usage and reduce file size for client machines running the application.
However, if I later modify the original master database object - I will need to create a new MDE file to reflect these changes. Is there a recognised procedure for synchronising the data between the original database file and the MDE file that the users have been interacting with?
(Obviously, if I simply overwrite the older MDE file with that of the newer one - all data in the tables since the MDE file creation will be lost....)
I need to get all the services for one license, but only once, you'll see what I mean
Pk Service Service_Name MyDate Fk_Licence 1 Base 10/5/2004 5 2 Base 12/6/2004 5 3 Super Base 11/4/2004 5 4 Base 20/10/2004 5 5 Super Base 17/7/2004 5
there's about 7000 records with the same 4 services recurring all the time
All I want for one license is the all distinct services for a chosen date
If I select License 5, and today's date, 26/10/2004, I would need the latest service (closest date but has to be inferior or equal), in this case
Pk Service Service_Name MyDate Fk_Licence 4 Base 20/10/2004 5 5 Super Base 17/7/2004 5
Here's the query I have:
select distinct Service_Name from Services where Fk_License=5 where MyDate <= SelectDate order by DateDiff('d',SelectDate,MyDate) DESC
where Fk_License is to get only the services for a particular license distinct if to only get each service once MyDate <= SelectDate if to get only the services older than the selected date order by is to get the latest service cause there will be a lot of services older than the selected date
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 accept the amount of data you attempted to add. Try inserting or pasting less data".
Yet when I synchronise the design master in the UK directly with her replica over the network it goes through just fine! I really am baffled by this and would appreciate any advice. Is there any way to 'debug' the sychronisation so I can see exactly what is causing it to fail?
I have a form that doesnt close, it gets the basic skeletal details of a booking.
I have a button that opens the next form to input the address details and it wont sync.
I have a function that checks to see if the first enrolment form is open and the function works fine. it then creates a filter string based on the studentID of the main form and switched on the filter of the second form, which appears to work. What it does is add a new autonumber in the studentID field of the second input form.
the code for synchronisation is :
' Declare and set a variable to store the WHERE ' clause that describes the records you want to ' display. Dim strCond As String strCond = "StudentID = Forms!FrmEnhancedEnrolment!StudentID"
' Use the IsLoaded function ' to check whether the Enrolment ' form is open, then set the properties. If IsLoaded("FrmEnhancedEnrolment") Then Forms![FrmEnrolmentContact].FilterOn = True Forms![FrmEnrolmentContact].Filter = strCond End If
Please consider the situation below: There is a central server and there are many client PCs connected to the server. On each client PC, there is an access database file that will be frequently updated by the user of the PC.
What I want to do is to allow the user on each of the client PC to backup their database file to the central server;
At the server side, it is free to use any architecture(eg using file system or another database to store the file) to facilitate the backup purposes. One of simplest solution is to upload the entire database file to the central server everytime. However, the problem is the access database file on each client PC is quite big, hence it is better not to upload the entire file but only to upload the updated data to the central server.
Is there a way to synchronise the data with central server without upload the entire database file? What kind of architecture should built up in the central server if there is a way?
I have a function to write some data to a text file (as an activity log, separate to the live data contained in the DB)
It uses the FileSystemObject.OpenTextFile method and works fine
However, I'm conscious that, although perhaps unlikely, there is the possibility (which is enough for me to worry about it) that multiple users could trigger the function simultaneously, which could cause a conflict when multiple FE's try to write to the same log file at the same time.
So I'm trying to add some code to prevent this from happening, by checking if write-access is available before proceeding.
Below is the piece of code I've added. Was considering, as an alternative, looping until the objFile is no longer Nothing, rather than depending on the Err.Number?
Code: Dim objFSO As Object Dim objFile As Object On Error GoTo ErrorHandler ... Set objFSO = CreateObject("Scripting.FileSystemObject")
