Re: Worked ok until put on CD

"Mell via AccessMonster.com" <u18304@uwe> wrote in
60b3668ed285f@uwe:">news:60b3668ed285f@uwe:

When developers created ms access file on there site and want
to deploy with out the read-only and the error message that I
got on some of my forms when I put on cd, how do they do it?

Surely that do not go to each client and use their pc to
create the db file so it will remain with all rights, etc?
Explain.

Developers create an install package, which usually puts all the
files (the application, the help, and scripts) into an archive.

The installation script will set all parameters correctly,
including file attributes, registry entries, etc.


Bob Quintal wrote:
I have a few databases (not split) on a server/network, I
formatted the cd so no problems with the read-only.
[quoted text clipped - 8 lines]
already opened exclusively by another user, or you need
permission to view it's data.

When Access opens, it needs to create/modify a .ldb file with
the same path and file name as the .mdb. If it cannot, it will
say that the database is exclusively opened by another user. I
suspect that an error message exists in Access which reads
"Cannot create or open the .ldb" which will get shown when
something completely different is the real problem.

The .mdb must exist on a read-write drive where every user has
read/write/create rights to the location where the .mdb
exists. A CD, even if RW, will not allow modify, but fakes it
by rewriting the entire file. Access refuses to accept this
fakery.

HTH.





--
Bob Quintal

PA is y I've altered my email address.
.

Relevant Pages

  • Re: Worked ok until put on CD
    ... out the read-only and the error message that I got on some of my forms when I ... When Access opens, it needs to create/modify a .ldb file with ... The .mdb must exist on a read-write drive where every user has ...
    (comp.databases.ms-access)
  • Re: Error - Error Accessing File. Network Conn..." File Corruption?
    ... > consuming problem receiving the error message "Error Accessing File. ... > truly clean up an mdb? ... Sometimes the app ... > - Does anyone know of a good site dealing with Access file corruption? ...
    (microsoft.public.access.formscoding)
  • Re: Is my mdb corrupted ?
    ... If you suspect that a database is corrupt then I suggest that the first ... I have an mdb with the application and an mdb with the ... IS MY MDB CORRUPTED RESULTING IN THESE PROBLEM AND ERROR MESSAGE? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Invalid Argument
    ... 2GB is the maximum size of an MDB, so if you're exceeding that then yes, ... You could try putting each table into a separate MDB, ... > individual Append queries. ... > It just so happened that I also got the same error message when I tried to ...
    (microsoft.public.access.queries)
  • Re: Permissions
    ... The error message implies that the user is not using the correct mdw file, and the mdb in question is secure. ... The best way to implement, is to leave the users' computers joined by default to the standard system.mdw that ships with Access, and provide a desktop shortcut for secure mdb files - the shortcut includes a switch that will override the default mdw setting. ... One of the Data Bases opens without a problem and the other gives the error message "You do not have the necessary permissions to run this Data Base" Could any one advise me what the problem could be? ...
    (microsoft.public.access.security)