I'm writing some VBA code to save my project98 file to access97. I will
be running this file everyday, so the database will already exist. I'm
using the project.Application.SaveAs function to save the file.
Basically, I need to somehow explicitly express that I want to append to
the existing database when I save instead of overwriting it. Right now,
when I use the SaveAs command, I get a pop up window asking me if I want
to append or overwrite. I need to write code so that this pop up window
doesn't show up. I've tried to use SendKeys to get through this popup
window, but SendKeys doesn't work when the code is running on my machine
while I'm logged out, so it is not an acceptable solution.
Any ideas?
be running this file everyday, so the database will already exist. I'm
using the project.Application.SaveAs function to save the file.
Basically, I need to somehow explicitly express that I want to append to
the existing database when I save instead of overwriting it. Right now,
when I use the SaveAs command, I get a pop up window asking me if I want
to append or overwrite. I need to write code so that this pop up window
doesn't show up. I've tried to use SendKeys to get through this popup
window, but SendKeys doesn't work when the code is running on my machine
while I'm logged out, so it is not an acceptable solution.
Any ideas?