not quite sure I understand the problem? Do you want to run the SQL at fixed times? If so then you should make the export macro in Access and then using the Windows Scheduler start Access running the macro
THese are the start up command line parameters you can with Access
Startup command-line options Show All Hide All The following table lists the Microsoft Access command-line options.
Option Effect database Opens the specified Microsoft Access database (database: A collection of data related to a particular subject or purpose. Within a database, information about a particular entity, such as an employee or order, is categorized into tables, records, and fields.) or Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects such as tables and views.). Include a path if necessary. /excl Opens the specified Access database for exclusive (exclusive: A type of access to data in a database that is shared over a network. When you open a database in exclusive mode, you prevent others from opening the database.) access. To open the database for shared access in a multiuser (multiuser (shared) database: A database that permits more than one user to access and modify the same set of data at the same time.) environment, omit this option. Applies to Access databases only. /ro Opens the specified Access database or Access project for read-only access. /user user name Starts Access by using the specified user name. Applies to Access databases only. /pwd password Starts Access by using the specified password. Applies to Access databases only. /profile user profile Starts Access by using the options in the specified user profile instead of the standard Windows Registry settings created when you installed Microsoft Access. This replaces the /ini option used in versions of Microsoft Access prior to Access 97 to specify an initialization file. /compact target database or target Access project Compacts and repairs the Access database, or compacts the Access project that was specified before the /compact option, and then closes Access. If you omit a target file name following the /compact option, the file is compacted to the original name and folder. To compact to a different name, specify a target file. If you don't include a path in target database or target Access project, the target file is created in your My Documents folder by default. In an Access project, this option compacts the Access project (.adp) file but not the Microsoft SQL Server database.
/repair Repairs the Access database that was specified before the /repair option, and then closes Microsoft Access. In Microsoft Access 2000 or later, compact and repair functionality is combined under /compact. The /repair option is supported for backward compatibility. /convert target database Converts a previous-version Access database or Access project to Access 2000 file format, renames the new file, and then closes Access. You must specify the source database before you use the /convert option. /x macro Starts Access and runs the specified macro. Another way to run a macro when you open a database is to use an AutoExec macro. Caution Macros can contain viruses, so you must be careful about running them. Take the following precautions: run up-to-date antivirus software on your computer; set your macro security level to high; use digital signatures; maintain a list of trusted sources of macros.
/cmd Specifies that what follows on the command line is the value that will be returned by the Command function. This option must be the last option on the command line. You can use a semicolon (;) as an alternative to /cmd. Use this option to specify a command-line argument that can be used in Visual Basic (Microsoft Visual Basic: A high-level, visual-programming version of Basic. Visual Basic was developed by Microsoft for building Windows-based applications.) code.
/nostartup Starts Access without displaying the task pane (task pane: A window within an Office application that provides commonly used commands. Its location and small size allow you to use these commands while still working on your files.) (the second dialog box that you see when you start Access). /wrkgrp workgroup information file Starts Access by using the specified workgroup information file. Applies to Access databases only
I'm sure there are a number of different which this can be done, but I dont think there is any EASY way to do this.
If db1 and db2 on the same network then I would link the tables from db2 into db1 Then I would make code in db1 which can copy the data from db1.table1 to db2.table1 (linked).
I dont have enough information on exactly what you need to export/import so I can say exactly what your code should do. It may for example delete th erecords in db2 and then INSERT the records from db1!
Then IF you need to run the code onece a day for example, then you WILL need to use something like Windows scheduler to run a macro in the db1 which runs the code. It should be possibe to do this even if the dB is opened!
jeg fandt en meget nem løsning...lang om længe! Lavede et simpelt script i en bat fil som kopierer database filen over i en upload mappen. Data i denne mappe blev så kopieret over på min webserver via ftp. OG det virker!
Eneste minus er at jeg har ALLE data i min databse med ud på webserveren. Men da databasen er ret lille og ikke indeholder kritiske oplysninger er det OK.
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.
Ny bruger
Nybegynder
Opret
Preview
