problem with large databases

[Danny]

I am processing a database of several thousands of products, can even reach
500,000 or more.
This brings my pc to a halt (windows xp running 2.4 gig, with 100 g HD).
The database becomes unstable as well and updates cause an error "invalid
command" or something like that as I remember up on the update command.

I am running access 2002.

What are my options?

what is ms sql server database? Somebody mentioned that to me.

Thanks

[Bernard Peek]

In message <IN*********************@news4.srv.hcvlny.cv.net >, Danny
<da********@hotmail.com> writes

I am processing a database of several thousands of products, can even reach
500,000 or more.
This brings my pc to a halt (windows xp running 2.4 gig, with 100 g HD).
The database becomes unstable as well and updates cause an error "invalid
command" or something like that as I remember up on the update command.

I am running access 2002.

What are my options?

what is ms sql server database? Somebody mentioned that to me.

SQL Server is Microsoft's other database product. It is designed for
large database systems such as yours.

There is a trial version.

http://www.microsoft.com/sql/evaluat...al/default.asp

Ideally you would run the SQL Server database system on one machine and
your Access front-end on another.
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

[Danny]

Thank you for that.

I will try this out.
But do you know if you can distribute mde's using this database format?
I don't have the runtime, I just send out mdb and mde.

Thanks

"Bernard Peek" <ba*@shrdlu.com> wrote in message
news:D+**************@shrdlu.com...

In message <IN*********************@news4.srv.hcvlny.cv.net >, Danny
<da********@hotmail.com> writes

I am processing a database of several thousands of products, can even reach500,000 or more.
This brings my pc to a halt (windows xp running 2.4 gig, with 100 g HD).
The database becomes unstable as well and updates cause an error "invalid
command" or something like that as I remember up on the update command.

I am running access 2002.

What are my options?

what is ms sql server database? Somebody mentioned that to me.

SQL Server is Microsoft's other database product. It is designed for
large database systems such as yours.

There is a trial version.

http://www.microsoft.com/sql/evaluat...al/default.asp

Ideally you would run the SQL Server database system on one machine and
your Access front-end on another.
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

[Bernard Peek]

In message <ou*********************@news4.srv.hcvlny.cv.net >, Danny
<da********@hotmail.com> writes

Thank you for that.

I will try this out.
But do you know if you can distribute mde's using this database format?
I don't have the runtime, I just send out mdb and mde.

No. Users will need to have SQL Server licenses which are not cheap.
Alternatively you can run SQL Server on an Internet connected server and
have the users connect to it. Expect to pay something in the region of
$50,000 for that.

You really need to get professional advice about this, there is a limit
to what can be done in newsgroup postings.

Alternatively look very closely at your Access databases and try to find
ways to improve it.

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

[Thilo Immel]

Hi Danny,

I am processing a database of several thousands of products, can even reach
500,000 or more.
No problem.
This brings my pc to a halt (windows xp running 2.4 gig, with 100 g HD).
What exactly brings your PC to halt? Is there a special, very complex
query? To open the table which holds the 500000 records should not
make your computer crashing.

Have you split it into frontend and backend database?
The database becomes unstable as well and updates cause an error "invalid
command" or something like that as I remember up on the update command.
Resides the database at the local disk or at a network server?

To have the exact error message would be nice.
I am running access 2002.

What are my options?

what is ms sql server database? Somebody mentioned that to me.

Thanks

Regards

Thilo Immel

Access Repair Service www.atroplan.com
Access Memory Reporter www.atroplan.com/AccMemReporter.htm

[Tony Toews]

"Danny" <da********@hotmail.com> wrote:

I will try this out.
But do you know if you can distribute mde's using this database format?
I don't have the runtime, I just send out mdb and mde.

You can as there is the MSDE which is a cut down version of SQL Server. However this
requires it's own installation routine on a PC on the network. And you can ship the
SQL Server database file and have it programmatically restored to the system. A bit
more work but doable.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm