473,325 Members | 2,816 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

MDE file

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
Jan 18 '08 #1
9 4978
Megalog
378 Expert 256MB
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:

Expand|Select|Wrap|Line Numbers
  1. DEL "C:\Data\*.mde /q
  2.  
  3. copy "S:\YourNetworkPath\YourAccessFile.mde" C:\DATA /V /Y
  4.  
  5. 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.
Jan 18 '08 #2
missinglinq
3,532 Expert 2GB
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)>
Jan 18 '08 #3
thanks guys, really helpful.
jt
Jan 19 '08 #4
missinglinq
3,532 Expert 2GB
Glad we could help!

Linq ;0)>
Jan 19 '08 #5
Megalog
378 Expert 256MB
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.
Jan 19 '08 #6
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.bat,
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.bat 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.
Jan 20 '08 #7
Megalog
378 Expert 256MB
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.bat,
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.bat 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.
Jan 20 '08 #8
martin DH
114 100+
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:
Expand|Select|Wrap|Line Numbers
  1. DEL "C:\Documents and Settings\bcraft\My Documents\Tax\*.mde /q
  2.  
  3. copy "U:\Db\BAT DB.mde" C:\Documents and Settings\bcraft\My Documents\Tax /V /Y
  4.  
  5. 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
Feb 15 '08 #9
Megalog
378 Expert 256MB
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:

Expand|Select|Wrap|Line Numbers
  1. DEL "C:\Data\*.mde" /q
  2.  
  3. copy "S:\YourNetworkPath\YourAccessFile.mde" "C:\DATA" /V /Y
  4.  
  5. START /MAX "C:\Program Files\Microsoft Office\OFFICE12\MSACCESS.EXE /runtime" "C:\Data\YourAccessFile.mde"
so in your case, this should work:
Expand|Select|Wrap|Line Numbers
  1. DEL "C:\Documents and Settings\bcraft\My Documents\Tax\BAT DB.mde" /q
  2.  
  3. copy "U:\Db\BAT DB.mde" "C:\Documents and Settings\bcraft\My Documents\Tax" /V /Y
  4.  
  5. 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.
Feb 16 '08 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

2
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...
5
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. ...
7
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. ...
3
by: StGo | last post by:
How can i read/write file's custom attributs(like subject,author...) in C#??? Thanks :))
0
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....
13
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...
1
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...
3
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...
0
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...
0
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.