Is Replication A Taboo Subject?
Jul 27, 2005
I have posted on a couple of other sites and have not had an answer in two days on a replicated database question. Is this a taboo subject, or is there just not a lot known about it?
I have a FE/BE Database that has 25 users. Two of these users moved offsite and are having huge speed issues. What I have gotten out of my research is the best thing to do is create a replica of the backend and transfer that replica to the offsite agents pc. This way everything is on their C drive instead of the BE being on the network and the only speed issues they will have is when they synchronize the replica w/ the backend.
Here is my problem. How do I create a button on the FE of the Database that will cause the BE on their PC to synchronize with the Design Master BE on the network?
I have a limited understanding of VBA.
Any Help would be appreciated.
Thanks,
View Replies
ADVERTISEMENT
Mar 11, 2005
Does anyone know how to put in a file reference number automatically into the subject bar of an email?
This is the code that i am currently using:
On Error GoTo Err_Handler
MsgBox "THIS FEATURE WILL ONLY EXPORT FILES WITH TODAYS REFDATE"
If [CboExport] = "Today" Then
Dim rst As Recordset
Dim db As Database
Set db = CurrentDb
'Create Recordset
Set rst = db.OpenRecordset("SELECT tblAT.FileNr, tblAT.RefDate " & _
"FROM tblAT " & _
"WHERE (((tblAT.RefDate)=Date()));", dbOpenDynaset)
'Check to see if there has been records recorded today
If rst.EOF = True And rst.BOF = True Then
Beep
MsgBox "THERE ARE NO RECORDS WITH TODAYS DATE, REFER TO SPECIFIC DATE."
rst.Close
Set db = Nothing
Exit Sub
End If
'Export query as MS EXCELL
DoCmd.SendObject acSendQuery, "qryTodaysDate", acFormatXLS, company@somewhere.com, myboss@somewhere.com, , "File reference number ?????????"The following file is the latest extract from me as at " & Date & "."
regards, Steve
View 5 Replies
View Related
Jan 8, 2007
Curently run a Send.Object function on a form to retrieve a unique record via a query. I'd like to be able to send a particular field returned by the query to use as the subject title in the email that is auto-created.
The query will only ever be returning a single record but that single record will change each time it is run.
Any ideas people?
Thanks in advance.
View 1 Replies
View Related
Oct 28, 2004
Hi,
I have been reading all of your post for days now and can't find the answer to my question.
I have however found the answer to one of my programming problems. Thanks to all of you.
I have used Access as a data supplier but this is my first attempt to program in access.
I have absolutly no experience with VB code. And a limited amount of experience with macros in access only.
My question(s) are:
1. I need to send a single report (page) in an email (snapshot format) to a person using a command button. This report should be sent from the form that the person is currently looking at. Currently my command button sends the report in snapshot format but it sends the whole database.
2. This report will be used as a tracking mechanism for another department and I will need a specific name to store the email in a certain location. So that it can be tracked at a later date. I want (that doesn't mean that it can) Access to automatically put the subject line in the email. I know under the sendobject macro you can set the subject line the same for each email. But I need the subject line to match the information in several of my text boxes from a table. For instance: Subject line should read: [Permit number][CountyId][Inspector's Initials][Date]. Can this be done at all and if so how.
Thanks so much for all that you have done already.
Tasha
View 14 Replies
View Related
Jan 21, 2014
I have been asked to make a report from my database listing property sites and listed things found with them. Ex. a property might have 3 houses and 2 cars on it. Whenever I make a report the best I can make are groups that look like:
Property 1
House A
Car a
Car b
Car c
House B
Car a
Car b
Car c
I need something that could group car and houses directly to property 1 rather than cars grouped to houses grouped to property.
Ex.
Property 1
House A
House B
Car a
Car b
Car c
View 4 Replies
View Related
Aug 6, 2004
I have a Macro setup and SendObject is one of the Actions. It is setup to send an existing report. Is there a way to insert a fieldname from that report into the Subject line of the e-mail that is sent? That would be great, instead of having the same subject line for every e-mail, using the date or something like that. Please let me know. Thanks.
View 3 Replies
View Related
Aug 27, 2014
I'm trying to write a line of VBA code (in an existing Access 2010 DB) that changes the Subject Line of all selected emails in my Outlook Inbox to today's date.
View 1 Replies
View Related
Jul 22, 2014
I'm trying to automate some processes. My company uses Outlook 2010 and every day we need to go into our "Sent" folder and rename the Subject line of all of our sent emails. We change the subject to a standardized format depending on the content of the email and who the email was sent to. These are then used as part of an equation to tally our Transactions Per Hour. (TPH)
I've already designed a small Access 2010 utility to track the TPH, but I would like to add the functionality to parse some data from the subject lines of my "Sent" folder, and automatically make changes to save some time.
Here is my thought process:
- Click "Process Sent Emails" button from TPH utility.
- Access runs through each email in the "Sent" folder (or perhaps only selected emails) and changes the Subject line per simple Select Case criteria (I can figure that part out).
View 2 Replies
View Related
Feb 4, 2014
I have a script that sends a mail using outlook to a different person depending on a value in a field. I want to add values from fields to the subject and body of the mail it creates. This is what I have so far:
Function Mail()
On Error GoTo Mail_Err
If (Forms![Manage Packages]![Customer] = "MSC") Then
DoCmd.SendObject , "", "", "email", "email", "", "[ID] - [Package Name] - Delivered", "Dear," & vbNewLine
[Code] .....
In the subject and body the field ID's I want to add are marked as [ID], [Package name] etc.
View 8 Replies
View Related
May 18, 2006
Greetings everubody,
I've a problem and hope to get answers for,
The situation is that I have a table named patient and a form named [patient1] where it holds a textboxs named "MFC_Seq_no" and another to hold [date], now, I manged to do a manual auto numbering for "MFC_Seq_no" using the following VB :
Private Sub Form_Current()
If Me.NewRecord Then
On Error Resume Next
Me!MFC_Seq_no.DefaultValue = Nz(DMax("[MFC_Seq_no]", "Patient"), 0) + 1
End If
Whenever user create new record, the system will automatically store the next number in the new record.
Now, I've be requested to code that system to start again from 1 as value for "MFC_Seq_no" whenever there are changes in date field (i.e. next day in the date field)
Is this doable and how?
Q2. how to duplicate an entire record with a subform, from another table, in it?
Thanks,
View 2 Replies
View Related
Sep 25, 2013
I am developing database for my school. I am done with everything except the examination aspect where i need to indicate students position in every subject beside their overall position according to the sum of all the subject scores. How to indicate student position in subjects.
View 2 Replies
View Related
Jul 14, 2015
I am trying to capture a newly arrived mail in outlook with respective subject line. The below code works for me on 2010 outlook but when new mail arrive in outlook 2013 ,Mrthod Items_ItemAdd do not get called.
Code:
Option Explicit
Private WithEvents Items As Outlook.Items
Private Sub Application_Startup()
Dim olApp As Outlook.Application
Dim objNS As Outlook.NameSpace
Set olApp = Outlook.Application
Set objNS = olApp.GetNamespace("MAPI")
' (1) default Inbox
[Code]...
View 10 Replies
View Related
Aug 8, 2005
Hi,
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 !!
TIA
Marty
View 3 Replies
View Related
May 26, 2007
Hi folks,
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.
t
View 5 Replies
View Related
Oct 28, 2004
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.
View 3 Replies
View Related
May 5, 2005
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
View 1 Replies
View Related
Jun 28, 2005
I have replicated my Access 2002 database and moved a copy to my laptop. (on a wireless network) - so far so good.
Here's the problem l can replicate FROM my PC to my LAPTOP - GREAT !!!
I can't replicate the other way :confused:
My PC is running XP and my laptop is running 2000.
Does anyone have any ideas ? i have a feeling it is probably some security setting in XP but l'll be damned if l can find it.
Thanks
AndyB
View 8 Replies
View Related
Nov 1, 2005
Hi Guys,
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?
thanks,
Dave
View 2 Replies
View Related
Dec 15, 2005
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?
View 6 Replies
View Related
Feb 9, 2006
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..
View 5 Replies
View Related
Apr 4, 2006
What are the thoughts of table replication. Can I reverse it.
View 1 Replies
View Related
Apr 27, 2006
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
View 2 Replies
View Related
Oct 31, 2006
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..
View 4 Replies
View Related
Nov 13, 2006
Hi everyone
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!
Any help much appreciated
James
View 3 Replies
View Related
Aug 31, 2004
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!
KellyJo
View 5 Replies
View Related
Nov 16, 2006
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?
View 6 Replies
View Related
