Use database on server without having MS Access

[james_IT]

Hi guys

I think i already know the answer to this but thought i would check

I have placed a database in a shared folder on a server for other users to use.

Is there a way for them to use the database without having MS Access installed on each machine (they have MS Office but not Access)...?

Thanks

 

[JANR]

No, but you can install Access Runtime with is free for access 2007/10

JR

 

[james_IT]

No, but you can install Access Runtime with is free for access 2007/10

JR

thanks. i have 2003 and it was designed on 2003.

am i at a dead end?

 

[JANR]

Well no, the runtime will open a mdb, but since runtime is a stripped down Access shell you'll need to ensure that no runtime errors occures, that will force the application to quit.

Also provide navigation in the application.

JR

 

[james_IT]

Well no, the runtime will open a mdb, but since runtime is a stripped down Access shell you'll need to ensure that no runtime errors occures, that will force the application to quit.

Also provide navigation in the application.

JR

ok so i can download the latest runtime from microsoft for free? i just need to install this on each pc that wants to use it?

I have custom navigation in the database in the way of command buttons and forms.

Do you know where i can read more information on ensuring no runtime errors occur etc as i have no experience of it what-so-ever!

Thanks for all your help

 

[JANR]

To stop runtime errors you'll need to include error handles in the code where an error might occure. MZ-Tools have a free utillity that can help you with this: http://www.mztools.com/index.aspx

You don't need to put error handel on simple code where you covered all the bases, but on unexpecteted errors that might happen due to user error such as passing Nulls to subs or functions where that will cause an error. The sky is the limit here.

Test your application in a runtime enviroment and see what works and what needs more work.

An other thing to consider is to issue a VBA certificate to your deplyoed application so your users dosen't get a securety alert every time the open your db.

JR

 

[james_IT]

To stop runtime errors you'll need to include error handles in the code where an error might occure. MZ-Tools have a free utillity that can help you with this: http://www.mztools.com/index.aspx

You don't need to put error handel on simple code where you covered all the bases, but on unexpecteted errors that might happen due to user error such as passing Nulls to subs or functions where that will cause an error. The sky is the limit here.

Test your application in a runtime enviroment and see what works and what needs more work.

An other thing to consider is to issue a VBA certificate to your deplyoed application so your users dosen't get a securety alert every time the open your db.

JR

thank you

will a vba self cert do the job or will it still give a security warning?

 

[JANR]

It should only give you the warning the first time, it will then store the certificat on the users PC.

But if you make changes to the master you have to re-issue the certificat to the master before you depoly the new version.

JR

 

[gemma-the-husky]

james - the run time version of access is the exact same version as the normal version, but without much of the functionality.

you lose all the ribbons (except for some simple defaults), and get no error handling. You have to add all these yourself if you need it.

if you have full A2007, you can simulate/test runtime (to see waht it looks like) by opening any database in run time mode.

 

[james_IT]

thanks guys. i have installed runtime and so far i havnt had any errors on any of the forms, reports or commands that i have tried so im good so far.

there is nothing too complicated in there so hopefully wont encounter any issues

thanks for all your help