Hi;
I have a basic question, after I created MDE file from MDB file, do I have to install the MDE file in each user's pc? (We are sharing the data from SQL server), or I only create a short cut for the MDE, so everybody in office will run that one which is located in a share folder?
Thank you very much.
Jt
9 4997 Megalog 378
Recognized Expert Contributor
Every client has to have either Access installed, or the Access Runtime file. (runtime is free for access 2007, but not prior versions)
Ideally, they should have a copy on their own pc, since the data is shared outside of the mde.
What I've done, is create a batch file and give all the employees a shortcut to it (or link it from an intranet page). When they run the batch file, it deletes any existing copies of the MDE on the user's drive, and then creates a copy from the current live MDE on the network. This way, I can continuously update the MDB file, push out a new copy of the MDE on the network, mark it as read-only, and I know that whenever they start the application that they're using the most current copy available. Save the following in a text file and give it a .BAT extension, and edit to fit your situation: - DEL "C:\Data\*.mde /q
-
-
copy "S:\YourNetworkPath\YourAccessFile.mde" C:\DATA /V /Y
-
-
START /MAX "C:\Program Files\Microsoft Office\OFFICE12\MSACCESS.EXE /runtime" "C:\Data\YourAccessFile.mde"
Your users will need to have a common folder to copy to locally, and in the last line, change it to whichever access version your clients are running.
If they're using different versions, then you could make a different batch file for each version.
Yes, each user should have a copy of the frontend db on their own PC! Multiple users using a single frontend on a shared drive is one of the top two or three reasons cited for chronic corruption problems!
Megalog has offered a solid strategy for updating and distribution of you MDEs.
Welcome to TheScripts!
Linq ;0)>
thanks guys, really helpful.
jt
Glad we could help!
Linq ;0)> Megalog 378
Recognized Expert Contributor
Am glad to help! If your MDE is pretty much finalized at this point, you can set this up and forget it. But if you're developing parts of it while it's in use, this will save you a lot of headaches. You can also set up versioning, by storing a constant in a front-end module, and a value in the back-end, and have a small invisible form with a timer set to check every hour that the version numbers match. If they dont match, a simple message box can alert the user that there's a new version out there, and they should reload their MDE. This would work good for those who like to leave their applications running forever, or if they copy the MDE somewhere else to their system and open that instead of using the batch copy utility.
Sounds great, Megalog
One more question:
Usually I will ask each user to put a short cut to their desktop, if the .bat file called: myDataAccess.ba t,
I will put it in each user's common folder (the folder which can load my Access MDE from the server pc).
Then I just put the myDataAccess.ba t short cut to their desktop, so if the user clicks, it will run the .bat file automatically, and the new MDE will replace the current one.
Am I correct? Any suggestion will be great.
Thank you very much.
jt
Am glad to help! If your MDE is pretty much finalized at this point, you can set this up and forget it. But if you're developing parts of it while it's in use, this will save you a lot of headaches. You can also set up versioning, by storing a constant in a front-end module, and a value in the back-end, and have a small invisible form with a timer set to check every hour that the version numbers match. If they dont match, a simple message box can alert the user that there's a new version out there, and they should reload their MDE. This would work good for those who like to leave their applications running forever, or if they copy the MDE somewhere else to their system and open that instead of using the batch copy utility.
Megalog 378
Recognized Expert Contributor
Sounds great, Megalog
One more question:
Usually I will ask each user to put a short cut to their desktop, if the .bat file called: myDataAccess.ba t,
I will put it in each user's common folder (the folder which can load my Access MDE from the server pc).
Then I just put the myDataAccess.ba t short cut to their desktop, so if the user clicks, it will run the .bat file automatically, and the new MDE will replace the current one.
Am I correct? Any suggestion will be great.
Thank you very much.
jt
Yep a shortcut to the .BAT file is ideal, since then you can make changes to the .BAT file whenever you want. So you're able to change your BAT, and MDE on the fly, giving you all the flexibility you want.
Megalog,
First of all, I tried mirroring your directions above but must have missed something - the "new" mde was still the "old" mde after I ran the batch file.
Here is my Batch text: - DEL "C:\Documents and Settings\bcraft\My Documents\Tax\*.mde /q
-
-
copy "U:\Db\BAT DB.mde" C:\Documents and Settings\bcraft\My Documents\Tax /V /Y
-
-
START /MAX "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE /runtime" "C:\Documents and Settings\bcraft\My Documents\Tax\BAT DB.mde"
If this is all correct then I must be missing something else.
Secondly, could you offer some more detail here? I'm curious about the versioning for my development as well.
But if you're developing parts of it while it's in use, this will save you a lot of headaches. You can also set up versioning, by storing a constant in a front-end module, and a value in the back-end, and have a small invisible form with a timer set to check every hour that the version numbers match. If they dont match, a simple message box can alert the user that there's a new version out there, and they should reload their MDE.
Thanks!
martin
Megalog 378
Recognized Expert Contributor
Hey Martin,
Apparently when I copied my batch info over I missed a quote mark in the first row. And, the 2nd row should have had quotes around the destination path (in my example it works without quotes, but if you're using long path names with spaces, like you are, they should always be enclosed in quotes).
Here is what I should have posted above: - DEL "C:\Data\*.mde" /q
-
-
copy "S:\YourNetworkPath\YourAccessFile.mde" "C:\DATA" /V /Y
-
-
START /MAX "C:\Program Files\Microsoft Office\OFFICE12\MSACCESS.EXE /runtime" "C:\Data\YourAccessFile.mde"
so in your case, this should work: - DEL "C:\Documents and Settings\bcraft\My Documents\Tax\BAT DB.mde" /q
-
-
copy "U:\Db\BAT DB.mde" "C:\Documents and Settings\bcraft\My Documents\Tax" /V /Y
-
-
START /MAX "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE /runtime" "C:\Documents and Settings\bcraft\My Documents\Tax\BAT DB.mde"
Now, in the delete line, I have it set to delete all MDE's... You may not want that wildcard if you have more than one front end being executed from the same location.
Let me know if it works out for you. I'll get into how I did the versioning a bit later, although I think I've seen some similar examples already posted here in the forums in the past.. so you may want to try searching a bit.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: matt |
last post by:
I have compiled some code, some written by me, some compiled from
various sources online, and basically i've got a very simple flat file
photo gallery. An upload form, to upload the photos and give them a
caption, storing the caption and filename in a text file. It's a bit
buggy when removing the photos and captions from the file, and also in...
|
by: Dave Smithz |
last post by:
Hi There,
I have a PHP script that sends an email with attachment and works great when
provided the path to the file to send.
However this file needs to be on the same server as the script.
I want to develop a webpage where people can send attachments that are
stored on their local PC.
|
by: Joseph |
last post by:
Hi,
I'm having bit of questions on recursive pointer. I have following
code that supports upto 8K files but when i do a file like 12K i get a
segment fault. I Know it is in this line of code. How do i make the
last pointer in the indirect sector that has another level of indirect
pointer, and be defined recursively to support infinite...
|
by: StGo |
last post by:
How can i read/write file's custom attributs(like subject,author...) in
C#???
Thanks :))
|
by: Lokkju |
last post by:
I am pretty much lost here - I am trying to create a managed c++
wrapper for this dll, so that I can use it from c#/vb.net, however, it
does not conform to any standard style of coding I have seen. It is
almost like it is trying to implement it's own COM interfaces...
below is the header, and a link to the dll+code:
Zip file with header,...
| |
by: Sky Sigal |
last post by:
I have created an IHttpHandler that waits for uploads as attachments for a
webmail interface, and saves it to a directory that is defined in
config.xml.
My question is the following:
assuming that this is suppossed to end up as a component for others to use,
and therefore I do NOT have access to their global.cs::Session_End()
how do I...
|
by: Roy |
last post by:
Hi,
I have a problem that I have been working with for a while.
I need to be able from server side (asp.net) to detect that the file i'm
streaming down to the client is saved completely/succsessfully on the
client's computer before updating some metadata on the server (file
downloaded date for instance)
However,
All examples i have tried,...
|
by: Shapper |
last post by:
Hello,
I created a script to upload a file.
To determine the file type I am using userPostedFile.ContentType.
For example, for a png image I get "image/png".
My questions are:
1. Where can I find a list of all the types which can be returned?
For example, if it is a Word document will it return "document/doc".
|
by: troutbum |
last post by:
I am experiencing problems when one user has a document open through a
share pointing to the web site. I use the dsolefile to read the
contents of a particular directory and then display them in a
datalist. When the next user selects trys to run the page, the page
fails and I get a generic error message from the stack trace. I am
assuming...
|
by: thjwong |
last post by:
I'm using WinXP with Microsoft Visual C++ .NET
69462-006-3405781-18776, Microsoft Development Environment 2003 Version
7.1.3088, Microsoft .NET Framework 1.1 Version 1.1.4322 SP1
Most developers said to me that they have no problem doing that, but
the following project file is said to be corrupted while opening in the
IDE, it is the project...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |