Batch Jobs In Ms Access
Sep 13, 2006Hi
is it posible to run overnight batch jobs to say update a table in a particular Ms Access Database.
If so how is it done?
Thanks
Norm
ADVERTISEMENT
Creating Jobs Using Scheduler In Access
Aug 7, 2006Does anybody know how to schedule in access like sql. Like a "job" in sql server?
View 14 Replies View RelatedBatch Deleating Of Access Objects
Nov 17, 2004I need to update a number of copies of the same application in different locations.
To do this I need to import new objects (ie. 10 forms, 3 queries, 5 macros etc.).
This takes two steps:
1. Delete the objects in the old DB
2. Import the objects into the odl DB from a temp DB that contains the new objects.
Is there any way to batch delete a bunch of objects? Otherwise I have the chance of missing an object and have the import create a replacement object (ie. fUpdateForm1) with the numbver 1,2 3 etc appended.
I can't just swap out the old database and replace it with a new database, and I already have my data linked from anther DB.
Thanks
Mike Lester
Batch File To Close Access Db
Jun 6, 2007I am trying to make on load even to check if server side applicate FE is same as of client side FE. For this I am quering a field to check no and if it is not same then to start a batch file which copies and replaces client side FE.
Problem is if access application is running, it gives error. So I need to close the db and replace application.
I know xcopy command to replace file but do no how to trigger close application.
Please advice or else any new method is welcome.
Batch File That Kicks Everyone Out Of Access Database
Nov 14, 2007does such exist ?
View 9 Replies View RelatedCompact Access 2000 From A Batch File
Apr 14, 2008Hi All
I am looking to find some code that I can use in a batch file to compact an Access 2000 database that has a database password set on it.
I know about "C:WIPSPOCOneCall_BE.mdb" /compact but need to find a way to pass it the password. What it does at the moment is open and waits for the password to be entered, and then it just opens.
I am looking to set up a scheduled task so that the database gets compacted every night.
Any ideas?
Cheers.
Batch Process To Open Password Protected Access Db
Jan 30, 2008Hi All
I need to schedule the opening of a MS Access database which is password protected.
I think the best way to do this would be to use schedule a batch process to run, can anyone help with the script to create a batch proccess to only OPEN and CLOSE an MS Access database?
Thanks
General :: Opening Access Database From Batch File Or VBS
Dec 20, 2012Is there a way to open an Access Database from a batch file or VBS file wait for 20 seconds and then close the Access file. Preferably I would like the Access file to run in either invisible or minimized mode. I would like the Access Database to close again after the 20 seconds has elapsed.
(The reason for this is so that the Database can refresh itself from Sharepoint on another users machine so that the excel reports on his machine are up to date).
Creating Batch File Running Access Query?
Dec 20, 2012I am creating a batch in an Access Query to decompress files that come in from an FTP site. When I right click on the query and export it to a TXT file I get all the line items of the that I want without the header of the query field name. When I run the following command;
DoCmd.TransferText acExportDelim, "Decompress2 Specification", "qry_FileNameChange2", "J:operationsDecompress2.txt", True
(Where "Decompress2 Specification" is the name of the Spec)
I get the name of the field as the first line item and then all the line items I am looking for. I use the same Spec when I manually run it or when I run it from the code. how I can get rid of the first line item when I run it from the code?
I run a batch file to change the txt extension to bat.
Batch File To Automatically Digitally Sign Access Database
Jun 24, 2013As I am having difficulty keeping my database at work digitally signed due to other users using the database; I was curious if I could create a batch file to automatically run at night to sign the database, so that it can automatically update in the AM, without being prompted questions. Or something of this sort?
View 12 Replies View RelatedEntering Multiple Jobs Done For The Day
Jul 25, 2006I can't seem to find a way to solve this problem:confused:
I'm working on a database to run my window cleaning business. I have a customers table which contains all the details for each customer ie address, name etc.
There is also a Jobs table which will contain a record every time a customer's windows are cleaned.
There is a one to many relationship between them ie, 1 customer to many jobs.
I would like to create a form which would list all the customers which are due to be done and then be able to create a job record for each customer in the Jobs table, showing that it's done, with the click of a button.
For one, I can't get both tables to display on a continous form because of the relationship and then I don't know any other way of creating multiple new records in one go.
Would i have to use VB code for this or is there a simpler way? I just can't get my head around this one:mad:
Dealing With Cancelled Jobs
Jan 5, 2005Setup
i have a form (frmCustomers) with a subform (sfrmJobs). As you might have guessed, it keeps track of customers and jobs. One customer may have many jobs. within sfrmJobs are about 300 or so controls for about 300 or so fields (mostly yes/no boxes) and at the moment contains two subforms of its own. customers have an autonumber CustomerID and jobs have a user-entered numeric JobID.
Goal
it has been brought to my attention that some jobs may just not work out and must be deemed as "cancelled." however, my client wishes to retain these records rather than delete them. in order to maintain the integrity of the reports, i would like to remove these records from the non-cancelled customer database and place them elsewhere, but still retain the ability to review them if need be (but NOT to modify them).
Problem
the job can be cancelled at any point down the line, meaning that a job could have nearly no info or nearly all the info, and everything in between. each job record has a ton of fields. i don't know how to cut and paste an entire record (except for doing it field by field, which could take forever in this instance) into a new table. in this case, it would be several records, since i have a list of materials pertinent to each job as well as a list of services necessary for each job - all of which would have to be removed and placed elsewhere.
Cry for Help
what is the best way to go about this? some ideas i had were creating a parallel table for each table used in recording all of the job information and just manually (well, via VBA and recordsets) copying, pasting, then deleting. another is creating a checkbox that when clicked disables every control for the cancelled job (but oy vey that's a lot of controls to code the disabling for) and then have it reflected in my reports that these are only from the NON-cancelled jobs. does anyone else have an idea?
help?
thanks in advance
-Jason
One Form Field Serve Two Jobs?
Apr 17, 2006Hello all, I have an Access database for a project I'm currently working on.
It's a simple stock control system which records sales and the level of stock.
How can I set up a form that when you click a button, two queries are run?
I want to add a record to the 'Sales' table but also modify the 'Stock' table to edit the 'Current Stock' field.
Any ideas?
Thanks
Problem With Payments For Multiple Jobs
Apr 27, 2007hello all.. trying to resolve an issue in my system..
basically i run a taxi firm.. for those that dont know.
this issue deals with credit card payments, and in particular payments for multiple transfers.
lets say you are booking 2 journeys..
the first journey is on 2nd June from London Heathrow to your hotel in Kensington
the return journey is on 5th June from your hotel back to Heathrow
you want to pay for both journeys at once with your credit card.
both transfers cost £40 each, 40x2 is £80 plus 5% transaction fee is £84.
we keep the credit card details on file to save our passengers time when they want to pay for their journey using the same card.
so lets say we have a job table.. and a credit card table..
Card Table
cardid (pk)
cardtype
nameoncard
last4digits
secnumber
expirydate
startdate
issuenumber
Job Table
job id (pk)
jobdate
jobtime
jobnotes
should i create a new transaction table which holds the jobids that were paid for and the cardid that paid for it..?
shall i include the price of the job in the jobtable.. and store the transaction fee in the transaction table?
if this is clear i would like to hear a few opinions on this.. i will be thinking hard about this over the next few days so i might come to some conclusion but what do you guys think
cheers.
the reason im asking this is because at the moment i am storing the credit card details.. pricing information and job details in the job table..
when i send my passenger an email confirmation.. it sends them the job details, card details and payment details..
this is fine for single transfers.. but if they book more then one transfer i have to send them multiple emails outlining each job individually.. and if they wish to use the same card i have to find their card from the original job and copy those details.
if someone books 4 jobs and pays for them all with one card and one transaction i really have difficulties, i would have to send them 4 emails (with 4 job details respectively) and i would have to include all the payment details in each job to verify it has been paid.. this means i would have to enter their card details 4 times.. and even though each job might be £20 each.. i would have to write £80 in the total charged field because it is covering all the jobs..
anyways.. if you can spare me a thought i would be grateful.. thank you
Counting Jobs Completed By A Vendor.
Jul 5, 2006I would like a textbox in my vendor form to display the number of times that the vender’s name appears in a jobs-completed table during a particular calendar year. I’m not sure where to start. I have tried building a query as follows:
SELECT Count(tblCompletedJobs.Job#) AS CountOfJobs
FROM tblCompletedJobs
HAVING (((tblCompletedJobs.DateOfEngagement)>=#1/1/2006#));
Any suggestions appreciated!
Nightly Batch Run
Aug 28, 2005Hi Guys/Gals,
I am trying to create a nightly batch run process that grabs contents from a fixed length text file. These files arrive daily and will be kept on a network drive. Can i schedule a specific time for access to run a load script?
Thanks!
Jon Cheah
Batch File
Jan 24, 2006I need a batch file that will ask a question :
enter 1 for windows 2000
enter 2 for windows XP
Depending on what the user entered, there will be a copy command.
example :
If answer = 1 then
copy command
If answer = 2 then
a different copy command.
Any help will be appreciated.
Batch File For Current Fe
Jun 13, 2005Could someone please tell me if this is an appropriate way to ensure that all of my users open the most current version of my database each time?
I am not using workgroup security(not needed), and have the be and fe on the network drive. Right now everyone has their own copy of the fe so everytime I make a change they get a new copy emailed to them. I would like to use a batch file instead. This works but want to make sure that I am doing it correctly if I just send everyone this batch file to put on their desktop (CostSavings.bat)
@echo off
if not exist "C:Program FilesMicrosoft OfficeOFFICEMSACCESS.EXE" goto Access11
"C:Program FilesMicrosoft OfficeOFFICEMSACCESS.EXE" "V:ProjectMaterialsPurchSQECost SavingsCostSavings2005.mdb"
goto end
:Access11
"C:Program FilesMicrosoft OfficeOFFICE11MSACCESS.EXE" "V:ProjectMaterialsPurchSQECost SavingsCostSavings2005.mdb"
goto end
:end
rem pause
cls
exit
Any thoughts/suggestions would be appreciated.
Thanks,
Toni
Batch File Issue
Jun 20, 2005I am trying to automatically update a front end with a batch file. I have searched and found a great solution :D but I am having one issue :confused: .
The batch file runs great . . . goes to the network drive; compares the version;deletes the old front end on my system and replaces it; opens access with the new version.
The issue is that is keeps the old version open. I see on some posts that some of you did this successfully but nobody went into that detail. I have tried multiple things but still can't get it. :D
Thanks
Batch File To Start DB
Nov 10, 2005Hi
I want to use a batch file to start the DB. This will check if the Front End is on the users machine and if not copy it over.
It will then check what version of Access they are running and use the appropriate shortcut to open the Database.
This all works fine except that the Batch File does not close down until the Database is closed. Is there anyway to close the Batch File automatically while the database is running?
The Batch file I am using is
@echo off
rem *************************************
rem ** Batch file to copy FE **
rem *************************************
rem ** Copy Database **
if not exist "c:DB" md "c:DB"
if not exist "c:DBFE.mdb" copy "NetworkPathFE.mdb" "c:DBFE.mdb"
if exist "C:Program FilesMicrosoft OfficeOffice10MSACCESS.EXE" goto Office10
if exist "C:Program FilesMicrosoft OfficeOffice11MSACCESS.EXE" goto Office11
if exist "C:Program FilesMicrosoft OfficeOfficeMSACCESS.EXE" goto Office
:Office10
"C:Program FilesMicrosoft OfficeOffice10MSACCESS.EXE" "c:DBFE.mdb" /WRKGRP "NetworkPathSecured.mdw"
goto End
:Office11
"C:Program FilesMicrosoft OfficeOffice11MSACCESS.EXE" "c:DBFE.mdb" /WRKGRP "NetworkPathSecured.mdw"
goto End
:Office
"C:Program FilesMicrosoft OfficeOfficeMSACCESS.EXE" "c:DBFE.mdb" /WRKGRP "NetworkPathSecured.mdw"
goto End
:End
Exit
Any ideas?
JC
Pausing For Batch Runtime
Aug 7, 2006I'm trying to import a file that's being updated with information from an RS232 data logger. While there is no information updating the file, it's safe to import the file and then empty it which can be done from DOS copy commands, essentially I do the following:
Make a snapshot of the existing data into an upload.txt file, import it into Access, overwrite the logging.txt file with a blank copy, overwrite the snapshot with a blank copy.
The reason I'm doing this in DOS is that the import routine fails within Access saying that the logging.txt file is already in use and can't be accessed (I'm assuming that Access wants to take full control of the file, or opens it in a particular way hence the batch file approach)
The problem I'm experiencing is that Macros allow you to run batch files, but the macro continues to run immediately after the batch file is triggered to run, so in this particular case, the information in the logging.txt file isn't copied quick enough to the upload.txt file before Access tries to import it, meaning that Access imports no information (empty file) and then the macro of course runs the second batch file which then empties both the logging.txt file and the upload.txt file.
Two options at the moment if suggestions are willing and available:
1) Somehow stop Access trying to take full control of the text file and allow it to import the information and then overwrite the file with a blank copy.
2) Make Access wait until the batch file has finished before proceeding with the macro.
A couple of thoughts cross my mind for option 2, a timed loop to wait for the batch file, although no guarantees on timing on that one and also perhaps having the batch file create a tag.txt file after the copy is complete which Access looks for before continuing the Macro (maybe have to go into VBA coding for that) then delete the tag file after import routine has finished (the tag file of course will not be in use, so deletion from within Access would be possible)
It's always better to bounce these ideas round the board before heading down one particular road.
Thanks everyone.
Batch File Datbase Backups
Feb 7, 2006hi all,
i want to create a batch file that basically backs up the database file i want into a folder as follows
x:ackupsdatabase020206db.mdb
i know that the command to create the folder is mkdir but i want to know how to integrate the data into the folder name so that this batch file can be run in windows scheduler and i dont have to worry about it overwriting the existing folder name.
any ideas?
Batch Export Of Reports Issue
Sep 28, 2006Ok.
I have a database. I have a report. I want to batch export this report to either html/xml/rtf files. However, at present, the problem is that by default, I can batch export to html but it will produce a sequential list of files with the suffix page 1; page 2; etc.
I want to batch export to html/xml/rtf but name the output files based on an field within the database. (I have a field that is called filename, and would like to replicate this in the output reports)
Any ideas?
Thanks in advance.
:)
General :: Deploy MDE With Batch File?
Mar 6, 2013Any way to deploy the mde with a batch file? I been looking for way other than the autofeupdater. Can't get it to work since I prefere not to involve the users. I been getting bits and pieces; but it seems like you send a bat file to the users via email and when they run the script; it appends itself to the doc and settings in the users folder??
View 6 Replies View RelatedModules & VBA :: Batch Copy And Rename
Jun 25, 2013This code is supposed to loop around a directory of photos (named after a project), and then copy a new photos (from another directory) to this folder, numbering them and the logging them in a table tphotos.The first time a copy photos to a new directory the code works fine. And I think I had it working fine before, but now when I copy photos to a pre-existing directory that has already photos, it only overwrites the first photo, instead looking for the last photo and attributing the new photo number n+1.
I've done debug.print in the code, and it looks like is not going into If NewFileName = f1.Name, therefore doesn't compare the newfilename with the files in the folder.
Code:
Private Sub cmdAddPhoto_Click()
Dim fs, f, f1, fc, s
Dim fDial As FileDialog
Dim SourcefileName, destDir, FileExt, NewFileName, prjID As String
Dim intSel, FileNumber As Integer
Dim varSelFile As Variant
Dim rsPhoto As Recordset
Dim myDB As Database
[code]...
General :: Compact Remotely Using Batch?
Mar 29, 2015Within batch file, I use the following command: MSACCESS.EXE mymdbpath /compact
I get the exclusive in use error. How can I suppress such error or warning messages from within the batch file?.