By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,646 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Worked ok until put on CD

P: n/a
I have a few databases (not split) on a server/network, I formatted the cd so
no problems with the read-only.
The db's open and most of the forms open with no problems, but some give me
this message.
Please advise why this works on the server/network and now on CD it gives the
following message on some forms.

Message:

The Microsoft Jet database engine cannot open the file". It is already opened
exclusively by another user, or you need permission to view it's data.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200605/1
May 23 '06 #1
Share this Question
Share on Google+
15 Replies


P: n/a
Mell via AccessMonster.com wrote:
I have a few databases (not split) on a server/network, I formatted
the cd so no problems with the read-only.
The db's open and most of the forms open with no problems, but some
give me this message.
Please advise why this works on the server/network and now on CD it
gives the following message on some forms.

Message:

The Microsoft Jet database engine cannot open the file". It is
already opened exclusively by another user, or you need permission to
view it's data.


You cannot run an Access file from a CD except in read-only mode even if you
have the CD formatted with packet writing capability. Those kinds of
"writes" are still not the same as writes to a truly read/write medium.
They are "burns" to the unused portion of the disk whereas true read/write
media can actually change existing bytes of the file. The latter is what
Access requires.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

May 23 '06 #2

P: n/a
Please forgive me.

My whole reason to put on a CD was taking it off a server/network where it
was at (created) and save it on a CD and then take that CD and save the db's
on another computer in another place.

Anotherwards, the db's were created in one place but now I need to remove
them (cd) and put them somewhere else for them to function the same way as
they did previously.
Is this possible from a CD?
What other choice do I have?

What type of cd do I need do have it function the same?
Rick Brandt 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.


You cannot run an Access file from a CD except in read-only mode even if you
have the CD formatted with packet writing capability. Those kinds of
"writes" are still not the same as writes to a truly read/write medium.
They are "burns" to the unused portion of the disk whereas true read/write
media can actually change existing bytes of the file. The latter is what
Access requires.


--
Message posted via http://www.accessmonster.com
May 23 '06 #3

P: n/a
I guess just zip them up and email then save as?
Any suggestions?

Mell wrote:
Please forgive me.

My whole reason to put on a CD was taking it off a server/network where it
was at (created) and save it on a CD and then take that CD and save the db's
on another computer in another place.

Anotherwards, the db's were created in one place but now I need to remove
them (cd) and put them somewhere else for them to function the same way as
they did previously.
Is this possible from a CD?
What other choice do I have?

What type of cd do I need do have it function the same?
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]
media can actually change existing bytes of the file. The latter is what
Access requires.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200605/1
May 23 '06 #4

P: n/a
"Mell via AccessMonster.com" <u18304@uwe> wrote in
news:60b1268b6a2ac@uwe:
I have a few databases (not split) on a server/network, I
formatted the cd so no problems with the read-only.
The db's open and most of the forms open with no problems, but
some give me this message.
Please advise why this works on the server/network and now on
CD it gives the following message on some forms.

Message:

The Microsoft Jet database engine cannot open the file". It is
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.
May 23 '06 #5

P: n/a
Disregard this comment, I knew better (read-only).
Mell wrote:
I guess just zip them up and email then save as?
Any suggestions?
Please forgive me.

[quoted text clipped - 15 lines]
media can actually change existing bytes of the file. The latter is what
Access requires.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200605/1
May 23 '06 #6

P: n/a
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.

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.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200605/1
May 23 '06 #7

P: n/a
Mell via AccessMonster.com wrote:
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.


In your original post it sounded (to me at least) as if you were trying to RUN
the app FROM the CD. You can certainly use a CD to copy your file to the hard
drive of another computer and then run it from there. On many operating systems
though the act of copying to a CD will set the Read Only flag and you will need
to reset it after copying the file onto another hard drive.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
May 23 '06 #8

P: n/a
A copy of a file on a CD is of course read-only. I believe that with an
Access MDB that setting is carried with the file when you copy it back onto
a hard disk. Right-click the file and check the properties after copying it
back to the network. If Read Only checkbox is checked, just click to clear
it.
May 23 '06 #9

P: n/a
Rick,

Thank you so much..

That was easily summed up.

It works.
Rick Brandt wrote:
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

[quoted text clipped - 3 lines]
db file so it will remain with all rights, etc?
Explain.


In your original post it sounded (to me at least) as if you were trying to RUN
the app FROM the CD. You can certainly use a CD to copy your file to the hard
drive of another computer and then run it from there. On many operating systems
though the act of copying to a CD will set the Read Only flag and you will need
to reset it after copying the file onto another hard drive.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200605/1
May 23 '06 #10

P: n/a
"Mell via AccessMonster.com" <u18304@uwe> wrote in
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.
May 24 '06 #11

P: n/a
"Rick Brandt" <ri*********@hotmail.com> wrote in
news:yT*******************@newssvr21.news.prodigy. com:
Mell via AccessMonster.com wrote:
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.


In your original post it sounded (to me at least) as if you were
trying to RUN the app FROM the CD. You can certainly use a CD to
copy your file to the hard drive of another computer and then run
it from there. On many operating systems though the act of
copying to a CD will set the Read Only flag and you will need to
reset it after copying the file onto another hard drive.


If you zip up the file and put the zip file on the CD, then you can
extract the writable MDB from the zip file. This is how I always do
it.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
May 24 '06 #12

P: n/a
Yes thank you.
David W. Fenton wrote:
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

[quoted text clipped - 10 lines]
copying to a CD will set the Read Only flag and you will need to
reset it after copying the file onto another hard drive.


If you zip up the file and put the zip file on the CD, then you can
extract the writable MDB from the zip file. This is how I always do
it.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200605/1
May 24 '06 #13

P: n/a
Nice trick. Thanks for the post!

If you zip up the file and put the zip file on the CD, then you can
extract the writable MDB from the zip file. This is how I always do
it.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

May 24 '06 #14

P: n/a
Rick Wannall wrote:

If you zip up the file and put the zip file on the CD, then you can
extract the writable MDB from the zip file. This is how I always do
it.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Nice trick. Thanks for the post!


Also, Windows XP no longer sets the Read Only flag when writing to a CD.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
May 24 '06 #15

P: n/a
Cool. Just tested and found you are absolutely correct. I hadn't noticed
this. Thanks!!
May 25 '06 #16

This discussion thread is closed

Replies have been disabled for this discussion.