VB code to make database run on an inTRAnet.

[Guest]

Shortly I'll be loading a db on my company's intranet for various users to
have access. Someone told me that I could add a line of VB to make it run
from the intranet from those users who have access to view the db.
Does anyone know anything about this? I've never heard of it before.

Also if you have any suggestions about loading a db onto an intranet, I
would be very thankful! I've never done it before.

Thanks!

 

[Rick Brandt]

Shortly I'll be loading a db on my company's intranet for various
users to have access. Someone told me that I could add a line of VB
to make it run from the intranet from those users who have access to
view the db.
Does anyone know anything about this? I've never heard of it before.

Also if you have any suggestions about loading a db onto an intranet,
I would be very thankful! I've never done it before.

Thanks!

An appropriate name you've chosen for yourself. If by "intranet" you mean
you want people to be able to run your app in a web browser then you are
misinformed. You would have to rewrite the application in a web technology
like ASP or ASP.Net. If you just mean you want them to use Access and share
your application on the company network then that is a different story.

Technically you can just put the MDB file on a network share and let people
run it. Access is multi-user capable right out of the box. It is HIGHLY
recommended though that shared Access applications be split into a "data
only" file that is shared on the network and an "everything else" file or
front end file that you install on each users local drive. This not only
makes it easier for you to continue to develop on a separate copy of your
own, but also greatly reduces collissions that can lead to corruption of the
file or data.

I've no idea what this "...line of VBA code..." is that you are referring
to.