Saving Database / Replication
Dec 26, 2007Hi there,
Would anyone know an easy way to save a database to 2 different places automatically when shut down.
Regards Ben
ADVERTISEMENT
Recovery A Database With Replication
Nov 16, 2006I 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?
Splitted Database Replication
Mar 22, 2007Hello 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. :)
View 6 Replies View RelatedSaving A Access Database To A CD-ROM
Dec 16, 2006For a project I am currently working on, I have to save the database I am producing onto a CD. The file works as it should when saved on to my computer and a USB but on the CD some of the forms do not work and a number of the VBA Sub-routines I have created are not functioning. When i say the forms are not working, I mean they can be opened in design view but not in form view.
I have tried coping the file a number of different ways, just using windows and Nero.
Advice on this matter would be much appreciated.
Thanks in advance.
Field Calculation Not Saving To Database
Aug 26, 2005I have the calculation =DateDiff("yyyy",[DOB],Now()) in the Data/Control source properties of a numeric field in a database/form which correctly calculates age in years from a date field DOB. How do I get this field to save to the database?
Georgina
Forms :: Saving Form To Another Database?
Jul 5, 2013I have tables, forms, and (will be) many data. But many data means that the file will be heavy (e.g. need a longer time to open it) and since it's located in server, meant that it'll also burden the servers when someone is accessing it. So, the idea is to make an access file consisted only of forms (and maybe tables), and another access file as the data-bank. And everytime the form is filled, it'll save the new data to the data-bank. So, it will be easier for the end-users to acess the form (e.g. saving time when opening the file).
My question is:
1) Is it really lessening the burden on server?
Because I think that even if the end-user only accessing the form, the form itself will be accessing the bank-data, and I do not see how it'll lessen all the process.
2) How to save to another database?
I used this command on VB:
Code:
Set db = CurrentDb
Can it be used to save the form's data to another access database? How?
Saving Hyperlink Into Record Of Database
May 22, 2012I have to save the hyperlink of the copied file into a record of my database.
Private Sub Knop29_Click()
Pad = "C:"
Dim Bestandslocatie As String
Bestandslocatie = DLookup("[Waarde]", "tblInstellingen", "[Tag] = 'Locatie'")
With Application.FileDialog(3)
.Title = "Bestand selecteren"
[Code] .....
The column where the hyperlink of the copied file has to come is "data".
As you can read the code i tried to do it this way: Me.Data.Value = NewName, but then i only get this pad saved into my database:
hns019afdelingafd_tdHasseltOpslag documentatie TDMaxihalKranenKraan24TraverseSoftware
So i need to find a way to past the file name after this link so that it becomes something like this:
hns019afdelingafd_tdHasseltOpslag documentatie TDMaxihalKranenKraan24TraverseSoftwareFile.exe
Saving A Database With Search Bar Criteria
Jul 1, 2014one of my steps for my access class in college is to save a database in Access 2013 with a search bar criteria - however no matter how I try Access opens up even after I save as with all the objects showing. Is there a way to save so that when I open access it already has the search bar criteria saved?
View 3 Replies View RelatedGeneral :: Saving Database As Backup With Different Date
Nov 7, 2012I'd like to have a button on my dashboard that gives the user the ability to back up the database and save it with a different date. For example, existing database called "Fishing.accdb" and I'd like to have code behind a button that allows the database to be saved as "Fishing0711.accdb"
I'm trying to avoid the user having to go into the File Save as menu system....I've tried the docmd.copyObject method but can't get it to work
Modules & VBA :: Data Not Saving To Database When Using Save Module
Oct 27, 2014I have a back end database that a number of people are working with using an Excel add-in that imports and edits records saved in the backend. Occasionally, when a user will update a record at first it saves to the backend but then an hour or two later, the changes made disappear. We have validated that after the user saves the changes, those changes are present in the backend of the database, but for some reason those changes disappear after a period of time.
View 7 Replies View RelatedGeneral :: Access Automatically Saving A Copy Of The Database
Nov 6, 2013I have created an MS Access 2007 for a user. When the user uses the database, it automatically saves a copy of the database. Why is this happening? I did create for the database to compact/repair each time to user closes the database. ... However, when I open/close the database, there are not new copies of the database.
View 1 Replies View RelatedForms :: Print Preview Of Currently Entered Information Without Saving To Database First?
Nov 5, 2014If you are using a form as a sort of user interface and you've got a user entering in information into the form, is there any way possible to print a preview of the currently entered form information without saving it to the database first?
I'm thinking a kind of validation thing. Like, "Click here and preview what you've entered. Sure this is what you want?" type of thing.
Replication (or Not)
Aug 8, 2005Hi,
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
Replication And FE/BE - When To Do What
May 26, 2007Hi 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
Replication
Oct 28, 2004Need 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 RelatedReplication Problem
May 5, 2005hey 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
Replication Query ???
Jun 28, 2005I 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
Replication Id Issue
Nov 1, 2005Hi 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
Alternative To Replication?
Dec 15, 2005I 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 RelatedPartial Replication
Feb 9, 2006Hi,
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..
Table Replication
Apr 4, 2006What are the thoughts of table replication. Can I reverse it.
View 1 Replies View RelatedReplication Problem
Apr 27, 2006I 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
Some Questions About Replication
Oct 31, 2006Allrighty, 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..
Replication And Security
Nov 13, 2006Hi 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
Replication And Security
Aug 31, 2004It'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
Problem With Partial Replication
Mar 2, 2007Hello 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' "
Cheers
Roy