How to run MS Access on a Network

[jamesnkk]

Hi, I just completed a small application, I want to put the ms access application on a network so that many users can share the application.

Could you please advise, what are things that I need to prepare, I do not have a runtime software so it simple mdb file.

[Dököll]

Hi, I just completed a small application, I want to put the ms access application on a network so that many users can share the application.

Could you please advise, what are things that I need to prepare, I do not have a runtime software so it simple mdb file.

Hello, jamesnkk!

Try adding it to your LANShare. If you have a drive where you grab specific, important documents, you can make a folder there and simply add your .mdb file in that folder.

Do you have a LANShare, a drive letter or path housed on a Server?

Sorry for your troubles:-)

Dököll

[jamesnkk]

Hello, jamesnkk!

Try adding it to your LANShare. If you have a drive where you grab specific, important documents, you can make a folder there and simply add your .mdb file in that folder.

Do you have a LANShare, a drive letter or path housed on a Server?

Sorry for your troubles:-)

Dököll

The company is running on windows server, can I just create a shared folder and put that mdb file into it ?
Does it have a limitation how many user can run at a time ? do I need to configure any option in MS Access application. ?
Does all workstation need to install ms access in order to run the application ?

Sorry for asking too much

[anvidc]

The company is running on windows server, can I just create a shared folder and put that mdb file into it ?
Does it have a limitation how many user can run at a time ? do I need to configure any option in MS Access application. ?
Does all workstation need to install ms access in order to run the application ?

Sorry for asking too much

basically you need a front end program and back end database..

u have 2 choose :
1 ) Database at tools-> Database Utilities -> Database Splitter
2 ) ~ Create a New Access and Link table to the Server Database
~ Copy the New Access to All the user

[questionit]

Hi James,

"Does all workstation need to install ms access in order to run the application ?"

Yes, all workstations need to have Ms Access fully installed in order to run your .mdb file"

Qi

The company is running on windows server, can I just create a shared folder and put that mdb file into it ?
Does it have a limitation how many user can run at a time ? do I need to configure any option in MS Access application. ?
Does all workstation need to install ms access in order to run the application ?

Sorry for asking too much

[Megalog]

Check out this post on FE/BE distribution. If you have any questions feel free to ask away.

http://bytes.com/forum/thread760986.html

[missinglinq]

Your users either need a full version of Access installed or the Runtime version. Whether the Runtime version will cost you depends on which version of Access you are running. Access 2007 comes with the distributable Runtime version as part of it. If you run another version, you'll have to purchase another component to get the runtime; which one and at what cost depending on the version you run.

anvidc's response is actually spot on. Anytime you have multiple, simultaneous users, you need to split your db as he suggested. Placing an unsplit database on a shared drive with multiple users is reported to be the cause of repeated database corruption, along with the all too often data lose.

Linq ;0)>

[Megalog]

Your users either need a full version of Access installed or the Runtime version. Whether the Runtime version will cost you depends on which version of Access you are running. Access 2007 comes with the distributable Runtime version as part of it. If you run another version, you'll have to purchase another component to get the runtime; which one and at what cost depending on the version you run.

anvidc's response is actually spot on. Anytime you have multiple, simultaneous users, you need to split your db as he suggested. Placing an unsplit database on a shared drive with multiple users is reported to be the cause of repeated database corruption, along with the all too often data lose.

Linq ;0)>

Why would one need to purchase an older runtime? From what I understand, the 2007 Runtime can open any of the older access .mdb/.mde files. For an end user with no access installation, I dont see how an older runtime version would be any better than the free 2007 version.