Re: Running Split Access2000 db on Network

Thanks for the tips.

I turned off Name AutoCorrect options, and it really sped things up. It's
no big deal living without it, and it's probably better from a developer's
standpoint for tracking object name changes. I like to know what's changed
and try to reasearch that ahead of time anyway, and having it done
automatically makes us lazy.

I'll reset SubdatasheetName for ll tables to "None". Don't need "Auto", as
not using the subdatasheets anyway.

Bruce


"Br@dley" <n0mail@xxxxxx> wrote in message
news:TmhDe.53165$oJ.45014@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Bruce Acciavatti <vim@xxxxxxxxx> wrote:
>> I've split a rather large Access2000 database that resides on a
>> network drive, by keeping the back-end on the network drive and
>> placing the front-end on the client's hard drive, linked to it. Both
>> front-end and back-end dbs are then compacted to save space.
>>
>> This is a normal procedure, but when I run the database now it
>> performs much, much slower than the old unsplit version of the
>> database, which is unacceptable. I have had to back off this to the
>> unsplit version of the database, but it makes it difficult to install
>> changes to the application this way. I've never seen anything like
>> this before. There are only 5 clients. All clients have Windows
>> XP-Professional, and are running MS Office 2000.
>>
>> One other thing, is that I tried putting the front-end on one system
>> that is running MS Office 2003 (and Access2003), and it works
>> beautifully! Should I try to have Office2003 installed on all the
>> client machines, or is there something else going on?
>
> Is the AutoNameCorrect option turned off?
>
> Is SubdatasheetName set to "[None]" for all tables?
> --
> regards,
>
> Bradley
>
> A Christian Response
> http://www.pastornet.net.au/response
>


.

Relevant Pages

  • Re: Set up an LDAP address book server?
    ... Most mail clients these days are happy to operate as IMAP clients, and the better ones do a sufficiently good job of local caching that the off-line issue doesn't bite, either. ... The trouble is that LDAP seems to be used for a bunch of other things, like authentication databases, and so the documentation starts to use words like "schema" and I find it impenetrable. ... Also, openldap23-server won't install when openldap23-client is installed, and my system says that 64 installed packages depend on -client, so de-installing it doesn't seem to be an option. ... does anyone know of a good/simple recipe for setting up an LDAP address book database of the sort that existing e-mail clients want to use? ...
    (comp.unix.bsd.freebsd.misc)
  • Re: Report not sizing properly
    ... forms, reports, queries and code database is split from the data database ... and replace it on the clients when ready. ... I can't install a driver on the client's system. ...
    (microsoft.public.access.reports)
  • Recomendations on client installs of web application.
    ... I'm looking for any recommendations of tools or processes to develop an ... install that clients can run to install a web application on they're system. ... SQL with a database containing 4 tables. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Creating a Runtime version of App that is an upgrade
    ... using Access 2003 Developer. ... When I make a change to the database, ... build and go to install it on a machine that had a previous install, ... Is there a way of creating an upgrade for clients that ...
    (microsoft.public.access.devtoolkits)
  • Re: Supporting multiple oracle versions in a trigger
    ... This is a very unscalable solution. ... Why would you do that in a database? ... > - Clients can add/modify their data collection requirements in minutes ... > - Clients can connect to the database with 3rd party sql tools and access ...
    (comp.databases.oracle.server)