473,883 Members | 1,648 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Design Changes To Objects In Shared MultiUser Database

We recently converted our department wide shared Access97 database to
Access2K. We used to be able to open various reports in design mode and make
changes to the design (or create new reports) even while other users in this
shared database might be using other, unrelated reports.

Now, in Access2k, it appears that whenever you do not have exclusive access,
you cannot make any design changes to reports. It seems that the presence
of any other person in the database prevents us from working the way we did
before.

Am I missing something or is this a design feature of Access 2000? Seemed
like the old A97 required exclusive access at the object (report) level --
whereas Access 2000 does this exclusive access issue at the entire MDB
level.

Is there a work around to this in Access 2000 or will we have to just accept
this situation?


Nov 12 '05 #1
6 4263
A2000 changed to a monolithic save.

The best solution is to split your database into back end (tables only) and
front end (all other objects, and linked tables). Place the b.e. on a shared
resource (server). Give each user their own local copy of the f.e. This
allows you to perform upgardes on your local copy, and then distribute the
upgrade to other users.

Although it was possible to get away without doing this in A97, it was
subject to corruption, so splitting is the best approach in all versions.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html

"Mike Wiseley" <mi**********@g te.net> wrote in message
news:vX******** *********@nwrdd c02.gnilink.net ...
We recently converted our department wide shared Access97 database to
Access2K. We used to be able to open various reports in design mode and make changes to the design (or create new reports) even while other users in this shared database might be using other, unrelated reports.

Now, in Access2k, it appears that whenever you do not have exclusive access, you cannot make any design changes to reports. It seems that the presence of any other person in the database prevents us from working the way we did before.

Am I missing something or is this a design feature of Access 2000? Seemed
like the old A97 required exclusive access at the object (report) level --
whereas Access 2000 does this exclusive access issue at the entire MDB
level.

Is there a work around to this in Access 2000 or will we have to just accept this situation?


Nov 12 '05 #2
ab************* **@bigpond.net. au (Allen Browne) wrote in
<Qo************ ********@news-server.bigpond. net.au>:
Although it was possible to get away without doing this in A97, it
was subject to corruption, so splitting is the best approach in
all versions.


And it was also the best approach in A95 and in Access 2.

Indeed, anyone who ever bothered to read the Access help file on
setting up a multi-user database, or browsed the MS Knowledge Base
for articles on the subject, would have found that splitting data
and code was recommended almost 10 years ago.

So, anyone who is *not* splitting their multi-user databases for
production use really isn't competent in using Access at all.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #3
The tone of your response is a sharply worded, David, but thanks for your
comments anyway. In this case, the front end reports and queries are already
split from the back end SQL server database which is located on a web server
at a different location. There is also second back end Access mdb that
houses some of the local data tables.

However, we have several folks using the same single front end mdb file on a
shared network for running queries and reports. Of the 50 or so reports,
each user really only opens the 5-6 reports that individually speak to their
needs (they are segmented by product line). The issue was that we used to be
able to edit or even create new reports and work in the design mode of
certain reports (if they had not be opened by a particular user already for
their own operational needs).
"David W. Fenton" <dX********@bwa y.net.invalid> wrote in message
news:94******** *************** ****@24.168.128 .86...
ab************* **@bigpond.net. au (Allen Browne) wrote in
<Qo************ ********@news-server.bigpond. net.au>:
Although it was possible to get away without doing this in A97, it
was subject to corruption, so splitting is the best approach in
all versions.


And it was also the best approach in A95 and in Access 2.

Indeed, anyone who ever bothered to read the Access help file on
setting up a multi-user database, or browsed the MS Knowledge Base
for articles on the subject, would have found that splitting data
and code was recommended almost 10 years ago.

So, anyone who is *not* splitting their multi-user databases for
production use really isn't competent in using Access at all.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Nov 12 '05 #4
"Mike Wiseley" <mi**********@g te.net> wrote in message news:<Uy******* ***********@nwr ddc03.gnilink.n et>...
The tone of your response is a sharply worded, David, but thanks for your
comments anyway. In this case, the front end reports and queries are already
split from the back end SQL server database which is located on a web server
at a different location. There is also second back end Access mdb that
houses some of the local data tables.

However, we have several folks using the same single front end mdb file on a
shared network for running queries and reports. Of the 50 or so reports,
each user really only opens the 5-6 reports that individually speak to their
needs (they are segmented by product line). The issue was that we used to be
able to edit or even create new reports and work in the design mode of
certain reports (if they had not be opened by a particular user already for
their own operational needs).


Mike,
how about something like a compromise. Go to Tony Toews's site and
download the Front End Updater code. Then you could have front ends
that are customized for each group (if I'm reading your post right).
Then you reduce the risk of your database corrupting. If you really
wanted to include a report that someone built into the core set or
whatever, you could include code to import a list of objects into your
front ends... (but I think that's what Tony's code does...)

http://www.granite.ab.ca/accsmstr.htm

See Auto FE Updater...

It *might* be what you're looking for.

Peace,
Pieter
Nov 12 '05 #5
mi**********@gt e.net (Mike Wiseley) wrote in
<Uy************ ******@nwrddc03 .gnilink.net>:
The tone of your response is a sharply worded, David, but thanks
for your comments anyway. In this case, the front end reports and
queries are already split from the back end SQL server database
which is located on a web server at a different location. There is
also second back end Access mdb that houses some of the local data
tables.

However, we have several folks using the same single front end mdb
file on a shared network for running queries and reports. Of the
50 or so reports, each user really only opens the 5-6 reports that
individually speak to their needs (they are segmented by product
line). The issue was that we used to be able to edit or even
create new reports and work in the design mode of certain reports
(if they had not be opened by a particular user already for their
own operational needs).


And that was never a good idea, ever, and it was always at variance
with the standard operating practices recommended in the MS help
files and Knowldege Base.

You were doing it wrong all along, so the fact that is broken now
just shows that you had an unsupportable architecture on the front
end.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #6
"Mike Wiseley" wrote
The tone of your response is a
sharply worded, David, . . .
Mike, David has never been one to "mince words". And while it may be a
startling way to do it, it is clear that he got your attention with those
"sharp words".
However, we have several folks using
the same single front end mdb file on a
shared network for running queries and
reports.


But, I'll agree with him that there is an overwhelming mountain of advice
against multiple users logging in to the same front-end or monolithic
database. There is SO much that it is hard to imagine anyone frequenting
this newsgroup, as I know you do, who hadn't seen it time after time.

It is possible to have multiple users concurrently using the same front end
without corruption for a long time . . . that's often reported by people who
ask here "why did my database suddenly start corrupting so frequently?" And
the answer is that some little change somewhere in the database, or outside
it in a .DLL, was "the straw that broke the camel's back".

But, it is bad practice to have multiple users concurrently in the same
front end or monolithic database, and that has been no secret ever since I
began working with Access multiuser and Access client databases back in
1994.
Nov 12 '05 #7

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

Similar topics

1
1347
by: newbie | last post by:
Hi there I use Access2002. I have designed a database in a router connected workgroup envirament. I put it into my shared doc folder so everybody in the workgroup have access to it. I want to have user level and object level of security control. I have setup a workgroup and added users to it. However, it only ask logon info when open it from my computer, anyone from other computer seems to have access only as a regular user by default...
2
1869
by: Matthew Hood | last post by:
My company has expressed a desire to convert an existing MS Access application to a full VB.NET application. My experience is with VB6 so I want to ask a few questions and get some input on the best way to handle the following design: Situation: We want to allow our customers to install with one of the following options: 1. Use an Access MDB file as the data backend. 2. Use a SQL Server backend. (Either MS SQL, or MySQL) 3. Use an...
8
2936
by: James | last post by:
Can someone explain the fundamental difference between creating a "multi user" version of an Access DB and creating a client-server Access DB? ie why can't all the users on my network just click on database.mdb and share the same database? why would I want to create a separate client/server architecture?
0
2520
by: YellowFin Announcements | last post by:
Introduction Usability and relevance have been identified as the major factors preventing mass adoption of Business Intelligence applications. What we have today are traditional BI tools that don't work nearly as well as they should, even for analysts and power users. The reason they haven't reached the masses is because most of the tools are so difficult to use and reveal so little
2
3202
by: Jami Bradley | last post by:
I'm in need of some design suggestions! We have a fairly large DB with thousands of users accessing data throughout the day. I have been given the task of restructuring a core part of the web application. It will be a design example for the rest of the site and I really want to get it right the first time! Basically we need to present a lot of data to the user. On a single page, we summarize about 5000 rows (grouped so they don't...
8
4142
by: morleyc | last post by:
Hi, until recently i was quite happy to add data sources from mssql database in visual studio and drag the datasets directly onto the form this creating a directly editable form which worked well. However i have recently started a project which will require synchronization to a remote database. Also the underlying database provider may change at a later date. From what i have read it seems that a layered approach is necessary, or at...
2
1286
by: CoopEng | last post by:
Hey all, I've been pouring through hundreds of forums recently and finally decided that I should get in on the action. I am trying to update some forms and reports, also some minor back end changes, to a database that is shared by approximately 20 people. I make these updates every 2 weeks or so. How the database is set up is that there is a front end and a back end on the network. All of the users create their own shortcut to the frontend...
3
1318
by: CoopEng | last post by:
Hi all, I've been pouring through hundreds of forums recently and finally decided that I should get in on the action. I am trying to update some forms and reports, also some minor back end changes, to a database that is shared by approximately 20 people. I make these updates every 2 weeks or so. How the database is set up is that there is a front end and a back end on the network. All of the users create their own shortcut to the frontend...
9
1372
by: Andy B | last post by:
I need to decide on how to store online signed contracts for customers and clients. I have considered a database in sql server 2005, but it seems to be too complicated. Besides, if the contract contents or layout for new contracts changes, I would have to change the whole database setup. Not to mention that there would be a lot of repeated fields which could be a waste of space. My next choice would be to keep the original unsigned blank...
0
9778
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
10833
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
7959
isladogs
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7114
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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5784
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5980
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4602
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
2
4205
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3228
bsmnconsultancy
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.