Re: Database Exclusive

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

If you are familiar with scheduling tasks, and you have one hour per day or
even week, that you know no users will be on (or if you are allowed a forced
logoff), a simplified version of Tony's autoFE should be relatively easy to
create. Admittedly, it won't have all the nice features that Tony's does,
but you can make a list of all required files and compare their
created/modification dates, and replace them, which is essentially how Tony's
works. His does it every time a user clicks the shortcut (which is very nice
indeed).

Or, even better, if you're IT group allows, use his.

Admittedly, initial setup on FE's on various local machines can be a bit of
a pain when its so easy to just share one of them, but the peace of mind in
not having to worry about possible corruption (from these means, anyway) in
the long run is definately something to be desired.


--
Jack Leach
www.tristatemachine.com

- "First, get your information. Then, you can distort it at your leisure."
- Mark Twain


"Stephen sjw_ost" wrote:

Good reading, thank you.
I understand what they were saying in the post(s) about the increased
possibility of file and data corruption, though I have never experienced this
with my network/Databases.
I will need to find out how to distribute the FE via a setup program. I have
never made one before. And I will need to either get permission to dll the
AutoFeUpdater or figure out how to create my own.
If you can help with or point me to where I can find examples of setup
programs that would be great. I'll have to post separately for the
AutoFEUpdater once I find out from my IT Dept if I can dll it and use it or
not.
Thanks again for your help. As always, you guys rock!
--
Stephen


"dymondjack" wrote:


here's a few... it took about 2min to find. Read up



http://www.granite.ab.ca/access/autofe/why.htm


http://bytes.com/groups/ms-access/677740-pros-cons-sharing-front-end-mdb-client-workstation-vs-server


http://bytes.com/groups/ms-access/191384-split-database-citrix-shared-front-end-question

--
Jack Leach
www.tristatemachine.com

- "First, get your information. Then, you can distort it at your leisure."
- Mark Twain


"Stephen sjw_ost" wrote:

You are the 2nd person to tell me that. I have never had any problems with
multiple users using/sharing the same FE DB and I have users from Florida to
New Mexico. Why is that "asking for trouble"?
Please explain or point me somewhere that does explain. I have yet to get a
direct answer as to why this would cause a problem. If it does cause a
problem I need to know what to look for and an answer to my question just may
be able to help me.

So back to my question, is what I am asking possible? If so, can you explain
how?
--
Stephen


"pietlinden@xxxxxxxxxxx" wrote:

Why would a user NOT open your front end in exclusive mode? They are
NOT designed to be shared. Each user should have a copy on his
computer. Are you implying that several users are sharing the same
front end? That is just asking for trouble.

.

Relevant Pages

  • Re: Database Exclusive
    ... I will need to find out how to distribute the FE via a setup program. ... And I will need to either get permission to dll the ... AutoFeUpdater or figure out how to create my own. ... That is just asking for trouble. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Building customized Setup.dll for installations
    ... In the C++ code of your setup DLL write some code that for example sends ... that is also registered by your app when it starts. ... I created a Visual C++ MFC DLL project to design the custom Setup.dll. ... >>> Everything works fine except on uninstall. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Check if a DLL exists...
    ... it was impressed upon me that any VBX files and DLL ... Would you really package a setup program with your EXE and not include ... Within that context I interpreted your reply as saying something to the ... one should also be responsible for all its dependencies". ...
    (microsoft.public.vb.general.discussion)
  • Re: Building customized Setup.dll for installations
    ... The setup solution is different from your C# solution. ... Setup DLL cannot be ... > I have a setup project that installs the app and other files on the> device. ... > Everything works fine except on uninstall. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Copying files to PPC during install process
    ... There are different kinds of "Setup DLLs": ... installation used with a Visual Studio "Setup and Deployment" ... You do not have to use the CAB that Visual Studio creates; ... DLL, so at an appropriate time, it can programatically create the file on ...
    (microsoft.public.pocketpc.developer)