473,854 Members | 1,508 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Best alternative to MS Access on a shared drive

Hi All;

I work for a company which is currently utlizing MS Access on a shared drive
where people from all over the country access. Because all are wishing to
view a single database maintained solely by us (in Florida), each region
cannot have their own individual database on their local servers (otherwise
we would have to update several databases as opposed to one central database).
We have tried splitting the database, but it is still too slow. We are now
considering a web-based application. What would be the best alternative for
us? What they are looking for is an application we can access on the company
intranet. Any suggestions appreciated.

Thanks In Advance. :)

--
Message posted via http://www.accessmonster.com
Jan 19 '06 #1
13 4238
You could write an entire ASP.NET (or any other language) front-end for
your database system, but if you want a quick 'n' dirty, you can try
Data Access Pages.

I work with school districts. When I run into a situation like yours, I
put the backend on the server and place a shortcut to a batch file on
each user's PC. The batch file copies a front-end down to the user's
computer. The user can make changes to data on the backend, and if
there's an update all that has to be changed is the front-end on the
server.

Jan 19 '06 #2
Per Pamela via AccessMonster.c om:
I work for a company which is currently utlizing MS Access on a shared drive
where people from all over the country access. Because all are wishing to
view a single database maintained solely by us (in Florida), each region
cannot have their own individual database on their local servers (otherwise
we would have to update several databases as opposed to one central database).
We have tried splitting the database, but it is still too slow. We are now
considering a web-based application. What would be the best alternative for
us? What they are looking for is an application we can access on the company
intranet. Any suggestions appreciated.


Distinguish between back and front ends. Back end being the tables that those
people are going after.

Sounds to me like a classic case for moving the tables to SQL Server.
--
PeteCresswell
Jan 20 '06 #3
I explain some possible solutions here..and some involve keeping ms-access
as is

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com
http://www.members.shaw.ca/AlbertKallal
Jan 20 '06 #4
CL
Hi Pamela,

I have been faced with a similar problem. The solution I implemented
was to keep the original database on the server and install/setup
Microsoft Terminal Server. The overall cost was cheaper than re-writing
the database front end as a set of web pages and upsizing access to SQL
Server. Be aware that Access is not the fastest/reliable database when
used on a web server IE you need to upsize.

Good luck,
Craig L
www.directory-base.com

Jan 20 '06 #5
"(PeteCresswell )" <x@y.Invalid> wrote in
news:07******** *************** *********@4ax.c om:
Per Pamela via AccessMonster.c om:
I work for a company which is currently utlizing MS Access on a
shared drive where people from all over the country access.
Because all are wishing to view a single database maintained
solely by us (in Florida), each region cannot have their own
individual database on their local servers (otherwise we would
have to update several databases as opposed to one central
database). We have tried splitting the database, but it is still
too slow. We are now considering a web-based application. What
would be the best alternative for us? What they are looking for
is an application we can access on the company intranet. Any
suggestions appreciated.


Distinguish between back and front ends. Back end being the
tables that those people are going after.

Sounds to me like a classic case for moving the tables to SQL
Server.


Sounds to me like a classic case of needing Terminal Server.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Jan 20 '06 #6
"Pamela via AccessMonster.c om" <u11418@uwe> wrote in
news:5a9a6a1a7b 038@uwe:
I work for a company which is currently utlizing MS Access on a
shared drive where people from all over the country access.
Because all are wishing to view a single database maintained
solely by us (in Florida), each region cannot have their own
individual database on their local servers (otherwise we would
have to update several databases as opposed to one central
database). We have tried splitting the database, but it is still
too slow. We are now considering a web-based application. What
would be the best alternative for us? What they are looking for
is an application we can access on the company intranet. Any
suggestions appreciated.


Windows Terminal Server. Period. End of Statement.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Jan 20 '06 #7
Per David W. Fenton:
Sounds to me like a classic case of needing Terminal Server.


I jumped to the (unwarranted upon re-reading the OP) conclusion that the app was
getting hit by a large number of concurrent users.
--
PeteCresswell
Jan 20 '06 #8
Wow! Thanks for all the replies! The database is a fairly simple one (not
much behind the scenes programming) & is hit by a fair number of users. I
would say ~20, but that's just a guess, may be more. Managers as well as
recruiters will be using it. I'm not sure who I can convinve to try these
alternative methods, but I'll give it a go. It is a needed database & the
slowness is an issue of growing concern, especially in California where they
are trying to use the database which is housed on a server in Florida over
the network.

David W. Fenton wrote:
I work for a company which is currently utlizing MS Access on a
shared drive where people from all over the country access.

[quoted text clipped - 7 lines]
is an application we can access on the company intranet. Any
suggestions appreciated.


Windows Terminal Server. Period. End of Statement.


--
Message posted via http://www.accessmonster.com
Jan 20 '06 #9
Speed issues can greatly be reduced by eliminating linked tables and using
all ADO/DAO calls. 20 users is not many. As long as the network is fast
enough, speed should not be an issue - it will never be SQL Server, but it
should be "fast enough". But if the network is anything less than 100%
reliable, you *will* get occasional corruption and downtime while you
manually repair what a server database does automatically.

--
Darryl Kerkeslager
Jan 21 '06 #10

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

Similar topics

3
6446
by: MLH | last post by:
I'm developing an app that I'd like to backup each time I open it for modifications. Is it too late to do so after opening the file with Access? Here's what I've been trying... Trevor Best posted this code in 1995... On frmMainMenu, I have a Fn that I launch with a button. Here is the function: Sub CopySingleFile (szSrc As String, szTgt As String)
1
4377
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 selected 'edited record' for default record locking; also, 'Open databases using record-level locking' is checked. We seemed to experience difficulties in this office - just once so far, I think - with more than one user accessing the database on a...
0
1276
by: MikeL | last post by:
I am using Access 2K and have created a simple data access page which only works properly when it is run from the local C drive. The data file that is being accessed is held on a shared network drive, and the data access page works for anyone on our domain, but only if the htm file is run from the local c drive. If I attempt to run it from either a network shared drive or from our intranet server, the page loads and displays static data...
5
3701
by: premmehrotra | last post by:
I currently have a multi-user access database which is put on a shared drive L: on a Windows Servers. Entire database is one file premdb.mdb. Users access this database from their laptops. Following problems occur: 1. Access is way too slow in WAN environment. Server is located in New Jersey and users are in California and Puerto Rico. 2. Database often becomes corrupt 3. When one user updates some data in the database, other users...
2
1007
by: dbui | last post by:
I have an ASP.NET application running on one win2k server and it needs to access a shared folder in other server. To access this shared folder, I have to login with user name and password. I used IWshRuntimeLibrary.WshNetwork() and mapped the folder to a network drive (Y:\) in the page_load. Then I disconnected this drive in the page_unload. I got it works but not stable. Sometimes it fails to disconnect and to map. thanks
12
3106
by: Ron Weldy | last post by:
I have a test server runinng 2003/IIS 6 with a mixture of asp and asp.net files. On my workstation I have a share set up to the folder where the web files reside. I am just doing quick and dirty asp editing (like I used to be able to do with 2K/IIS5) where I use VS.NET, open an asp file, make changes, save and refresh my browser. Problem is that I get an Access is Denied error when I try to save the file and then the file gets wiped on...
3
6820
by: KSC | last post by:
Hello, Is there a way to programmatically determine if a directory is shared and if so, what the sharename is? It seems a simple question, but I have been searching and not found the answer... Thanks in advance!
0
2115
by: =?Utf-8?B?SmltSGVhdmV5?= | last post by:
I developed some web pages and stored those pages on a "removable drive". All was right with the world. I then took the "removable drive" and moved it to another machine but mapped that drive with the same drive letter on the "home machine". Now when I bring up those web pages within VS 2005, I get this error which refers me to KB article 810886 which tells me that I need to increase the values for "MaxCmds" & "MaxMpxCt". I increased...
8
2231
by: John Google | last post by:
Hi, I've been asked to amend an Access 2002 DB that has been used by users using the MDE version. I have, what seems to be the original MDB version containing all the front end stuff but, by now, the tables are way out of date. They want me to make some changes to the database and keep their current data..
0
9901
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9751
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,...
0
11025
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10682
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10758
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,...
0
9513
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
7082
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();...
2
4159
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3187
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.