Re: Problem with Standard Functions

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

Are they all sharing the same database, Mark? It's especially important that
the database be split into a front end (containing the queries, forms,
reports, macros and modules) and a back end (containing the tables and
relationships), and that each user have his/her own copy of the front-end
(preferably on their hard drive) when you're in a non-heterogenous
environment such as you're describing.

This is because when users have different versions of software installed,
it's almost guaranteed that there are going to be problems with the
References collection.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Mark A. Sam" <msam@xxxxxxxxxxxxxxxxx> wrote in message
news:uWXUuxqGGHA.1676@xxxxxxxxxxxxxxxxxxxxxxx
> Hello,
>
> I have an app that has been running for years on a client site, using .mde
> databases for the front end. Recenlty, one machine at a time, there is a
> problem with a screen which I traced to functions in a query, specifically
> the Format() and Datediff() functions, giving me an unknown function error
> when I try to open the query.
>
> I thought the problem may be that they were Dell Laptops, becuase they
seem
> to have a lot of problems with Access, but a user has a new Dell Desktop
> installed woth Office 2003, and this probleme occured. The other machines
> are running Access 2002.
>
> As the machines acted up I removed library references which initially
> resolved the issue, but then the problem reoccured on particular machines.
> Here are the Libraries now selected:
>
> Visual Basic for Applications
> Microsoft Access 10.0 Object Library
> Microsoft DAO 3.51 Object Library
>
> in that order.
>
> I get no compile errors on the troubled machines.
>
> I copied a .mdb version onto the network for them to use which resolves
the
> issue, but leaves the Db open to theft, which happened this winter by a
> former employee.
>
> Anyone have any idea on how to resolve this?
>
> Thanks for any help and God Bless,
>
> Mark A. Sam
>
>


.

Relevant Pages

  • Re: Problem with Standard Functions
    ... > Are they all sharing the same database, Mark? ... I think I tested that on one of the machines, but will again when the users ... >> Microsoft Access 10.0 Object Library ...
    (microsoft.public.access.formscoding)
  • Access Runtime and CreateObject
    ... My code needs to create a new bank database for each new job. ... below does this fine when Access is installed but 429's on machines with only ... Set appAccess = CreateObject ... ' Open database in Microsoft Access window. ...
    (microsoft.public.access.devtoolkits)
  • Re: Removing "Microsft Access" from the title bar in Access
    ... Mark wrote: ... Rick Brandt, Microsoft Access MVP ... RBrandt at Hunter dot com ...
    (microsoft.public.access.tablesdbdesign)
  • Performance optimization vs satisficing (was Language Oriented Programming)
    ... >machines that were too small. ... Microsoft has been a leading offender here. ... >arcane issue for server engines. ... magnitude slower, yes, I recall working on a 200mb database, trying to ...
    (comp.object)
  • Re: Access 2002 command line options.
    ... > database Opens the specified database. ... > /excl Opens the specified database for exclusive access. ... > /user user name Starts Microsoft Access using the specified user name. ... To compact to a different name, specify a target ...
    (microsoft.public.access.developers.toolkitode)