My dbase resides on our network drive and I've got users in different
locations throughout the state (but only 5 users outside of my office). The
performance of this dbase is very slow. I did add some code to keep a
connection to an underlying table so it wouldn't need to reconnect to the
backend but it still is slow.

I'm not a programmer but I was wondering if the performance speed would
increase if I converted it to being web based. I'm sure there is more to it
than this but couldn't I use the upsizing wizard to convert it to SQL and use
it web based?

Just wondering if this is a difficult process or if it would be worth it.

--
Todd

yes

you would have much much much better performance by moving it to SQL
Server and then writing a simlpe interface with Dreamweaver


good luck; I hate MDB files; I dont' think that they're an acceptable
performance level for any user anywhere


On Mar 22, 1:24 pm, Todd <t...@discussions.microsoft.com> wrote:
> My dbase resides on our network drive and I've got users in different
> locations throughout the state (but only 5 users outside of my office). The
> performance of this dbase is very slow. I did add some code to keep a
> connection to an underlying table so it wouldn't need to reconnect to the
> backend but it still is slow.
>
> I'm not a programmer but I was wondering if the performance speed would
> increase if I converted it to being web based. I'm sure there is more to it
> than this but couldn't I use the upsizing wizard to convert it to SQL and use
> it web based?
>
> Just wondering if this is a difficult process or if it would be worth it.
>
> --
> Todd

"Todos Menos [MSFT]" <(E-Mail Removed)> wrote:

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

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

Check out what Albert Kallal has written about using Access on a WAN at the
following URL ...

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

--
Brendan Reynolds
Access MVP

"Todd" <(E-Mail Removed)> wrote in message
news:A2E5E826-751A-4A47-9BB0-(E-Mail Removed)...
> My dbase resides on our network drive and I've got users in different
> locations throughout the state (but only 5 users outside of my office).
> The
> performance of this dbase is very slow. I did add some code to keep a
> connection to an underlying table so it wouldn't need to reconnect to the
> backend but it still is slow.
>
> I'm not a programmer but I was wondering if the performance speed would
> increase if I converted it to being web based. I'm sure there is more to
> it
> than this but couldn't I use the upsizing wizard to convert it to SQL and
> use
> it web based?
>
> Just wondering if this is a difficult process or if it would be worth it.
>
> --
> Todd

Brendan

there is NOT a problme with access across a WAN.

the answer is called 'ADP'

I mean seriously here guys; it works like a charm





On Mar 23, 1:52 am, "Brendan Reynolds"
<brenr...@discussions.microsoft.com> wrote:
> Check out what Albert Kallal has written about using Access on a WAN at the
> following URL ...
>
> http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html
>
> --
> Brendan Reynolds
> Access MVP
>
> "Todd" <t...@discussions.microsoft.com> wrote in message
>
> news:A2E5E826-751A-4A47-9BB0-(E-Mail Removed)...
>
>
>
> > My dbase resides on our network drive and I've got users in different
> > locations throughout the state (but only 5 users outside of my office).
> > The
> > performance of this dbase is very slow. I did add some code to keep a
> > connection to an underlying table so it wouldn't need to reconnect to the
> > backend but it still is slow.
>
> > I'm not a programmer but I was wondering if the performance speed would
> > increase if I converted it to being web based. I'm sure there is more to
> > it
> > than this but couldn't I use the upsizing wizard to convert it to SQL and
> > use
> > it web based?
>
> > Just wondering if this is a difficult process or if it would be worth it.
>
> > --
> > Todd- Hide quoted text -
>
> - Show quoted text -