473,324 Members | 2,567 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.

off-topic: are there any better file-server DBs than Access?

VMI
I'm storing mailing address data into an Access table and there are some
queries that are taking too long even when run in Access (ie. "select top 20
* from audit where Line > 0 order by Line asc"). This mostly happens when
the table has 300k+ records (a few may even have up to a million). The
reason we didn't use SQL server or Oracle (besides price, which is a major
factor - using an MDB is free) is that many of our clients have several
users (over 20 users) and each one has an entirely different list of mailing
addresses (our application used to store the data in txt format so we
replaced it with an mdb-most still think it's a txt file because we name the
mdb so it has the same extension it had before). Also, I can't guarantee
that all PCs will be connected to a network, so we would have to assume that
all PCs will need some server DB installed.
Anybody have any suggestions as to what we can do to replace Access?

Thanks.
Nov 16 '05 #1
6 1192
First, MSDE is free.

Second, have you created an index on the Line field?

S. L.

"VMI" <vo******@yahoo.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
I'm storing mailing address data into an Access table and there are some
queries that are taking too long even when run in Access (ie. "select top
20 * from audit where Line > 0 order by Line asc"). This mostly happens
when the table has 300k+ records (a few may even have up to a million).
The reason we didn't use SQL server or Oracle (besides price, which is a
major factor - using an MDB is free) is that many of our clients have
several users (over 20 users) and each one has an entirely different list
of mailing addresses (our application used to store the data in txt format
so we replaced it with an mdb-most still think it's a txt file because we
name the mdb so it has the same extension it had before). Also, I can't
guarantee that all PCs will be connected to a network, so we would have to
assume that all PCs will need some server DB installed.
Anybody have any suggestions as to what we can do to replace Access?

Thanks.

Nov 16 '05 #2
VMI wrote:
I'm storing mailing address data into an Access table and there are some
queries that are taking too long even when run in Access (ie. "select top 20
* from audit where Line > 0 order by Line asc"). This mostly happens when
the table has 300k+ records (a few may even have up to a million). The
reason we didn't use SQL server or Oracle (besides price, which is a major
factor - using an MDB is free) is that many of our clients have several
users (over 20 users) and each one has an entirely different list of mailing
addresses (our application used to store the data in txt format so we
replaced it with an mdb-most still think it's a txt file because we name the
mdb so it has the same extension it had before). Also, I can't guarantee
that all PCs will be connected to a network, so we would have to assume that
all PCs will need some server DB installed.
Anybody have any suggestions as to what we can do to replace Access?

Thanks.


Well, i don't think there are any other file-server databases left out
there, as it's a way too outdated technology, i think.

You put some concerns why you don't use "real" client server databases,
so here's what i can tell you:

1. Price - look at MySQL database, which is well known in Europe,
modern, comparably fast, actively developed and supported and FREE
database engine.
www.mysql.com

2. There is an embedded version of MySQL which you can include into your
program, making it a client-server in one
Hope it helps
Andrey
Nov 16 '05 #3
You can look at MSDE, it's a free alternative to MS Access.
Check out this link for more info on MSDE:

http://www.microsoft.com/sql/msde/default.asp

VMI wrote:
I'm storing mailing address data into an Access table and there are some
queries that are taking too long even when run in Access (ie. "select top 20
* from audit where Line > 0 order by Line asc"). This mostly happens when
the table has 300k+ records (a few may even have up to a million). The
reason we didn't use SQL server or Oracle (besides price, which is a major
factor - using an MDB is free) is that many of our clients have several
users (over 20 users) and each one has an entirely different list of mailing
addresses (our application used to store the data in txt format so we
replaced it with an mdb-most still think it's a txt file because we name the
mdb so it has the same extension it had before). Also, I can't guarantee
that all PCs will be connected to a network, so we would have to assume that
all PCs will need some server DB installed.
Anybody have any suggestions as to what we can do to replace Access?

Thanks.

Nov 16 '05 #4
VMI
Would I need to install MSDE on every PC? Can I automatically install it?
The problem is my application automatically creates the mdb file and the
tables. Would I have to add the MSDE isntallation to my program installation
wizard?

thanks.

"Ed_P." <ep*******@sbcglobal.net> wrote in message
news:OZ**************@TK2MSFTNGP11.phx.gbl...
You can look at MSDE, it's a free alternative to MS Access.
Check out this link for more info on MSDE:

http://www.microsoft.com/sql/msde/default.asp

VMI wrote:
I'm storing mailing address data into an Access table and there are some
queries that are taking too long even when run in Access (ie. "select top
20 * from audit where Line > 0 order by Line asc"). This mostly happens
when the table has 300k+ records (a few may even have up to a million).
The reason we didn't use SQL server or Oracle (besides price, which is a
major factor - using an MDB is free) is that many of our clients have
several users (over 20 users) and each one has an entirely different list
of mailing addresses (our application used to store the data in txt
format so we replaced it with an mdb-most still think it's a txt file
because we name the mdb so it has the same extension it had before).
Also, I can't guarantee that all PCs will be connected to a network, so
we would have to assume that all PCs will need some server DB installed.
Anybody have any suggestions as to what we can do to replace Access?

Thanks.

Nov 16 '05 #5
MySQL is not free for commercial apps and I don't think that would work well
in your situation anyways. The MSDE would need to installed on every
computer and you would need the free redistribution license. Another option
that I really like is firebird. It seems to be really fast and reliable.
Nov 16 '05 #6

You might want to look at my design for a Xml based webservice that can
store and search simple table data in an Xml file:

http://www.c-sharpcorner.com/Code/20...DatabaseWS.asp

VMI wrote:
I'm storing mailing address data into an Access table and there are some
queries that are taking too long even when run in Access (ie. "select top 20
* from audit where Line > 0 order by Line asc"). This mostly happens when
the table has 300k+ records (a few may even have up to a million). The
reason we didn't use SQL server or Oracle (besides price, which is a major
factor - using an MDB is free) is that many of our clients have several
users (over 20 users) and each one has an entirely different list of mailing
addresses (our application used to store the data in txt format so we
replaced it with an mdb-most still think it's a txt file because we name the
mdb so it has the same extension it had before). Also, I can't guarantee
that all PCs will be connected to a network, so we would have to assume that
all PCs will need some server DB installed.
Anybody have any suggestions as to what we can do to replace Access?

Thanks.

Nov 16 '05 #7

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

Similar topics

4
by: Frank | last post by:
Whats best : register_globals ON ? OR register_globals OFF ? I currently use: $_POST
3
by: EN | last post by:
Hi, I want to put a bmp of a toggle switch leaning to the left, the off position. With a painter prgm, flip the left toggle , lean right, for ON or Start position. How do I do this? With VB 6 ,...
0
by: Carlos Natal | last post by:
Hi all, While creating a windows service using .NET and C# I had to call myForm.ShowDialog() from within a thread I have created inside the OnStart() method. When this window is closed, my...
1
by: kishor kotecha | last post by:
Hi, I have created a .net app. all works fine. but, i want to prevent closure (kill) of this app when the user of the machine does a 'log off' of windows/xp. currently what is happening...
1
by: Greggory | last post by:
Hi all, when a client at my "C#/asp.net - page" has its javascript turned off, I want to redirect him to another page. This must be done by a javascript. Can I somehow autopost a page to...
1
by: Gaffer | last post by:
Is it possible to change the following code so that the music is 'off' when the page is loaded and the user gets the option to turn it on? ---------------------------------------------------...
6
by: Frank Rizzo | last post by:
I have the following situation: 1. Application X1 runs under a regular user account (this user is also the currently logged on user). 2. Application X1 kicks off Application X2 using an...
8
by: Rory Becker | last post by:
A wise man once said: "Never put off until runtime what you can fix at compile time." Actually I think he said it about 10 minutes before I started this post. I am a firm believer, like the...
1
by: scooby dooby | last post by:
Hi All, I need to write a script which has the requirements as below. 1,It should log out the particuler user from windows at a particuler time ,say 6 o'clock in the evening everyday,At the same...
6
by: Rain | last post by:
Hi, I noticed the other day when I was trying to optimise the traffic on a particular web page that it had significant viewstate even though I had turned it off for most of the controls. So in...
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...
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
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
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.