Unable to view table structure

J

James

One of our customers has sent us an Access database file for a conversion
that has been compiled as an application (my guess is with VB). How can we
export the database tables to either a text file(s) or a SQL Server if they
are hidden? Thanks for your help.
 
J

James

James said:
One of our customers has sent us an Access database file for a conversion
that has been compiled as an application (my guess is with VB). How can we
export the database tables to either a text file(s) or a SQL Server if they
are hidden? Thanks for your help.
Click to expand...

Nevermind. Figured this one out myself. If you hold down the shift key when
you start the Access database file you will be switched from run mode to
design mode.
 
D

Douglas J. Steele

James said:
Nevermind. Figured this one out myself. If you hold down the shift key
when
you start the Access database file you will be switched from run mode to
design mode.
Click to expand...

Not quite. It's not really a case of "run mode" and "design mode".

You can set certain options such don't show the database window to
automatically occur when you open the database. However, the Shift key can
be used to bypass startup options.

Be aware, though, that it's possible to disable that behaviour.
 
E

eyal

James said:
Nevermind. Figured this one out myself. If you hold down the shift key when
you start the Access database file you will be switched from run mode to
design mode.
Click to expand...
 
Top