By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,231 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

MDE front-end on network share?

P: n/a
Hello,

I converted an Access application that used to have a MDE front-end
(distributed to each user) with a MDB back-end on a share. It now has a
MDE front-end with linked ODBC SQL Server 2000 tables as the back-end.
Is it a bad practice to place the MDE front-end on a network share
instead of sending a copy to each user? I want to do this as a form of
cheap security, since the network share has access control on it.
Previously, the MDB back-end was on this protected share. Are there
problems inherent with multiple users opening the same MDE front-end
simultaneously? I'd rather not check user IDs inside the application
and send out copies of the front-end at this time.

Thanks,

JM


*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Jay Mack wrote:
Hello,

I converted an Access application that used to have a MDE front-end
(distributed to each user) with a MDB back-end on a share. It now
has a MDE front-end with linked ODBC SQL Server 2000 tables as the
back-end. Is it a bad practice to place the MDE front-end on a
network share instead of sending a copy to each user? I want to do
this as a form of cheap security, since the network share has access
control on it. Previously, the MDB back-end was on this protected
share. Are there problems inherent with multiple users opening the
same MDE front-end simultaneously? I'd rather not check user IDs
inside the application and send out copies of the front-end at this
time.


It will be slower and will increase the chances of the MDE getting
corrupted, but since your data is in a server database you shouldn't have to
worry about corruptions of the data like you would if the data were in an
MDB file.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

P: n/a
In my experience with using an MDE to an Oracle ODBC
backend, save yourself a LOT of heartache and put copies on
the local machine. I had 3 weeks of corruption hell before
I did that. Yes, the data was not affected (except for
users frustrated with losing data), but it wasn't worth the
aggravation.

What I DID leave on the network share was the dedicated MDW
workgroup file. That way, you still have to have access to
the share in order to get the database to execute. Of
course, that is assuming that you have the user/group
security set up correctly.

--
Kevin Nechodom
University of Utah Hospital and Clinics
Kevin dit Nechodom ack hsc dit utah dit edu
"Call me paranoid, but I think you are reading what I'm
writing!"
Rick Brandt<ri*********@hotmail.com> 7/18/2005 9:32:36
AM >>>Jay Mack wrote:
Hello,

I converted an Access application that used to have a
MDE front-end (distributed to each user) with a MDB
back-end on a share. It now has a MDE front-end with
linked ODBC SQL Server 2000 tables as the back-end.
Is it a bad practice to place the MDE front-end on a
network share instead of sending a copy to each user?
I want to do this as a form of cheap security, since the
network share has access control on it. Previously, the
MDB back-end was on this protected share. Are there
problems inherent with multiple users opening the same
MDE front-end simultaneously? I'd rather not check
user IDs inside the application and send out copies of
the front-end at this time.
It will be slower and will increase the chances of the MDE
getting corrupted, but since your data is in a server
database you shouldn't have to worry about corruptions
of the data like you would if the data were in an MDB

file.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #3

P: n/a


Kevin,

Thanks for the info. If I create this MDW file for my project, will
Access automatically look for it every time anybody starts the
application? Do I have to have a flag in my shortcut?

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #4

P: n/a
Jay Mack wrote:
Kevin,

Thanks for the info. If I create this MDW file for my project, will
Access automatically look for it every time anybody starts the
application? Do I have to have a flag in my shortcut?


You have to specify it in the shortcut or else the user's default mdw file
is used.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.