Database deployment

[jepoysaipan]

Hi Guys,

I'm back again to gain some knowledge, I am now in the deployment process but I don't have any idea to do it

I can distribute it by making .MDE to protect my code etc., but how about if the other PC doesn't have Access installed on the machine?

I read an article on the net and suggested that using an Access Developer Edition can make a distributable application even w/o Access installed on the PC, but honestly I don't have any idea on where to buy or how to implement that Access Developer Edition thingy.

Please help me to understand this lingo, and whatever items do I need to buy in order for me to implement and distribute my database to others.

Again, thanks in advance!

Jeff

 

[boblarson]

The Developer version actually allows you to use and distribute the Access RUNTIME (which is basically Access with the design features disabled). If you are using Access 2007, then the Developer extensions and Runtime are free. If not, then you would have to find a legitimate copy of it somewhere before you could do anything.

 

[jepoysaipan]

Thanks Bob!

Is it ok to develop Access 2007 while the machine is using a Windows XP?

Also, if you have time can you walk me on how to do the implementation & deployment.

Thanks a lot.

 

[boblarson]

I haven't actually done one yet. But, perhaps this will help:

http://office.microsoft.com/en-us/access/HA102188641033.aspx

 

[pbaldy]

That link is timing out on me, but I have an XP box with both Access 2000 and 2007 on it, and have no problems developing apps in each.

 

[boblarson]

That link is timing out on me, but I have an XP box with both Access 2000 and 2007 on it, and have no problems developing apps in each.

Not sure why it is timing out on you Paul, as it comes right up for me (maybe as an MVP fresh off the summit they decided you don't need to be able to get to it ).

 

[gemma-the-husky]

jepoysaipan

please be aware that if you distribute the runtime environment, you will lose all the access bells and whistles - sort buttons/filter buttons/import export commands/errorhandling/menubars i think?

you need to provide everything you need in code, and make sure the code is robust.

 

[boblarson]

Yes, you have to provide your own menus/toolbars and, in the case of Access 2007, Ribbons and you have to have "bullet-proof" error handling so the program doesn't crash if an unhandled error occurs.

 

[jepoysaipan]

Wow!

This is massive info. I am a DOS programmer and slowly switching to windows that's why I started in Access, I have the knowledge and the design of forms, reports & query but for the menu, toolbar & deployment I am a newbie.

Thanks a lot for all your inputs, have to study more .

Also, can you recommend a site where I can watch a video tutz on how to start all over again, I am willing to pay or anyone has a tutz where I can purchase to gain knowledge on the OVERALL system creation.

Salamat po!