I have this code that backs up all my tables in the same folder.I want to however back up only specified table with names; operational areas, Communities, Zones and Projects.how to integrate that into my existing code or any other way to achieve that
Sub backup()
Dim dTime As Date
On Error Resume Next
dTime = InputBox("Create a backup at", , Time + TimeValue("00:00:05"))
[code]...
In our forms, we have managed to export a backup of our application (to accdb file) in a specific folder.
We now are trying to make a backup restore function that restores the backup (the accdb file).
However, we have some difficulties with restoring this backup in a form (like browsing for this specific backup file).
How to make this restore function?
Hello all,
I would like to create a module that will take a few of my tables in my database and back them up into a new database on one of my servers every day. The name and path of the database will change day by day based on the date. Can someone recommend some code...I tried this:
Dim strmydir As String
strmydir = "\Jxflpr4DataDepartmentOps TechRaw Builder ArchiveArchived" & Format(Date, "YYYY-MM") & ""
If Dir(strmydir, vbDirectory) = "" Then
MkDir "\Jxflpr4DataDepartmentOps TechRaw Builder ArchiveArchived" & Format(Date, "YYYY-MM") & ""
ElseIf Dir(strmydir, vbDirectory) <> "" Then
End If
Dim dbs As Object
Dim strdb As String
strdb = "\Jxflpr4DataDepartmentOps TechRaw Builder ArchiveArchived" & Format(Date, "YYYY-MM") & "" & Format(Date, "YYYY-MM-DD") & ".mdb"
Set appaccess = CreateObject("Access.Application")
appaccess.NewCurrentDatabase strdb
Set dbs = appaccess.CurrentDb
appaccess.CloseCurrentDatabase
DoCmd.CopyObject strdb & Format(Date, "YYYY-MM") & "" & Format(Date, "YYYY-MM-DD") & ".mdb", "tbl_master", acTable, "tbl_master"
DoCmd.CopyObject strdb & Format(Date, "YYYY-MM") & "" & Format(Date, "YYYY-MM-DD") & ".mdb", "tbl_excluded", acTable, "tbl_excluded"
DoCmd.CopyObject strdb & Format(Date, "YYYY-MM") & "" & Format(Date, "YYYY-MM-DD") & ".mdb", "tbl_allelse", acTable, "tbl_allelse"
But it doesn't seem to want to copy the tables over. I tried separating the bottom half into a new function, but it still seems to be stopping for no apparant reason. It's not giving an error message, just bringing the debugger up on the second copyobject line.
Is there a better way to do this as I'm aware this code is very messy.
Thanks in advance!
Vassago
Not sure where this question must be posted! I would like to create code in VBA to backup tables in access. I am not sure where to begin, but what I would like to do is the following:
When the user signs in I want to backup the database/tables
When the user sign off I want to back up the database/tables.
I have a restore from BackUp form. When the form is activated it runs this code
Code:
Private Sub Form_Activate()
Dim strRestore As String
strRestore = "C:GungogManagerBackUp"
If Len(Dir(strRestore, vbDirectory)) = 0 Then
MsgBox ("There are no BackUp files available"), vbOKOnly
Me.btn_Restore.Enabled = False
[code]...
It was working, but since adding the bit in red its not working. I basicly want it to look for the directory and if it dosent find it the pop up with message, but if the dir does exist then to populate the combo.
Have you guys ever used this scheduling tool from FMS Software that will do a nightly archive and compact/repair.
I tried it out on our live database (not so smart I guess) on a Friday and when I came in Monay it was corrupted. It seems to point to the FMS software corrupting my db.
I wanted to validate and use this software but ain't sure it I will now.
I like the nightly compact/repair. Is there another way to do that with Windows Scheduling or something?
Take a look:
http://www.fmsinc.com/Products/Agent/index.html
I'm using Access 2007, with what I think is a normal database that I've built up over the past month (maybe 15 tables, <1000 records, 20 queries, 4 or 5 reports and macros). I'm not an experienced Access programmer, so I don't think I'm doing anything fancy with security settings or any other such stuff. (If I have, it's surely by accident, not by intent.)
When I try to back up the db using the simple office button -> manage -> backup method, access generates a date-stamped backup filename and opens a file save dialog for me, but it ALWAYS fails to backup the database. I always get the same error message when I click save, whether I save on my machine, or on a network drive.
"Could not use '<path to the current database dir><backname>.accdb; file already in use."
This same error occurs when I create a new blank database with a single Table1 in it, so I don't think it's my database.
Does anyone have any idea why this might be happening? I scoured the net for help, but nothing. I checked various Access forums, but nothing. So I arrive here after I've done my homework... thanks
Why Access (2010) database is creating backup copy by itself?
View 2 Replies View RelatedI am using Access 2007 database in work environment. When one of my colleagues tried to update some records in a table, it created a backup of the database.
The issue is that the size of the actual database is much smaller than the size of the backup. However all the data are present and I don't think any data has been deleted.
But I don't know why there is a difference in size?
Some of the tables in the database are linked from MS SQL Server.
Im trying to create a command that will create a backup of my access database once every week. here is the code I've got so far. it works, but not once a week but every time I start the access:
MsgBox ("Hello! Starting Backup procedure")
Dim DateOfBackup As Date
Dim strSourcePath As String
Dim strSourceFile As String
Dim strBackupFile As String
Dim SQL As String
[code]...
I have a database with multiple forms and I would like to on close I would assume of the form, save a backup to a specific folder. This will all change once I move the database to the server but for now want a backup on my machine. Here is my code:
Code:
Private Sub Form_Close()
Call db_backup
End Sub
Below is in a module
[code]...
The problem is when I run this the program will give me an error saying: runtime error 438 object does not support this property or method
Just wanted to confirm which is the best way to create an automatic back up of a access DB. (Split DB, backing up the BE - Access2010)
Firstly I was thinking of just creating a batch file to copy the file to a new source directly with a task scheduler set up.
Ideally I'd like it to run daily and have the date of the back up added to the end of the filepath.
I have a button in the form of the current access file. What I want to do is when the user click on the button,
triggered the vba to backup current access file. But since the file is currently open, is this possible? If yes, may I know how to do it with vba?
I have tried two methods but failed:
1) Use copytofile method, but I get permission denied due to file open;
2) Use dbengine.compactdatabase method, but it also has problem if the file is open.
im creating a database for a team that run courses. someone else started the database but never finished it. I have 2 tables which i will refer to as Contacts & Training Courses. I also have a form that displays the information from the Contacts Table. All the information that is being displayed on the form is showing up in text boxes. I want to now add a drop down list box in the form so when its on a particular record showing the information about that contact it will also show me a list of what training courses they run. Both the contacts table and the training table have a Company ID field and the numbers for them are the same in both table.
I have tried using a query but its not working and all i get so far is the contacts showing up and the courses ID repeated several times.
I hope someone can help me
phill
I enabled security on an .mdb which included several users that are in the Full Data Users group. After I did this I needed to add a new form to the application, so I logged into the application and added it. However, though the admin group and the Full Permissions group can access it fine, the Full Data Users group cannot. I have double checked all of the settings and have even rebuilt the .mdw file to no avail. Any thoughts?
View 2 Replies View RelatedI am pretty new to the using of Microsoft Access. Part of my role at work is to mantain a register of contacts (Aprox 2000 records). When moving into my role there was already an Access Database in place that had been designed and created by another member of staff prior to leaving.
The database contains a wealth of information, however this is spread across MULTIPLE tables (23 to be exact)
I am trying to create a word document that is basically a mail merge in order for me to drag the contact information over to print. However all the information I require is not in one table. Word will only extract the data from one source.
How to incorporate access pivot tables in an access form? Also how to subtotal on changes withinin a field in a form?
View 4 Replies View RelatedI have a crosstab table that is displaying in a form within a form because the form has data coming from multiple tables.
Crosstab Query looks like
Name Sum Cust1 Cust2 Cust3.....
Jon 50 250
Bill 100 50 100
Kevin 200 50 100
Ryan 10 500
The issue are the blanks in the rows for each Name. When I bring it up on the form, I want the columns to be the Customers but only customers with amounts. The original form is there to show the name and position and the form within the form should have 1 row for name of the person that is being selected and columns of customers WITH A BALANCE.
Hello,
My requirement is this...
I have to use MS Access as front end with ODBC connection to Oracle 9i
DB.
The application(forms) should be able to update, delete ,insert records into oracle tables(backend).
i have a main form,which has some unique id's and other info about the ids and the subform shows several matching id's for that unique id in main form. the user who uses this application should be able to
1) search for the unique id in the main form such that the subform displays all its matches
2) they should be able to select anyone match and say approve(there can only be one match), then that particular record should be updated in the table.IF I USE A CHECK BOX AND IF THEY CLICK ON ONE RECORD AS MATCH,HOW
DO I TAKE THAT RECORD SAY THE ID , NAME ADDRESS AND ALL DETAILS AND UPDATE THE TABLE???
similarly when they select some other record i should give option of deleting other irrelevant matches in the backend table.
the main form and the subform uses the same table as source.updates are to another table, i should also have to put entry into audit table about which record was deleted and which one inserted..
How should i do this?? i am new to MS access .VBA, any help would be highly appreciated!
Thanks so much!
I have created a small database, and created a Main Menu (form), the main menu starts as soon as someone start my database, i have linked up all my forms & reports into this main menu. now i want to hide left panel bar that shows all the table, quires, forms & reports files (so nobody can access tables, quires, etc from that panel).
View 1 Replies View RelatedI have a client who needs a Database created in Access for him. he would like to regularly auto-populate this Access DB from an Excel file - like twice a week.In addition, he wants me to create Forms, Queries, reports and Macros for him in the Access, which will have 2 Tables from Excel files and about 3 Tables created in Access.I figured that I could do that if I gave him a link to the Tables he needed from the Excel file(s). But how do I work remotely for him- the path to those files is on his computer. I can load them to mine, but then he can't open the files.How can I create Forms etc. in an Access DB which uses links from source files as its Tables?
View 2 Replies View RelatedI have 5 tables that I would like to input data in. It can only be done with a single form. The fields I want to input in have the same names in all 5 tables, for example:
Table 1:
Name
Age
DOB
Table 2:
Name
Age
DOB
Table 3:
Name
Age
DOB
Table 4:
Name
Age
DOB
Table 5:
Name
Age
DOB
Is it possible to input data into all of these fields in each table using one textbox for each field?
Preferably without having to use code but if it cannot be done without it then that would be fine.
I have a form with a graph on, and want to show two different lines on the graph, sourced from separate tables.
The commonality between the two tables is a date.
One line shows count of people available every 15 minutes and the other would should the demand for people on the same date, every 15 minutes.
Is it possible to do this and how?
We have an Access 2000 backend database resides in a network server drive while users connect to the backend tables with a mde file on their computers. All users have Access 2010 and the mde file was converted from the 2000 frontend with Access 2010.
The database have been running for a few weeks but recently users have been complaining about record lost on the backend table.We have also experienced one incident of data corruption where the main table could not be opened. After Compact & Repair, the table could be opened but a few records were showing xxxxx on all the fields and we have to delete and re-enter these records.Would they relate to using 2010 mde converted from 2000 frontend when the backend is still in 2000? I am a little nervous about converting both the frontend and backend to 2010 since I have heard various issues on the new version.
Ok I've been reading on backing up Dbs here. I have a db FE and BE I need to do back ups currently I backing up my FE with the autocompact db found in the sample forum but can't use it to back up my BE when it's open.
bascialy I'm trying to backup the BE daily but how do I do it if some is in it?
what is, or does it exist, the T-SQL command to backup an MS Access database. is this possible?
View 1 Replies View Related