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..
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' "
I wan't access to calculate partial sums based on dates(formatted american style here), in particular, the amount ordered of a certain product until a certain date instead of the amount ordered at a certain date. So:
product date amount a 01-01-2005 1 b 02-01-2005 1 a 07-01-2005 2 a 10-01-2005 1 b 01-02-2005 4 b 01-03-2005 1
Should become:
product date amount a 01-01-2005 1 b 02-01-2005 1 a 07-01-2005 3(=1+2) a 10-01-2005 4(=1+2+1) b 01-02-2005 5(=1+4) b 01-03-2005 6(=1+4+1)
I have done it with the following query:
SELECT tespartialsum.produkt_nr, tespartialsum.transdate, tespartialsum.amount, Sum(tespartialsum_1.amount) AS SumOfamount FROM tespartialsum AS tespartialsum_1 INNER JOIN tespartialsum ON tespartialsum_1.produkt_nr = tespartialsum.produkt_nr WHERE (((tespartialsum_1.transdate)<=[tespartialsum].[transdate])) GROUP BY tespartialsum.produkt_nr, tespartialsum.transdate, tespartialsum.amount;
it works, but only on a restricted version of the table. I want to do it faster to be able to do it for the entire table(70000 products, 1000.000 lines).
I have a form where I enter the students lastname, firstname I need a field that just pulls the first 2 letters of the lastname as well Is there an easy way to do this
I have a form where I enter the students lastname, firstname I need a field that just pulls the first 2 letters of the lastname as well Is there an easy way to do this
I have a form where I enter the students lastname, firstname I need a field that just pulls the first 2 letters of the lastname as well Is there an easy way to do this
I have a database with fields for dates but formatted in "text" so as to allow for partial input of a date. (ie. 12/00/1990 or 00/00/2001) I now need to extract data prior to an exact date and after an exact date. Due to the text format, I am assuming, I cannot create a query to do this. I have tried the expression below but of course it does not give me what I need. < 5/1/1995
I have also tried to create a new field formatted for date/time but I cannot get the date to copy into it since some of my dates are partial.
Can someone please tell me what I need to do so that I can extract the data I need? Any help is appreciated as I have a deadline for this report.
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.
Is there a way to filter based on a partial field match. I couldn't find anything posted before, but it doesn't seem like an unusual problem. I have an inventory database and have a field for part number. I would like to create a filter that would display only part numbers that begin with "FNQ" for example. The entire part number would include other numbers and letters, of course. How can I do this?:confused:
When i go to input my query, firstly it doesnt display results half the time, secondly it is normally very problematic in terms of being case-sensitive, exact word matching etc.
What do i use (criteria) to program the query to let me use partial and non case-sensitive search methods?
I have a column in my databse that has random numbers. There are some numbers in the database that have .0 at the end of them. For example: 44551 .0. I want to create an update query that will delete the .0 from the values.
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?
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 have a table with a field QuotationRef containing a series of values which include a year indicator (eg Q11101/06, Q11102/06, Q11103/06, Q11105/07, Q11106/07, Q11108/07) - where the characters after the / denote the year a Quotation was started. I need to be able to setup a criteria filter expression in my query design view that will allow me to select just the values in the QuotationRef field that relate to the current year. I can set up a query that picks up this year's Quotations by using "Like "*/07"" but that will only solve the problem for this year and I need to setup a query that will change when the year changes. How could I do this, I have tried incorporating "Year(Now())" in the expression but this would filter on /2007 rather than /07. Any advice please?
I'm trying to compare partial text records across two tables.
The first table simply has a description, such as: DescriptionHammer Bone Saw Power Saw
The second table is a list of terms and a category, such as: Term, Category Hammer, 1 Saw, 2
I'm looking to build a query will compare the two and assign each description a category based on the partial match. It seems like this should be fairly easy to do, but I'm struggling to find anything to point down that path.
I’m trying to provide the users of my database with a text search facility.
The database deals with documents, and I’d like the user to be able to search by title of document, with partial text matches. E.g. a title might be ‘Health and safety at work act’ - so searching by Health and/or safety gives this document as a result.
The table is called ‘tblDocTitle’ with the field ‘Title’ containing just that.
Ideally the search facility would be some sort of text box in which the text, and then a button to initiate that search.
How can I hide all the command bars except my customize tool bar ? I have hide all my command bars by the following code :
' Hide all window bar
Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = False Next i DoCmd.RunCommand acCmdWindowHide
I can change “CommandBars(i).Enabled = False” to “CommandBars(i).Enabled = True” but I want only my customized tool to be appear. What is the solution?
