Synchronize

Oct 13, 2005

Hi all,

I want to make a synchronize function in access.
I have two methodes, and i dont know what is best, since i have no experinece with synchronize functions.

Its about meeting information.

An employee has a meeting. He creates his meeting in the database. This way his meeting id is reserved. The employee goes to a client. Takes his laptop with the program. Fills in the information. Goes back to his company. push the botton, and the files from his latop synchronize with the main database under the reserved meeting id.

for example:
meetingID 7 is reservated.

meetingID----ActionID
6----1
6----2
6----3
8----1
8----2
8----3

The employee comes back:
6----1
6----2
6----3
7----1
7----2
7----3
8----1
8----2
8----3

MeetinID and Action ID are PK.

Now the question. I can also create a unique field for the action table. So that actionID and MeetingID wil be no long PK, just one field that identifies. But for the synchronize function, is it harder to program? Or does it make no difference? can you simpy add them ? or is it better to keep using the 2 pks.

please help

thanks

Joost

View Replies


ADVERTISEMENT

Synchronize To ALL Replicas

Jan 30, 2008

Hi,

Is it possible to synchronize to ALL replicas using a command button in one shot from the Design Master?? I've read various posts, and it doesn't sound like anybody has found a solution for this. Found solutions for doing it one at a time, but was wondering if anybody has found a way to synchronize to all replicas without any user interaction other than hitting a button.

Thanks,

View 4 Replies View Related

Synchronize Splitted Database

Mar 23, 2007

Hello mates,

I was wondering (once again :D) is there a way to synchronize splitted and replicated database programmatically from users front end when they close database? I've "Data" & "Interface" databases both in users pc and in server as well.

If this sounds a bit odd, please correct me? Is there a point add back end database to users pc as well or only front end database, which is linked to back end database tables in server?

Thank you! :)

View 1 Replies View Related

Synchronize A Combo-box And A Text Box

Jan 27, 2005

I've a form with a combo box "OrderNumber" (to allow the user to select the correct order) and a text box "Date" which displays the date of the order selected.
The problem is that I don't know how to synchronize the boxes.
I know the procedure to do it with two combo-boxes (cmboDate=Null & cboDate.Requery in the after update property of the cbo "Order Number"), but is it possible that when I change the order selected in the combo-box, the text box shows the correct date?
Thanks for your help!

View 7 Replies View Related

Synchronize Three Combo Boxes

Dec 29, 2004

Ok, here's my dilemna. I'm new to Access and have been struggling to learn this all day long.


I have mastered how to syncrhonize 2 combo boxes, but am having trouble for 3. I would like to do it using Events/VB Code (I guess that's what you'd call it)

Say I have a Car Manufacturer, Model, and am looking for a particular part in the database.

I want a form with combo boxes that has a list for "Manufacturer" (Pkey = ManufacturerID) which is related to "Model" (PKey = ModelID) which is related to "Part" (Pkey = PartID).

The first combo box takes info from the Manufacturer table and gives me some choices, I want to pick one and have it restrict it to the available Models for that Manufacturer.
Then I choose the model and the last combo box restricts me to parts available for that Manufacturer/Model.

Is there a way to do this with the "AfterUpdate()" event? Need more details, or anything? Please help, this is making me go insane.

View 10 Replies View Related

Synchronize Three Combo Boxes

Mar 3, 2005

HELP PLEASE. I'm fairly new to access and would like to synchronize three combo boxes. My table are; tblDepartments, tblDivisions, tblTitles, tblDeptDiv, and tblDivClass. The last two tables are junction tables because I have many to many relationships one department can be related to many divisions or a division to many departments and the same goes for divisions and titles. I can manage to synchronize two combo boxes.

Any help will be appreciated.

Thank you.

View 3 Replies View Related

General :: Synchronize 2 Or More Databases?

Jan 21, 2014

I want code to synchronize 2 or more databases. The databases are the same, but in different media,like in mobile flash drive,backup drive and main system

View 1 Replies View Related

General :: Synchronize 2 Or More Tables?

Jan 21, 2014

I have 2 or more identical tables in Access 2010.I need to synchronized both table at intervals automatically using code. how can this be done?

View 1 Replies View Related

Synchronize To A Design Master With A Button

Aug 2, 2005

I appologise but I am useless with Access but am trying to learn.

I have a datababse that we use to log calls onto, There are five members of our team and each member has thier own replica of the datababse. At the end of each day we have to re-sync our replicas to the design master.

It would be nice if we could put a button on the form we use to do the synchronization for us. Is this possible and how do you do it? bearing in mind that I am not too good with access so I need laymans terms.

TIA all

View 2 Replies View Related

General :: Synchronize Four Combo Boxes

Dec 26, 2012

I am new ussing access already with issues surprice no.I have four tables Section, Ducument, Description, Origin.I nees to Synchronize four Combo boxes, my first combo box code work fine

Private Sub cboSection_AfterUpdate()
Me.cboDocument.RowSource = "SELECT DocumentName FROM" & _
" [Document] WHERE SectionID = " & Me.cboSection & _
" ORDER BY DocumentName"
Me.cboDocument.Enabled = True
End Sub

When I select a category from my first combo box the secon combo box get populated with the correct Data.But when I select the second box the third combo does not get populated with any data here is my code for the second combo box.

Private Sub cboDocument_AfterUpdate()
Me.cboDescription.RowSource = "SELECT DescriptionName FROM" & _
" [Description] WHERE DocumentID = " & Me.cboDocument & _
" ORDER BY DescriptionName"

Me.cboDescription.Enabled = True
End Sub

View 8 Replies View Related

Error On Synchronize Now For Replication Version: 2003 (11.0)

Nov 29, 2006

I am getting the following error when Synchronizing Now for Replicated database. The total database size is only 22 megs (contains reports and forms). This just started happening recently, otherwise it was fine before. My machine is running WinXP Pro SP2 (with latest service pacs) on an AMD DualCore 3800 with 1gig RAM. Once you hit the OK it continues and competes successfully (at least it look OK). Any ideas what this could be or to eliminate it popping up? I run the database with minimum of programs at the same time.

Thanks

View 2 Replies View Related

Is There Any Method To Synchronize Two Access File Which In Desktop And Network Drive

Aug 14, 2007

Here are some background . My company got a access file in a network drive.The data entry simply open the file in the network drive.But once the data has increased (~400mb) sudddendly,all process slow down. Like search , using report etc.Is there any method to imporive the situation?Some guys suggest me to copy the data file to the desktop and sync them.Can it it work?IF works,how to do that?

thanks gratefully for any ans

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved