473,325 Members | 2,785 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.

Shared access to Database

We recently upgrade form Office 97 to Office XP.

Under 97 we had about 15 small databases for various departments that shared
data.

In this example I'll use our Disconnect Database.

We have the DISCONNECT.MDB file on the network.
Each user would double click on the MDB file to open it (All 5 at the same
time)
They could edit using the form and launch the report to see all current
changes.

After the upgrade we are now limited to only 1 user in the database at a
time.

I have been glancing through the boards and I keep seeing this front
end/backend set up which is just far too much for the simple database
sharing we are currently doing.

What is the quick solution or is there a way to unlock the MDB file so it
behaves the same as the 97 version?

Thanks so much for all your help.

Doc
Nov 13 '05 #1
7 1584

Donald Watson wrote:
We recently upgrade form Office 97 to Office XP.

Under 97 we had about 15 small databases for various departments that shared data.

In this example I'll use our Disconnect Database.

We have the DISCONNECT.MDB file on the network.
Each user would double click on the MDB file to open it (All 5 at the same time)
They could edit using the form and launch the report to see all current changes.

After the upgrade we are now limited to only 1 user in the database at a time.

I have been glancing through the boards and I keep seeing this front
end/backend set up which is just far too much for the simple database sharing we are currently doing.

What is the quick solution or is there a way to unlock the MDB file so it behaves the same as the 97 version?

Thanks so much for all your help.

Doc


Nov 13 '05 #2
Have you looked at TOOL | SECURITY to see if anything's amiss there?
As for frontend/backend, there are lot's of reasons to split your
database. One the strongest reasons is the environment you're
describing, which really isn't "simple database sharing." When you have
several people accessing a db at once across a network, you truly
should have the db split.

Splitting is not a difficult thing to do nor maintain.
Donald Watson wrote:
We recently upgrade form Office 97 to Office XP.

Under 97 we had about 15 small databases for various departments that shared data.

In this example I'll use our Disconnect Database.

We have the DISCONNECT.MDB file on the network.
Each user would double click on the MDB file to open it (All 5 at the same time)
They could edit using the form and launch the report to see all current changes.

After the upgrade we are now limited to only 1 user in the database at a time.

I have been glancing through the boards and I keep seeing this front
end/backend set up which is just far too much for the simple database sharing we are currently doing.

What is the quick solution or is there a way to unlock the MDB file so it behaves the same as the 97 version?

Thanks so much for all your help.

Doc


Nov 13 '05 #3
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'm suprised you didn't have any data corruption when using your present
set up w/ Access 97.

When multiple users are accessing the same data you have to use the
front-end/back-end set up. Split the front-end (queries, forms,
reports, modules) from the back-end (tables) using the Tools > Database
Utilities > Database Splitter option. Place the resulting front-end on
each user's PC. For each user's front-end relink the tables (Tools >
Database Utilities > Link Table Manager) so each user's front-end links
to the common back-end.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQlWD3YechKqOuFEgEQJLrACfZKY6kXu3qZAg+1Es1oemLK IQ4eMAn0vT
CALwKoQnXHuBbWeQx9toXI6w
=lcuU
-----END PGP SIGNATURE-----
Donald Watson wrote:
We recently upgrade form Office 97 to Office XP.

Under 97 we had about 15 small databases for various departments that shared
data.

In this example I'll use our Disconnect Database.

We have the DISCONNECT.MDB file on the network.
Each user would double click on the MDB file to open it (All 5 at the same
time)
They could edit using the form and launch the report to see all current
changes.

After the upgrade we are now limited to only 1 user in the database at a
time.

I have been glancing through the boards and I keep seeing this front
end/backend set up which is just far too much for the simple database
sharing we are currently doing.

What is the quick solution or is there a way to unlock the MDB file so it
behaves the same as the 97 version?

Nov 13 '05 #4
Donald, in general, you only need to link the tables once. And so,
MGFoster's method is perfect. However, sometimes you have need to
relink more often. In that case, use the following code and put the
relinking on a menu:

http://www.mvps.org/access/tables/tbl0009.htm

Don't forget the dependency:

http://www.mvps.org/access/api/api0001.htm

Just put them both into modules (I like putting them into separate
modules), create a button that calls the relinking routine
(fRefreshLinks) and fire away. It seemlessly relinks, even giving you
the ability to specify a different directory if you need.

Nov 13 '05 #5
One question. Using the Front End/ Back end version. Wont my users need to
export modified reports or forms back and forth to all 5 copies of the front
end for them to be accessible by everyone?

We have 5 users on this particular database and any of them may be making
changes or adding queries, reports or forms to the database.

Thanks

<jc*************@yahoo.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...
Donald, in general, you only need to link the tables once. And so,
MGFoster's method is perfect. However, sometimes you have need to
relink more often. In that case, use the following code and put the
relinking on a menu:

http://www.mvps.org/access/tables/tbl0009.htm

Don't forget the dependency:

http://www.mvps.org/access/api/api0001.htm

Just put them both into modules (I like putting them into separate
modules), create a button that calls the relinking routine
(fRefreshLinks) and fire away. It seemlessly relinks, even giving you
the ability to specify a different directory if you need.

Nov 13 '05 #6
It sounds like you have a development environment. So, yes, if you have
multiple people making changes to the frontend, you'll need to come up
with a distribution strategy. Most developers in such an environment
use a "check out" system whereby the code is literally checked out then
checked back in when finished, making it available for check out by
someone else.

I'm not aware of any MS Access-related check out software (doesn't mean
it doesn't exist) but perhaps others in the ng know of something.

Nov 13 '05 #7
"Donald Watson" <RE**********************@linncountyrec.com> wrote
in news:2q**************@news.uswest.net:
One question. Using the Front End/ Back end version. Wont my
users need to export modified reports or forms back and forth to
all 5 copies of the front end for them to be accessible by
everyone?

We have 5 users on this particular database and any of them may be
making changes or adding queries, reports or forms to the
database.


Well, wake up and smell the coffee: with Access 2000, Microsoft
changed the way code is stored in an Access MDB, and two users
*can't* edit the code/objects at the same time. There is no getting
around that under any circumstances.

MS's reason for this was that it prevents corruption, but it's a
kind of corruption I never ever saw in any of my clients' MDBs.

Also, because it converts your Access project into a single record
in a Jet data table (that's why only one user can edit it at a
time), you can't save incremental changes -- any SAVE of anything
has to save the whole record. This is not nearly as slow as it was
in the initial release of A2K, but it is still slower than A97 (and
annoying, because of the multi-save dialog, which drives me crazy).

Your only answer for this is to have front ends for each user and
some method for saving their new reports to a reference copy of the
front end, then a method for pushing those changes out to the end
users.

I suspect, though, that most of these saved reports are highly
redundant, for instance, being the same report layout, but using a
filtered recordsource. This can be handled by a little programming
to allow an end user to choose their recordsource, either by
filtering or picking from a list of queries.

Your current setup is now completely unworkable.

It was previously working only by pure luck.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #8

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

Similar topics

11
by: Mike MacSween | last post by:
My client has an MS Access database application on her local machine. I have full access to that in terms of changing the design. I've got a simple PHP/MySql application on shared hosting, so no...
96
by: BadPony | last post by:
Anyone using Peoplesoft on a Federated UDB (shared nothing)Environment on Open System Platforms? Preferably AIX, but any war stories would be good. TEA EB-C
6
by: Mike Wiseley | last post by:
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...
1
by: intl04 | last post by:
Are there any problems with multiple user access to the same Access database on a shared network drive? I have 'shared' chosen for 'default open mode'. As for the record locking properties, I...
2
by: jfathman | last post by:
Hello, We are considering a project that requires implementing a database (Windows PC based) that would be shared by a small number of users. The database would store events output by our...
3
by: Frank | last post by:
We have an Access database Sch_S.mdb in the shared driver S across the network. I have a copy of that database in my local driver C, named as Sch_C.mdb. As per users' request I added some check...
10
by: Daniel Fernandes | last post by:
Hi there Let's say due to several reasons I have an ASP.Net application that has a database access class that stores a database connection in a shared member : public class dataaccess ...
13
by: Elton Cohen | last post by:
Hi newsgroup! Can anyone tell me where I should put a simple Access database file in order to be accessible for every computer in the network (same workgroup)? There does not need to be any...
2
by: Random | last post by:
Here's a design question I'm curious to know if anyone here has wrestled with before... I'm writing my data access methods in classes in the App_Code directory. I know that I can easily...
3
by: theProfessor | last post by:
We are using a shared split database with all users currently using Access 2003. The back end is on a shared drive of a state wide WAN. Each user has a copy of the front end on their local...
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: 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...
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: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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.