Access startup commands to convert file??

[Raymond Pistey Jr]

Does anyone know a command I can run from start, run that will open an
acess database (mine has 22 tables) minimized and open say table #2, then
run a macro that selects all that data in table #2 and saves it as a comma
or tab delimited text file. I have an access 2000 file created by a custom
program that creates this access file and it's structure can't be altered
but I can open it and export the table manually but would like to provide a
1 button solution to my endusers, once it's in that text file I can do what
I need to with it.

Thanks
Ray Pistey

 

[Wayne Morgan]

There is a command line option to run a macro at startup or you could just
create a macro called autoexec and it will run automatically when you open
the database. The problem is, both of these options would require you to
create a macro in the file which you won't be able to do if you aren't
allowed to make changes to the file. It may be easier to create another mdb
file that you do have control over. In this new mdb file, link to the table
in the other file. You could then create your macro in the file that you own
and export the linked table.