Re: Access 2k upgrade to Access 2003 or SQL Server Express?

"RayPower" <raypower33@xxxxxxxxxxxx> wrote

I'm having a system using Access 2000 as both front-end (queries,
forms, reports & temp tables for reports) & back-end (data) with
back-end running on the server. The application runs on the network
with around 15 users.

The back-end database is suffering from performance issues. There were
several corruptions since few months & one major corruption & corrupted
the MSysObjects table. Also, the system will run batch process that
generate hundreds to thousands of records in the transaction table,
which caused the transaction table being locked even though users just
trying to add new transactions even though the database has been
selected to use record-level locking. Furthermore, some queries are
very slow as they query the transaction table which has over 1.3
million records.

I'd suggest you do some searching at Tony Toews' webstite,
http://www.granite.ab.ca/accsmstr.htm -- he has the best collection of
information and links on avoiding corruption and improving performance that
I know of, for an Access mutliuser environment. A couple of more sites with
good information are Jeff Conrad's "Access Junkie" site... look for posts by
him in this newsgroup and the microsoft.public.access... newsgroups, and
Albert Kallal's site... again look for posts by Albert -- I think he carries
the site address in his SIG line.

Larry Linson
Microsoft Access MVP

The company has just been covered by the corporate license (as a
company of the group) to update all PCs to Office 2003. Is upgrading to
Access 2003 help to get the system more stable/reliable? Is Access 2003
not so easy to corrupt? Can we get true record-locking or still
suffering from locking pages or even the whole table when adding
hundreds of records?

Well, I feel more comfortable with Access 2002 or Access 2003, with all the
Service Packs and updates, than I do with Access 2000, with all its Service
Packs and updates. I've discovered quite a number of people who have
problems but have not got their IT department to apply the SPs and updates.


As upgrading to SQL Server is not an option at the moment (due to the
budget), I'm also looking to the SQL Server Express which is free. But
how hard is it to upgrade to SQL Server Express? There are lots of
codes using DAO recordset in the application, do I need to change all
to ADO? Is the front-end still in .MDB (database) or change to .ADP
(Access project)?

Thanks,
Ray



.

Relevant Pages

  • Re: Can only send brief messages
    ... If you strictly adhere to all of the Caveats I've posted, you should NOT encounter corruption. ... Do not cancel Automatic Compacting, should it occur, ... select the sonic.net email account then click properties. ... A time-out occurred while communicating with the server. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Need ideas for managing large table...
    ... What kind of server is running your SQL-Server back-end? ... I'm not sure why an Access front-end for reporting purposes ... > queries to get the results I need. ...
    (microsoft.public.access.tablesdbdesign)
  • Reproducible data corruption on 6.1-Stable
    ... I set up a new server recently and transferred all the information from ... disk I start seeing the corruption. ... pci0: <ACPI PCI bus> on pcib0 ...
    (freebsd-stable)
  • Re: Pros and Cons of SQL v/s MDB
    ... do you know of a backup system that can be ... >that can have over 100 users on the same back-end. ... >Now, up-sizing to SQL server is often, bu not always the ... >>After the last corruption, which was recovered by ...
    (microsoft.public.access.adp.sqlserver)
  • Re: auditing activesync logon events
    ... A front-end server keeps an HTTP session connected to it and proxies the ... the appropriate back-end server for the mailbox. ... the Internet so that Internet clients don't need to contact the back-end ...
    (microsoft.public.exchange.admin)