Access 2007

[_pi]

do you know a trick how to open a mdb with lets say 3 tables opened.
its annoying to perform the same clicks every time.
i tried acc, but that is very slow (can't be my cpu - quadcore)

thanks

[ken gray]

create a new macro
action="OpenTable"
hit F6
pic one your table names

do that two more times.

name that macro "autoexec"
and it'll do it each time.

if you dont want it to do that every time, name it something else and call the macro from the command line.

/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.

[/quote]

[_pi]

nice.
and my macro is arranging the windows

[_pi]

ken, do you know a more informative tool for mdb files ?
where you can see data and field types in a time.
in access i always have to switch between views.

[ken gray]

i dont know. but you can try this as a starting place.

SELECT MSysIMEXColumns.*
FROM MSysIMEXColumns;

[_pi]

how do i export the macro ?

[ken gray]

i dont think you can. you just have to call it via command-line param.