I have a database with 8 tables. When I create a replica, one of the tables (only one) in the replica gets modified such that Data Type for all the fields is Calculated, with the effect that the data cannot be changed by the user. The table design is not changed in the Master. What the heck? Of course the table design cannot be modified in the Replica, and there's no reason to modify it in the Master. A second replica on a different server had the same result.
I have a replicated access database, and I want to move the design master to another computer. I have tried using the Windows 'Copy and paste' command, and the 'Save as' command, both result in creating a replicated database.
I have also tried chnging the design master status to a replicated database, but then I am unable to view any VB code behind the controls when I go to design view.
Not a very important question and is just for aesthetics however is there a way to make every form, every command button the same colour, font, size etc?
I have selected a theme however it does not change all forms, labels, text boxes, etc
I don't really want to have to go change them all one by one
For example I would like to get rid of all the navigation on all my forms can you change it over whole database or just individually?
On occasion my access database all of a sudden begins to operate very slowly, I notice the queries take a much longer time to run.
Last week it suddenly began to operate very slowly after idling in excess of 30 mins
Today when I change the screen to design view and then back to form view once again it begins to operate very slowly. (yesterday was working fine on my desktop at home, I have not made any changes to the database with exception to saving and using the file this morning on the shared drive at work) If I shut down and re open it operates well but once again changing to design view causes the same issue. Sometimes compact and repair rectifies sometimes not.
I am designing a database for my organisation. I have done most of it but am stuck on this. Ideally I would like to have a check box (in a table) that when checked a load of data is carried across from that record to a record in another table.
Given that I can't and don;t want to use VB is there anyway that this can be done easily?
I wanted to know if it is possible to change the name of the Table which is going to be created using a Make-Table Query via code (VBA).
For example if my Make-Table query currently creates a table with the name "Table1" I want to change it to name "Table2" and then change it Back to "Table1" or "Table3" etc.... depending on the users selection.
I have received a replicated db --- that is all (not a master) I want to know if any one has experience in "unreplicating" a db and what steps I take to unreplicate this db. I know (more or less) what replication does for you, but I have never done it !!
Thanks to the many of you who have helpped me get this far. I am finally ready to deploy my database! I would not have gotten this far in just a few months if it were not for your helpful advice. :D One of the final stages is to place the database on the organization's server and to put FEs on each of the work stations. I've read a bit about replication and splitting of databases but I have one question I haven't found answered here...
What is the best time line for doing this?
Do I replicate the data base and then split it? Or do I split the data base and then make replicas of the FE?
Does it matter?
Also - is replication truly needed for all data bases - I have a test copy in which I split the Access file, then just copied each front end to 2 machines and it seemed to work okay. Am I missing something that will come back and "byte" me in the keester?
Many thanks again for previous help and for your answers to this question.
Need some advice on Replication of a backend mdb please. I currently have a client/server app - works great. The users now need to collect data from their internet as well as entering data themselves in-house. Situation... can not link tables from web mdb file IS dept forbids link through firewall. How might I be able to keep the data synchronized when the original backend resides within the firewall on the file server and the other needs to sit on the web server? OR ... is there another approach to allow data entry from both the internal users concurrently with data entry from the web. I'm scratching my head and my deadline is looming. Any advice is greatly appreciated.
I have a training Database in Access 2010 that I am creating. I have "courseindex" which is the table that has course titles and the course required frequency. I also have "trainingcompleted" which is the table that contains all training my employees have completed. The form "training" contains employee data and all training each employee has completed.
On the form "training", the training completed is selected from a combo box, which is pulled from the table "courseindex". When I update the combo box, I would like the training frequency field that corresponds to the selected training to auto fill in my "trainingcompleted" table.
Once completed I should be able to generate a report, where the user enters a date range and it will tell me who is due for training within that time frame. I have the forms, tables, and reports set up. I can enter the next due data in manually each time I update a record, but I would rather that data be updated automatically, since the frequency for each training will never change. I have over forty courses that employees must take. Some courses are required annually, some bi-annually, some every five years, etc...
hey there i want to make a MDE compression/compile but i get a msg that i cant compile a replication how the f*** i remove the replication, cuz i no longer own the master file
I am working with a database that uses an autonumber Data Type in it's tables, this field is set to 'Replication ID'. I am adding records to my table but for every record i add i need to retrieve the newly added primary key (which is the autonumber replication id). If it was a incrementing id i could simply select the MAX value from the field. But seeing as it's a replication id it won't bring me back the latest field. In SQL Server I would use the @@Identity function to return the id. Can anyone help me?
I am having multiple user problems with access 2000 quite frequently, and I thought that replication would solve this, as it stands however its proving difficult to get my hands on the developer edition, just wondering, is it worth the hassle to get it, or is there an effective alternative to replication?
Hi, I've been reading about this alot today but can't decide for sure if I should replicate my database or not. The users will have a front end installed on their local drive and the back end is on a shared server.
Basically the users will not be able to add or delete records. However, they can update one column- its a checkbox that allows them to select a record or records in a continuous form. I imagine that if 2 users were using it simultanuously and one de-selected all the records, they would be deselected on the other persons form? This is why I think I need a partial replica. That way when the user opens the database they get a fresh copy of the new data and can select and deselect drawings without interfering with others.
All records are automatically selected when the form is opened so updating changes in the master is not an issue.
Please let me know if I'm on the right track here..
I have a Design Master that I use for many replicas. I would like to replicate the design master so experimental changes to queries and tables can be conducted without exposing the "real design master" to errors? Each time I replicate/copy the design master the replica/copy will not allow changes. Is there a way to disassociate the copy/replica from the Design Master so experimental changes will be allowed and can be made? thanks
Allrighty, some questions about replication. I have gotten the Replication Manager from the helpful IT folks here, have made the database, and it works well to synchronise between different files locally on this computer. However, ideally the other people in the department would be able to carry replicas around on their laptops, while ideally the design master and overall database tidying should sit on mine. The setup is typical intranet here - computers are invisible to one another directly, and so are their virtual My Documents drives, while shared network folders are visible to all.
Questions;
1. Since I can't see any of the other laptop drives, and the database would have to be accessible offline, I assume indirect synchronisation is the only choice, correct?
2. Does the Replication Manager need to be installed on each of the laptops that will use the database offline?
3. If yes, what's the process? Do I install RM on each laptop, then use the Create Replica function to create one locally on each? No hidden pitfalls here?
4. If yes, is it sufficient to keep RM shut all the time unless specifically wanting to synchronise? Would happen at least once a week.
5. If Replication Manager doesn't need to be installed on other laptops, how do I move replicas there? I tried moving one through copy/paste, but that broke the link to the Replication Manager.
6. (Optionally - I've seen some references to 'replica farms' - what is that?)
Very much appreciated if anyone is able to answer..
I have a database accessed by alot of people and have recently added user level security so that i can monitor who is logged on etc.
Another thing i need is the ability to update the design of forms whilst people are on the database. To do this i planned on creating a replica and synchronising any changes after i had made them.
However, this is causing problems with my security. I cannot create the shortcut needed to give people access to the replica, they can only access the design master, which defeats the point!
It's me, yet again! This database I have built for the hospital I am employed by is almost ready for distribution. The only thing I have yet to do is set up securities for each of the medical directors.
For example, I don't want the ICU/Cardio-Telemetry Director to be able to view employee data for the Emergency Room staff and vice versa. I tried once at the very beginning to do a mock replicated database just to see if I knew what I was doing, and frankly, I didn't, not even at all! Should I set up replicas on the network for each director with only their little (or huge) bits of information, or should I setup securities or both, or are they the same thing?
I tried to do a new workgroup and set up groups and users there, but when I tried to log in as someone else, it didn't work. Any ideas? Thanks!
I created replication through Access, but when one of the users try to update a record he was getting the message Record deleted. So i search the internet and found that the solution of this error message was to Compact and Repair the database. When i did that i lost the replication, and now i can't create it back because there records on the database and i am getting an error message.
Any suggestions how to recover the database? By the way is the master database not one of the replicas.
Is replication causes these kinds of malfunctions?
Hello everyone. Your help is very much appreciated. I am trying to create partial replica from the design master. it all goes well until I try to set the filter using: repPartial.Filters.Append "Customers",jrFilterTypeTable,"Customers.Region = 'CA' " It throws an error: "Invalid expression in the ReplicaFilter property".
The replica db, does contain "Customers" table, which has "Region" field.
Thank you for you help. The code, looks like:
dim repFull as new JRO.Replica repFull.ActiveConnection = "C:Program FilesMicrosoft OfficeOFFICE11SAMPLESorthwind.mdb" Call repFull.CreateReplica("C:MY_REPLICA.mdb", "description", jrRepTypePartial)
Set repFull = Nothing ' open the partial replica in exclusive mode and apply filters repPartial.ActiveConnection = "Data Source=C:MY_REPLICA.mdb; Mode=Share Exclusive" repPartial.Filters.Append "Customers", jrFilterTypeTable, "Customers.Region like 'CA' "
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. :)
Hi everyone, does anyone know how to remove the little replication icons next to the db objects when a replica is converted back to a design master. I know there is a way cos i've seen it here before but I can't find it searching. Thanks.
