473,324 Members | 2,548 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,324 software developers and data experts.

The wisdom of a access-MVP please !

Hi,

A housebuiling firm has now 1 access-DB for the clients witch is used mostly
bij remote desktop by only 1 person and it opens exclusively since now only
one person is responsebly for entering data.
The firm now wants 3 new databases:
1. Firm-contacts-DB: database for contractors and suppliers.
2. After delivery service DB: linked to the clients-DB and the
Firm-Contact-DB for de contractors
3. Articles-DB: linked to Firm-Contact-DB for the suppliers.

Database 1 could be used by 5 user simultaniously, some users remotly.
1. Is this a problem?
2. What happens if 2 users edit the same record?

thanks,

Filip
Nov 13 '05 #1
6 1234
"Filips Benoit" <be***********@pandora.be> wrote in message
news:5I********************@phobos.telenet-ops.be...

Database 1 could be used by 5 user simultaniously, some users remotly.
1. Is this a problem?
Not as long as it has been implemented correctly, that is a split front/back
end configuration with each user having their own copy of the FE.
2. What happens if 2 users edit the same record?

A warning message will appear when a user tries to commit the change
allowing the user to either drop their changes or overwrite the other user's
change.

HTH - Keith.
www.keithwilby.com
Nov 13 '05 #2
Put all your tables in ONE back-end mdb on the server, and don't
duplicate the columns of any one table in any other except for key
columns, especially if they're used in relationships. And I highly
recommend relationships, WITH "enforce referential integrity". Use
queries to join tables/queries and filter your datasets. You can even
put ReadOnly queries in the back-end and link to them the way you link
to tables. That will reduce the amount of data pulled down across the
wire for, say, reports. Use Access security to create groups and
permissions for each type of user.

Your client should run under the Access product (or the runtime
version)installed on the client's equipment.

It would probably be easiest to maintain a single app for all users.
Access security does an adequate job of keeping users out of things
they shouldn't see, as long as you do it right. And by all means,
don't leave connection strings in plain text anywhere that a user can
get to them. They can be read in pass-through queries and code
modules. Unfortunately, Access security automatically gives ReadDesign
permission to users with Read permission on the object! One solution
is to create ODBC connections in the clients' Windows
ControlPanel/AdminTools/ODBCConnections (where passwords are hidden by
*****), and link to back-end tables through the ODBC connection.

Hope that helps.

Bob

Nov 13 '05 #3
screw front-end back-end

use ACCESS DATA PROJECTs
it is a much better solution; keeps all your data and queries in SQL
Server.. i mean-- one copy of everything is much better than a hundred
copies of everything

Nov 13 '05 #4
DFS
aa*********@gmail.com wrote:
screw front-end back-end

use ACCESS DATA PROJECTs
it is a much better solution; keeps all your data and queries in SQL
Server.. i mean-- one copy of everything is much better than a hundred
copies of everything


I think ADPs still require you to distribute the front-end, don't they? So
you're stuck with a hundred copies of everything.

You want one copy? Use web technologies. But then you lose out on the
riches of Access (and that's not sarcasm).

Nov 13 '05 #5
aa*********@gmail.com wrote:
screw front-end back-end

use ACCESS DATA PROJECTs
it is a much better solution; keeps all your data and queries in SQL
Server.. i mean-- one copy of everything is much better than a hundred
copies of everything


Aaron, we know you like ADPs but not everyone is in a position to change
over to them. There have been a lot of posts in this group describing
various problems with them and if you already have a lot of code
invested in an MDB it would be as well to change to a different platform
altogether as it would to re-code everything for an ADP.

To get to an ADP the types of things that would need changing are:

Queries
Would all become SQL Views, I've no problem with that, they are powerful
and are a better way to get data out of a SQL server than an Access
query but again, code invested in Access might include function calls
that would be a pain to implement on SQL Server.

DAO
If used would need converting to ADO, there's certain idiocyncracities
in ADO that would make themselves apparent, like .RecordCount not
working for all recordset types so this would cause a hell of a lot of
debugging for some. If in these circumstances .Recordcount would
generate a runtime error they would be easy to track down but they
don't, they just return -1 causing a logical error that isn't apparent
without stepping through code or knowing what you're looking for.

Temp local tables
You can use something like "create table #Mytemptable" in T-SQL, which
creates a table in the tmp database but unlike a local table in an MDB
it is only available in the scope of the current procedure. Anyone
converting would need to be aware of this.

I haven't investigated this fully, the above I came up with after a
cursory overview so there may be a whole loas of extra gotchas waiting
in the midst.

The biggest worry I would have in converting an application to ADP would
be quoting for it without having done it before to know what's there.

It's like quoting 2 days to wallpaper a room, a day to strip the old
stuff and a day to hang the new stuff. After stripping the old stuff
you're half way into the job put notice the plaster ("dry wall" for my
friends across the pond) is cracked and needs re-doing. You chip away at
this and find the brick wall needs re-pointing or has rising damp. The
two day job suddenly gets a lot longer.

Nov 13 '05 #6
Keith wrote:
2. What happens if 2 users edit the same record?


A warning message will appear when a user tries to commit the change
allowing the user to either drop their changes or overwrite the other user's
change.


In a SQL Server back-end, you get Hobson's choice "Drop changes or drop
changes" so you can't blindly overwrite someone else's input. I hope
when using a Jet back-end you can configure the same as the overwrite
thing is a bad thing.
Nov 13 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: bill | last post by:
I am trying to convince a client that dotNet is preferable to an Access project (ADP/ADE). This client currently has a large, pure Access MDB solution with 30+ users, which needs to be upgraded....
1
by: Grunt | last post by:
Hi, I have been trying to put together a rotating banner. the code works but I am having a problem with the caching of the banner images. no matter what I try the page is constantly reloading the...
0
by: Frederick Noronha \(FN\) | last post by:
---------- Forwarded message ---------- Solutions to Everyday User Interface and Programming Problems O'Reilly Releases "Access Cookbook, Second Edition" Sebastopol, CA--Neither reference book...
49
by: Yannick Turgeon | last post by:
Hello, We are in the process of examining our current main application. We have to do some major changes and, in the process, are questionning/validating the use of MS Access as front-end. The...
20
by: Olav.NET | last post by:
I am a .NET/C++ developer who is supposed to do some work with Access. I do not know much about it except for the DB part. Questions: *1* I am looking for INTENSIVE books to get quickly up to...
47
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small...
64
by: John | last post by:
Hi What future does access have after the release of vs 2005/sql 2005? MS doesn't seem to have done anything major with access lately and presumably hoping that everyone migrates to vs/sql. ...
4
by: Frank Rizzo | last post by:
In classic ASP, it was considered a bad idea to store VB6-created objects in the Application variable for various threading issues. What's the current wisdom on storing objects in the Application...
2
by: elein | last post by:
What is the current wisdom on setting the fsm variables for 8.0? How is it different from 7.4? Or is it? I am assuming these are the values that changed with Jan's changes. If not what were...
4
by: Jeff | last post by:
I need to set a minimum height for a div, yet have it expand with the contents. I have this from 2005: <style type="text/css"> div{ height: 12px; background-color: red; 1px solid...
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
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
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.