Access Link / Shortcut

[noks]

Hi guys

Is it possible to make a link or somthin in some1's desktop (user) so that they can jut click on it and get connected to my Ms Access application. Is it also possible 2 just display d form (i don't want the user 2 b able 2 see nor access my tables, queries and code)

Thanks

 

[boblarson]

Hi guys

Is it possible to make a link or somthin in some1's desktop (user) so that they can jut click on it and get connected to my Ms Access application.

Yes, just right click on the mdb file and select "create shortcut"

Is it also possible 2 just display d form (i don't want the user 2 b able 2 see nor access my tables, queries and code)
Thanks

Go to Tools > Startup and set the startup form, and uncheck show database window.

 

[noks]

Wow thank u. Now i want multiple users to use the same application but it's it doesn't allow them to make changes. it's complainin dat it's already opened elsewhere & in order 4 some1 2 make any changes they need 2 have exclusive access. I've made it shared application under tools but it's still complaining. Pls help

 

[boblarson]

If you have multiple users using this on a network, I would highly suggest (as would many others here) using a Front-end/Back-end split and each user having a separate copy of the front-end on their desktop.

You can get around having to manually get them a new copy by checking out this tool that I posted here
http://www.access-programmers.co.uk/forums/showthread.php?t=111132

but you probably want to download the latest version, which is here:
http://downloads.btlarson.com/AWF/Samples/Access_Front-End_AutoUpdating_Utility_rev01-02-2007.zip

There are a whole lot of posts on this forum (search for FE/BE) with info as to why it's good to have a front-end / back-end split with separate front-end on each user's computer.

 

[noks]

i'll try this and update u 2moro. Thanks