If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Forms vs Pages
Hi,
I am currently building a small Job Ticketing DB for my own use within my company. Build the tables, forms, links and all works as intended. I am very new to Access as this is my first "real" DB project. As a Network Engineer I don't get to do this much so I am having a ball! My first question is: I would like my users to have a short cut on their desktop's to a very simple and easy to use form. I also have this as an html version as well. Now when my users launch the shortcut it opens the full blown Access App. Is there a way to avoid this? I really don't want Access installed on every workstation. Can I use an .html page to do this? If so can Access handle the request (act as a web server) or would I need a web server set up with hooks to the backend? My second question: My DB resides on my Network. I build it on my local PC then moved it to the Network and fixed the links. Now when my users click on the shortcut they get an error saying that the DB is open and being used by a nother. I have checked and it is NOT open anywhere. Any idea's what could be causing this problem? Thanks, Jay |
#2
|
|||
|
|||
Forms vs Pages
"Jay" wrote in message
... Hi, I am currently building a small Job Ticketing DB for my own use within my company. Build the tables, forms, links and all works as intended. I am very new to Access as this is my first "real" DB project. As a Network Engineer I don't get to do this much so I am having a ball! Yes...ms-access is a whole new playground. You can fall off the swing set and get hurt real easy! (but it is still fun!) ;-) My first question is: I would like my users to have a short cut on their desktop's to a very simple and easy to use form. Generally, the approach to the above is simply to provide a short cut to your mdb file. In your mdb file, in the tools-startup you can set the form that runs. In fact, you can set a LOT of stuff in the tools-startup. For a real quick and easy example of what startup can do, try downloading the 3rd example at: http://www.attcanada.net/~kallal.msn...s/DownLoad.htm The above hides all of the ms-access stuff..and will give you some ideas as to how to hide all the stuff you DO NOT want your users to see. have this as an html version as well. Now when my users launch the shortcut it opens the full blown Access App. Is there a way to avoid this? I really don't want Access installed on every workstation. Not much you can do avoided the above. You can purchase a runtime edition of ms-access, and it will allow you to create a windows install package that will install your application + access runtime. The runtime is like the full version, but you can't modify the forms etc. This runtime can be distributed royalty free. (you need the developers edition of ms-access to do this). Can I use an .html page to do this? If so can Access handle the request (act as a web server) or would I need a web server set up with hooks to the backend? You got the above correct. That is you need to run a full web server. If you run the web server, then you are not using ms-access forms, reports etc, but just using the mdb file as a data store. Your application will thus have to be re-written for a web server. This is certainly a way to not have to install ms-access on each pc..but then again you are not using ms-access anymore..but web pages. My second question: My DB resides on my Network. I build it on my local PC then moved it to the Network and fixed the links. Now when my users click on the shortcut they get an error saying that the DB is open and being used by a nother. I have checked and it is NOT open anywhere. Any idea's what could be causing this problem? Make sure you are not opening the mdb file in exclusive mode. tools-options-Advanced tab Make sure the default open mode is shared. Also, if you plan to use this system on a network, you should distribute a mde to each workstation, and split your database. This is really a requirement for multi-user system. Check out: http://www.granite.ab.ca/access/splitapp.htm -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.attcanada.net/~kallal.msn |
Thread Tools | |
Display Modes | |
|
|