copying .mdb to a CD enables "read-only". How to avoid?

R

rudypohl

Guest

• Mar 7, 2003

• #1

Hi There:

Everytime I copy my .mdb file to a CD the "read-only" property gets enabled, and as a result, when the file is copied onto another computer it can only be used in "read-only" mode. I cannot uncheck the "read-only" property on the copy of the mdb file.

How do I make a copy of the mdb file onto a CD without the "read-only" property being automatically enabled?

I am using Access 2000. My CD burniung software is Esay CD Creator 5.

thanks,
Rudy

 

P

Pat Hartman

Super Moderator

Staff member

Local time

Today, 11:12

Joined

Feb 19, 2002

Messages

47,557

• Mar 7, 2003

• #2

Once you copy the file from the CD to a hard drive, you can reset the read-only attribute.

 

Oldsoftboss

AWF VIP

Local time

Tomorrow, 01:12

Joined

Oct 28, 2001

Messages

2,499

• Mar 8, 2003

• #3

Because a CD is fixed media when you burn your db to it, it automatically becomes read only. Once copied back to a hard drive, right click and remove the read only property.
Dave

 

ghudson

Registered User.

Local time

Today, 11:12

Joined

Jun 8, 2002

Messages

6,194

• Mar 8, 2003

• #4

Any file you burn to a CD will have the Read Only attribute when you copy it to a hard drive. I always zip my files up and use the self-extracting option to avoid having to mess with the Read Only attribute.

HTH

 

T

Tim K.

Registered User.

Local time

Today, 16:12

Joined

Aug 1, 2002

Messages

242

• Mar 9, 2003

• #5

If you use Windows XP, all files copied from a cd will be removed the Read-Only property out for you automatically.

For me, I use the code below to remove the property. Just put it in a start-up form. Though it will pop up the message once and only when the db is first open.

Code:

Private Sub Form_Open(Cancel As Integer)
    Dim strPath As String, Result As Long
    If GetAttr(CurrentDb.Name) And vbReadOnly = 1 Then
        SetAttr CurrentDb.Name, vbNormal
        strPath = SysCmd(acSysCmdAccessDir) & "MSAccess.exe " & CurrentDb.Name
        Call Shell(strPath, vbMaximizedFocus)
    DoCmd.Quit
    End If
End Sub