Switchboard executable

[Dan]

I have a switchboard form in my database. Is there a way to create something
like an executable file for this switchboard and the database so that someone
using it doesn't have access to the table design, query design, etc.? How do
you typically package a database for use by someone else that just needs to
use it as is?

 

[boblarson]

You can't create an executable, but you can create an MDE file which will
compile the forms, reports, macros, and VBA code. You can use the Access
Developers Extensions which will let you package it for use with the Access
Runtime.

If using Access 2007 you can get and use the Runtime and developer
extensions for free. But, if you are using another version you would need to
purchase the developer version.

If you do use the runtime, you will need to provide bullet-proof error
handling for your database as well as all menus and toolbars as the standard
menus/toolbars are not available in the runtime.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

 

[Dan]

I should have said that I am using Access 2000 that came with Microsoft
Office 2000 Professional. Does that mean that I do not have the capability to
package the database without purchasing the developer's version?

Thanks for your prompt response.

Dan

 

[boblarson]

Yes, if you are using Access 2000 you would need to find a copy of the Access
2000 developer extensions somewhere. And, since it is no longer supported by
Microsoft, you will probably have to go the EBAY route or something.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________