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?
Hello there, :cool:I was wondering here, is there a way to replicate splitted database programmatically? If this not possible, what would you suggest in this case? All advices are mostly welcome and well approciated at all costs. :)
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.
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.
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.
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!
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.
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.
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
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.
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"
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.
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?
I'm trying to set up a simple query that links four tables. However, the tables are extremely large, all in excess of 1.5GB each so I had to split the tables up into four separate DBs. I've tried the following with no success:
1) Link the 4 tables in the DB which contains my primary key. This quickly inflates increases the file size above 2GB and won't let me go any further.
2) Build a remote query to connect the four tables. This looked promising until I tried to run the query and it became evident that it only knows to point to the last database source that you specified.
I'm running everything locally on my C drive. The data source are simple text files (1.6 million rows) from the FDA website.
Well, I am facing one problem..in my application; I need to show all forms / reports name of other database( .mdb ) file without opening the other database physically. I tried a lot but didnt succeded. I tried with below code..
Set AcApl = New Access.Application Call AcApl.OpenCurrentDatabase(strfolder, True) Set AcProj = AcApl.CurrentProject
Set frm1 = AcProj.AllForms
intCount = frm1.Count
But here wen the second line AcApl.opencurrentdatabase get executed at that time the database get open physically, and i dont want that..So is there any other way around..If so..please please help me..
i have a database that runs updates from within itself.what i need is, this database to then open a another database run a update query, then close it.
I have designed a touchscreen input system using Visual Basic.net and this writes to an Access Database. Each Touchscreen has its database locally so it can still work even if there are Network problems.
Now what I would like to do is have all these local databases write to a central database say every minute but only write new records to the central database. The Central Database can either be Access or SQL.
I have been working on a database for over a month now, and my boss just threw a monkey wrench in my work. I believed that the Metal Market Prices would be entered once a week in the current DB. My boss informs me today that he wants an employee to go in every morning and enter that days Price for Each Metal with respect to many different markets.
There is a total of 12 metals, and 5 markets. I need the data to be stored first by date, then by either market or metal, and lastly by which ever isn't used second (Either: date-market-metal, or date-metal-market). I think the Latter of the two methods makes the most sense. Is it possible for my current DB to lookup values from the Metals Database based on date-metal-market?
I have a problem that seems to be happening on several users' databases and is causing a big problem. None of the databases is a shared database...they are all single-user databases on stand-alone computers. I have tried looking for help within previous posts, but all seem to be related to shared databases.
I am getting an error message: "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." The database cannot be opened, imported, repaired...nothing seems to work.
Again...these are NOT shared databases. I appreciate any help I can get. I created the database for all of the secretaries in our school district to keep up with absence data. It involves many tables, queries, forms and reports, and has generally worked well. However I am now seeing several that are getting similar errors as mentioned.
I'm new to Access and VBA, for the record. What I need to do is copy a SQL database (table structures and records) and save it as a local Access database, so that the user can query and make any changes on the local file without editting the SQL database.
Looking around, it seems like the best option would be to use the TransferDatabase method with the acImport option. Does this sound reasonable, or can someone with more experience suggest a better way to go about it? Thanks.
I am testing the security of my DB X on Acccess 2007. I could create a new database Y and linked to the database X. Unfortunately i could change the records on the tables. I don't want other DB that make connections to my DB to change my tables!
Is it possible to access a table in one Database (Database A) from a separate Database (Database B) and if so how. I should clarify that this is an Access Database.
I created a database with forms, querys, etc. Now I was thinking of creating a exe so everyone can use this database without having access to all the design functions.
the only problem I see about doing this is if we need to use the same database for different project, we need to always create a new exe for each project.
Is there a way to make a empty database exe with just the layout, querys etc but with no data on the tables and have a save, open and save as option. So we can have several projects using the same database?
I was thinking to create a VB code for the database to delete all data on the tables when the database is open. and before closing the database exporting all the data to a txt file or something.
Then the next time someone opens the database goes to the main form which has a open bottom which imports the txt file into the tables.
This way we can have several txt file for several project and use always the same exe database.
I am working on a database that will be an addition to an existing one on the company server. However, to make the overall layout not so complex and allow room for other additions in the future, I'd like to keep the databases separate. This will also ensure more efficiency, integrity and troubleshooting overall.
