MS Access and Internet - ASP pages and linked Access tables

Author

ASP pages and linked Access tables

Marc

2005-04-09, 8:27 pm

Hello,

I've been searching for an answer to this for a while. I inherited the
maintenance of our company intranet site and am learning on the fly. The
previous guy had several small Access databases that were used for different
asp pages. Many of the databases have the same tables in them, but are kept
separately, not linked to one main database.
Is there a reason for this? Can I run an intranet site and asp pages from
databases that have linked tables? Does it cause problems or hurt speed or
performance?

Thanks,

Marc
--
Marc

Sylvain Lafontaine

2005-04-09, 8:27 pm

If these databases are small in size, less than 1Gig, than it's possible
that this is only the effect of a weak design and nothing else. However,
other considerations may have creep in.

Secondo, the simple fact of using Access, even with a single central
database, will hurt speed and performance but usually this is not of concern
for an intranet site with a light to medium workload; especially if the
security and/or the reliability is not of premium importance.

S. L.

"Marc" <Marc@discussions.microsoft.com> wrote in message
news:171F73D3-3758-4E58-B94A- F0E891404579@microso
ft.com...
> Hello,
>
> I've been searching for an answer to this for a while. I inherited the
> maintenance of our company intranet site and am learning on the fly. The
> previous guy had several small Access databases that were used for
> different
> asp pages. Many of the databases have the same tables in them, but are
> kept
> separately, not linked to one main database.
> Is there a reason for this? Can I run an intranet site and asp pages from
> databases that have linked tables? Does it cause problems or hurt speed or
> performance?
>
> Thanks,
>
> Marc
> --
> Marc

Marc

2005-04-09, 8:27 pm

Thanks Sylvain,

The databases are all quite a bit smaller than 1Gig - most in the 5 - 10 meg
range. It looks like I should try to use linked tables.

I'm very curious, what should I be using instead of Access?

Thanks again,

Marc

"Sylvain Lafontaine" wrote:

> If these databases are small in size, less than 1Gig, than it's possible
> that this is only the effect of a weak design and nothing else. However,
> other considerations may have creep in.
>
> Secondo, the simple fact of using Access, even with a single central
> database, will hurt speed and performance but usually this is not of concern
> for an intranet site with a light to medium workload; especially if the
> security and/or the reliability is not of premium importance.
>
> S. L.
>
> "Marc" <Marc@discussions.microsoft.com> wrote in message
> news:171F73D3-3758-4E58-B94A- F0E891404579@microso
ft.com...
>
>
>

Sylvain Lafontaine

2005-04-09, 8:27 pm

SQL-Server or it's free counterpart, MSDE.

However, I'm not suggesting that you should replace Access. If it fills the
bill and that all your needs are covered, then there is no need to change;
as having the best thing is not always what's required for everyone.

S. L.

"Marc" <Marc@discussions.microsoft.com> wrote in message
news:E5DB7719-7C30-40C1-9901- F78C00F9A84D@microso
ft.com...[color=darkred]
> Thanks Sylvain,
>
> The databases are all quite a bit smaller than 1Gig - most in the 5 - 10
> meg
> range. It looks like I should try to use linked tables.
>
> I'm very curious, what should I be using instead of Access?
>
> Thanks again,
>
> Marc
>
> "Sylvain Lafontaine" wrote:
>

Marc

2005-04-11, 9:24 am

Thanks again,

Marc

"Sylvain Lafontaine" wrote:

> SQL-Server or it's free counterpart, MSDE.
>
> However, I'm not suggesting that you should replace Access. If it fills the
> bill and that all your needs are covered, then there is no need to change;
> as having the best thing is not always what's required for everyone.
>
> S. L.
>
> "Marc" <Marc@discussions.microsoft.com> wrote in message
> news:E5DB7719-7C30-40C1-9901- F78C00F9A84D@microso
ft.com...
>
>
>

Sponsored Links