I've searched for ages looking for threads on backing up a database, and even found one which was asking exactly what I need but without solutions given.
I have a split database with BE and FE, which is used by about 20 users. When the last user closes the database I would like the database to be automatically backed up (e.g. when no one is using it). I've found threads on scheduling a backup, it the middle of the night for example, and other threads on backing up while users are logged on, but I'm not really keen to use these approaches.
Code to automatically backup backend to any folder or media in Access 2010?I need codes to be backing up my Back-End automatically. I am using Access 2010 format.
I have a database that is updated every weekday, every hour. I make a copy of it end of the day so i do not lose that data so far. I wish there was was a way to make a backup copy, say end (once sometime) of the day, automatically.
Hi I have had a look on the forum but cannot find what I am looking for!! I need to back up all the contents of the tables of a database in a certain folder and then restore it. The reason for all this is to be able to update the database with new features so that the final user can receive the update and restore the data. How can I achieve this??? M
I have developed an access database, and prepared its run time exe file. My question is how to develop the database so that the user can regularly backup the database?
we have a database that i have helped on a little...it is all new to me and i have a question?
a previous database on our network(windows 2000 domain) can tell who you are the moment you log! ie when i open it it displays my log on name? how is this done?
I run several databases daily - after running two of them (at different times), the database itself closes but the Access program stays open. In order to close that program, I have to close it out using the Task Manager.
Any suggested solutions? Thanks (as always) for your assistance.
What would cause Access to suddenly close without warning while busy with a query?
No error messages, nothing! The query is a fairly big one that normally takes about 6 minutes to run, but has had no problem with it for a number of years. A new drive used for back-up purposes was recently fitted to my PC which now has 3 internal hard drives.
Could this problem be caused by a bad memory handling configuration? The original setup that worked before may have been changed when the new drive was installed. The XP Page File size for example may have been changed.
I created a form with an "exit" button and a "return to main menu" button on the form. but when I am on the last data and press tab the form closes automatically. what could be the reason. Do I have to put some condition on the macro I have created for the two buttons listed above. I have just put "action" without any conditions on both the two buttons.
I have a form that records when a user edits a record. This change is only recorded when the user clicks the "update record/save" command button. What I need help with is capturing the changes made when a user edits the record in any field and doesn't click the save button upon closing the form. If the user doesn't edit any fields in the record, a new instance of this edit will not be saved to my edited records table and the form just closes
I created an MDE file for my application it's a split db when I hit the exit command button on the MDB version it quits the application correctly but when I do the same thing on the MDE version, it leaves the database window open on the taskbar.
I have an access2000 db. Many tables, forms, reps ect... at random times it will just close. Don't know why. No errors, no reason why. It just closes. Is this common and is there any fix?
I have a main form populated by Dlookups.When I click on a textbox I open another form which is used to change data in my main table. Once this is closed the main form is still displayed but the amended data isnt reflected in this form. How do i get the data to change, I have tried requerying the form and the query that is used for the dlookups but I cant get it to work.
I was trying to access this particular MS-ACCESS file which serves as a DB for a software. But the file opens and closes in a split of a second and was impossible to view its structure. :mad: I beleive it's made to respond so by the programmers in order to hide the content. Can anyone please help me open this file? PLEASE...
Need some help on a command which would close any on screen active form. I want to have this Esc key enabled as an autokey to close any screen active form. I know how this autokey thing works but unable to figure out proper code.
I have a pop up form that requires me to fill out all 4 fields of the form. When I don't, I get a prompt telling me which field(s) I've forgotton to fill in and allows me the option to Cancel (Yes or No) and if i decide yes it wont save and will close the form. BUT when I say No (Don't cancel), it still closes out the form and I obviously don't want that. I don't know if it might have to do with my macro button either? Any clue?
Thanks in Advance!
MY CODE:
Private Sub Form_BeforeUpdate(Cancel As Integer) Dim blnError As Boolean Dim strError As String
strError = "You are missing data for "
If IsNull(Me.[Account Number]) Or Me.[Account Number] = "" Then blnError = True strError = strError & "Account Number," End If
If IsNull(Me.Contact) Or Me.Contact = "" Then blnError = True strError = strError & " Contact," End If
If IsNull(Me.Department) Or Me.Department = "" Then blnError = True strError = strError & " Department," End If
If IsNull(Me.Address) Or Me.Address = "" Then blnError = True strError = strError & " Address," End If
If blnError Then strError = Left(strError, Len(strError) - 1) If MsgBox(strError & vbCrLf & "Are you sure you want to cancel." & vbCrLf & "If you do, the info will not be added.", vbQuestion + vbYesNo, "Close Confirmation") = vbNo Then Cancel = True End If End If End Sub
I have a database that has been functioning very well for nearly a year. Suddenly today, as I attempt to open a report (very complex report takes about 2 minutes to render), the database closes before displaying the report. I have moved the db from the server to my desktop and the same problem happens. It does not matter if I try to execute the report from the switchboard or from the Report Object List.
DB is 344,940KB. I have larger db's that work fine.
I don't know where to look for a way to stop this from happening. Nothing was done to the form design between the last time it worked properly, and today.
I have an application that when in design master shuts down when I attempt to open a certain form. I have traced the problem to a linked field from another table, by creating a new form and ommitting the said field, problem is its a required field!
If I copy the database (Backup) and run it as a replica it does not happen, if I then convert the replica to design master it happens.
Hi, I want all the tables of my database to export to a zip file when the users exit the database. this will serve as a sort of a backup of the data. Is this possible? if so, how?
I am having a problem running Access 2007 runtime on a workstation. I have set up the 2007 database (.accdb) on our server and am able to connect to it and open it from the pc that has Access 2007 full version installed and it works fine.
I also installed Access 2007 runtime on another PC and was able to open the database using the runtime version just fine.
However, on this other PC, I installed the runtime version, and when I use the command line (msaccess.exe /runtime \serverdirectorydatabase.accdb) to open the database in runtime mode, Access opens for a split second and then closes immediately.
When I just run msaccess.exe, it opens the runtime version and says that I have not specified a database, as expected. So, I am wondering why it is not opening the database when i DO specifiy the database.
If i specify an incorrect directory for the database, it opens the runtime version and a dialog appears telling me that a database was not found, and upon clicking OK, the program closes.
I can say, that when I run it off the computer that works through the runtime version, I get a security warning telling me that there are potentially unsafe elements in the database, but i just have to click OPEN and it still opens it fine.
Perhaps the non-working PC is denying it access due to these security issues?
I can't seem to figure this out, and any help is appreciated.
I've got a database, which has been working fine for the last 6 months, it's nt spectacularly large, or complex (abotu 10mb, 15 tables, (5 of which are lookups), about 20 forms, 40 reports, and 30 or so queries).
I've tried to add a new query today, again nothing special:
all comes from one table: column 1 - group by column 2 - max column 3 - if = "No" column 4 is an expression: iif (a=1,col_a,iif(a=2,col_b,iif(a=3,col_c, .... ))) and so on for 8 col_*'s
The query creates happily enough, and is viewable. When I try to save it, access shuts down completely with no warnings.
creating the query apart from the last column, saving it then works, but on adding the final column the database shuts down every time.
I have a combo box that contains a list of values, but users can add their own if they choose. If the value they type in isn't on the list, the Not In List event fires. Once the procedure is done, the form inexplicably closes.
Oddly enough, it only closes under certain circumstances - the code provides several different options for saving the new data, and if I choose different options, the form works as its designed.
Further, if I insert a breakpoint anywhere in the code, then hit F5 to let the code run, the form works fine. Literally, the breakpoint can be anywhere in the procedure from the first line (On Err...) to the last line in the Exit block, "Exit Sub".
