run code on backend from frontend

[Stephen Lynch]

I need to transfer a few paradox databases to by backend on a daily basis,
the problem is that I do not open the backend, so I am wondering if anyone
know how I can run a function that I put on my backend to be run from my
frontend on startup?

Here is what I have so far:

'Check to see if secdesc table was created prior to today and if so transfer
the database

If (Format(DLookup("DateCreate", "MSysObjects", "Name='secdesc' AND
Type=1"), "Short Date") < Format(Now(), "Short Date")) Then

DoCmd.TransferDatabase acImport, "Paradox 7.x", "C:\DATABASEFOLDER",
acTable, "secdesc", "secdesc", False

Else

""

End If


At first I though, well maybe I can do the transferdatabase from the
frontend to the backend, but I do not think this can be done with the
paradox table. So then I thought well, when I start up my front end, I
would run the code on the backend to run the code above.

1. Can I run code on the backend from the front end?
2. Should I put it in the autoexec macro in backend and write a bat file to
open backend first and then front.
3. Maybe I should reference the date the table was created on the backend
and pop a warning to update the tables.
4. Maybe program the backend to open at a set time each morning after the
files download with #3 message box.

Anyone have any ideas for me. The other problem I have is that I use these
tables on the frontend so I need it to be done before the frontend loads.
Also I am not linking paradox table because of locking problems and
performance issues.

By the way, how do I reference dlookup referencing the backend table from
the frontend access database.


Thanks

 

[Guest]

There should be no code in the back end. Move it to the front end.
Link to the Paradox table and use an append query to copy the data to the
table in the back end.
To determine when the paradox file was last modified, use the FileDateTime
method:

?FileDateTime(pathandfilename)