MDE Securities?

[KarloZ]

hello everyone, i trying to create a procedure that would create a backup of the MDE database. there are securities assigned to that mde file but when copied using FILECOPY command, all the restrictions are gone. are there other ways of making a backup of the MDE that will still inherit the securities that were assigned?. thank you in advance...

 

[Ed2020]

Can you post the code you are using to copy the mde? FileCopy simply carries out a Copy/Paste action so I can see no reason for you to be losing any security settings.

Are you using workgroup security?

Ed Metcalfe.

 

[KarloZ]

yes, its the filecopy i use and it loses the workgroup securities...what will i do with this? thanks...

 

[Ed2020]

I really haven't the faintest then. FileCopy should have the same effects as doing Copy/Paste in Windows Explorer - i.e. no changes to the file whatsoever, you get an exact duplicate.

I've just tested it on my machine and it doesn't remove any of my security.

Ed Metcalfe.

 

[KarloZ]

this is my code:
--------------------------------
Call Settings.SetServerDBPath ' this is to get the
' path of the current
' server db loc
cDir = Dir("C:\Backup_DB\SERVERDB.MDe&quot

If cDir = Empty Then
MkDir "C:\BACKUP_DB"
End If

If cDir <> Empty Then
Kill (&quot;c:\backup_db\serverdb.mde&quot
Else
FileCopy ServerDBPath + &quot;\serverdb.mde&quot;,
&quot;c:\serverdb.mde&quot;
End If
-----------------------------------

Also, i'm getting error with directory creation. do you know of other function to test if a direcory exists! DIR function test a file if it exists not actually the directory. Also, what other method do you use to backup a database. normally, database grows. it will get to the point that you cannot save it to a floppy disk coz of the file size. thank you again in advance