Schedule Access to run

[Bob Ford]

I created an Access Db to pull records from an Excel1.xls and output the
result to Excel2.xls
Since Excel1 is considered a master listing and being edited by more than 20
people from various parts of the world, I need to create a schedule to
automate the update to Excel2.

Is this possible:
1) schedule Acces to run every hour ? How? There are no performance issues,
after testing it only took 2mins. for the update
2) will this affect the Excel1 to corrupt, if the schedule was run and
someone was editing at the same time?

Any advise is appreciated.
Thanks
Bob

 

[Matt]

I created an Access Db to pull records from an Excel1.xls and output the
result to Excel2.xls
Since Excel1 is considered a master listing and being edited by more than 20
people from various parts of the world, I need to create a schedule to
automate the update to Excel2.

Is this possible:
1) schedule Acces to run every hour ? How? There are no performance issues,
after testing it only took 2mins. for the update
2) will this affect the Excel1 to corrupt, if the schedule was run and
someone was editing at the same time?

Any advise is appreciated.
Thanks
Bob

The way I do it is:
1.) Create a form with a timer
2.) Program the timer event of the form to do this

The problem is you have to have the access application open all the
time (if you already do then it is no problem)

It will not corrupt the file, but it might make people enter it as read
only

 

[Bob Ford]

Thank you for the quick reply to my post. I wanted to clear the following:

- It is not an option to migrate Excel1.xls to Access db, there are too many
issues at work and again it is being utilized by various people from the
globe. At the moment, we need to keep using excel as a master listing.
- The code in Access db will import Excel1.xls (not linked), run several
queries to group and calculate totals and output the result to Excel2.xls

 

[aaron.kempf]

you should just use Access Data Projects and DTS.. SQL offers REAL
SCHEDULING CAPABILITIES; MDB IS FOR LAMERS

-Aaron

 

[Matt]

This guy is the worst

I hate you so so much

you should just use Access Data Projects and DTS.. SQL offers REAL
SCHEDULING CAPABILITIES; MDB IS FOR LAMERS

-Aaron

 

[aaron.kempf]

eat a dick i am RIGHT

Access MDB can't be scheduled for all practical purposes.

SQL Server and Access Data Projects this works like a charm.

since ADP is the rightful heir to the 'access' name you kids should
just learn it.
mdb has been dead for almost 10 years

 

[Matt]

Sweet use of Caps to get your point across.

 

[aaron.kempf]

yeah.. just because I'm right

how are you going to schedule stuff with MS Access LoL

/X MacroName ROFL

what a friggin joke

-Aaron

 

[Matt]

yeah.. just because I'm right

how are you going to schedule stuff with MS Access LoL

/X MacroName ROFL

what a friggin joke

-Aaron

You are 12 yr old ... no doubt in my mind.

TAADB!!!
ROFL

 

[aaron.kempf]

Excel is for losers and retards; lose the training wheels; bud

-Aaron

 

[aaron.kempf]

shut the **** up bitch

i'm RIGHT

Access does not have scheduling capabilities.

if you were using an Access Data Project it would be very very simple
to configure a SQL agent _JOB_ to run on a scheduled basis.

-Aaron