Sequel Server

[Susie Ngamsuwan]

Can anyone explain the difference between running an Access 2002 database on
a normal WinXP platform or on a Sequel Server?

We have an Access database 2GB in size and are not sure whether we should be
looking into a different database all together or start searching for a MS
Access db developer to work on ours. The thing is growing constantly due to
a lot of pictures we need integrated, but also needs modifying.

Any suggestions?

Susie Ngamsuwan
Thailand

 

[Lynn Trapp]

Susie,
That's kind of like comparing apples to oranges. Win XP is an operating
system while SQL Server is a database management system. You can run an
Access database on Win XP AND use SQL Server as the backend for the database
all at the same time.

The first thing to do is change the way you are handling your images. Your
database will always bloat if you store the images in the database file.
Instead, store the pictures on your file server and simply store the path to
them in your database. You need to do this quickly because, at 2G, you have
already reached the limit of an Access database

 

[Susie Ngamsuwan]

Sorry, not sure you got my previous mail...

Hi Lynn,
Thanks for answer.

I agree - pictures need to get out.

SL Server. I understand that SL Sever is a software program that can be
installed onto WinXP. Am not sure about its functions though. Would it
facilitate/speedup our access db, which is a 2-file db with one being the
backend (tables).

Regards
Susie

--
Dear

Thank you very much for your inquiry concerning our Swarovski crystal
products.

We at A.C.D. Thailand Co., Ltd. manufacture and design our own products
using original verified Swarovski crystals. With the free-setting technique
that we developed, we are the worldwide leader in the crystal setting field.
Please visit our website at www.acdthailand.com for more information,
including pictures and descriptions of our products.

Should you be interested in acquiring a single item for private purchase, we
ask you kindly to contact one of our many local retail partners.

If you are interested in becoming one of our retail partners, please press
the 'reply' button to this message, fill in the questionnaire and
registration form below, and click 'send'.


Best regards

Josef Aigner
Managing Director



Questionnaire and registration form

1. Personal information:
Title:
(Mr./Mrs./Miss/other)

First name:

Last name:

Nationality:

Company name:

Position:

Business address:

Country:

Tel:

Fax:

E-mail:

Internet address (URL):


2. What is the nature of your business:
Import:

Wholesale:

Agent/Distributor:

Retail:

Department store:

Manufacturing:


3. Indicate the product(s) that you are interested in distributing.
Silver Jewelry:

Fashion Jewelry:

Gift Items:

Souvenirs:

Art Gallery Products:

Made-to-Order Products:

Masterpieces:

Merchandise Products:

Home Décor Items:


4. How did you learn about us?
Newspaper/Magazine:

Internet:

Saw our products:

Recommended by:


5. In what city/country or region would you be able to distribute our
products?


Thank you in advance for your cooperation!

 

[John Vinson]

SL Server. I understand that SL Sever is a software program that can be
installed onto WinXP. Am not sure about its functions though. Would it
facilitate/speedup our access db, which is a 2-file db with one being the
backend (tables).

It's SQL Server (not SL)... and, though it would solve this problem,
it is not necessary and would be a much too expensive solution (both
in cost and in time spent developing).

It is NOT necessary to go to SQL server to solve your problem. Access
is perfectly capable of doing this.

What you need to do is change the way you are storing your images. See
the links at

http://www.mvps.org/access/forms/frm0030.htm


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps