Re: The limits of Access?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Dom, I doubt there are definitive article dealing with where the limits are.

There are too many variables that keep changing, e.g. hardware (such as more
RAM and faster), network (10? 100? 1gb? collisions?), disks, Unicode
compression, and service packs. Versions are different. User-defined
functions executed in queries tend to be much slower now than they did 5
years ago. Access bugs. Securtity. Encryption. Developer skill. Optimization
techniques. Bottlenecks. There's just too many variables.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dominic Shaw" <DominicShaw@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CCD1EDC3-EF07-4402-BED7-B253BAFB18B9@xxxxxxxxxxxxxxxx
Hi Allen,

Thanks very much for the reply.

We expect it to carry on this way, and what I had left out is that they
have
comissioned and had written a new application using SQL Server and .NET to
replace it - but they "can't find the time to test and implement" it, so
instead they are still coming to us for fixes for the old database.

I was hoping that the response I got here would validate my reply to
them -
and it has.

We have, as you say, already split the database, and tried some of the
other
suggestions you give like optimistic locking. The other suggestions are
great
- if they choose to persist then I will definately give them a go!

Do you know of any articles which directly reference the limitations of
Access - i.e. how many records you can expect it to process, etc?

Thanks very much for the info :)

Dom


.

Relevant Pages

  • Re: PHP to dynamically generate XML
    ... In the first one you generate XML as a string and then get the DOM ... one php function queries a database table for a list of CD ...
    (comp.text.xml)
  • [Info-Ingres] Using roles with Vdba...
    ... that wants to access the raw data in the database using ... The database is private and roles are in place... ... I have created a vnode and can connect a DOM. ... If I run a dos window and run isql with the vnode and role id, then that works but is not adequate for this user... ...
    (comp.databases.ingres)
  • Re: No knowledge of the database?
    ... What if you have no database at all? ... You then have crappy crippled tools to work with. ... > DOM?? ... to puts taxonomies. ...
    (comp.object)
  • vcard link
    ... Does anyone know of an application or code, to create a on-the-fly vcard ... from a database, for an online member directory? ... Dom ...
    (microsoft.public.frontpage.programming)