Exit A Database In Order To Go To Design View

[KnightBall]

I have downloaded a sample application (.mdb) that runs the form when the
file is double clicked.

How do I get to design view. The toolbars and other functionality is
disabled.

I am using Access 2007.

 

[Pete D.]

This of assumes that the datafile is running in full version of access and
menus haven't been disabled. You need to click the MS round button in the
access window at the top left and then select access option at the bottom
right of the menu. Next select current database. Next select Navigation,
display navigation. Click okay until back in the datafile normal window.
Access may prompt for a restart, if so do that. In the navigation window on
the left (may need to click >> to expand) Right click on the Access Object
bar at the top and select show all groups. You should now be able to see
all the items.

 

[a a r o n . k e m p f]

you might not be able to-- Jet is not reliable.

you shoudl ask your vendor to upsize to SQL Server.

----------------------------------------------------------------------------------------
Access, however, is not perfect. Performance degrades significantly as
the database size increases. The database is also prone to corruption.
Finally, starting with an Access database has tempted many developers
to do a dangerous thing. Sometimes a single-user application becomes
popular enough that there's a desire for it to be used by multiple
simultaneous users. The temptation is to just move the Access database
file to a network share, copy the application to multiple machines,
and let many users connect simultaneously. Access performance drops
off quickly with multiple users, and it's highly unlikely that an
application that was designed for a single user will work reliably
with concurrent users.

http://msdn.microsoft.com/en-us/library/aa730870(VS.80).aspx

 

[Pete D.]

What does this mis-infomation have to do with the original question. Please
ignore Aaron as SQL server is the only response he knows to any question. I
my suggestion doesn't work post back.

message
you might not be able to-- Jet is not reliable.

you shoudl ask your vendor to upsize to SQL Server.

----------------------------------------------------------------------------------------
Access, however, is not perfect. Performance degrades significantly as
the database size increases. The database is also prone to corruption.
Finally, starting with an Access database has tempted many developers
to do a dangerous thing. Sometimes a single-user application becomes
popular enough that there's a desire for it to be used by multiple
simultaneous users. The temptation is to just move the Access database
file to a network share, copy the application to multiple machines,
and let many users connect simultaneously. Access performance drops
off quickly with multiple users, and it's highly unlikely that an
application that was designed for a single user will work reliably
with concurrent users.

http://msdn.microsoft.com/en-us/library/aa730870(VS.80).aspx

 

[John W. Vinson]

I have downloaded a sample application (.mdb) that runs the form when the
file is double clicked.

How do I get to design view. The toolbars and other functionality is
disabled.

I am using Access 2007.

If the sample hasn't been designed to block the ability to bypass the startup,
hold down the Shift key while opening the database.