Modules & VBA :: Backup Code Getting Permission Denied Error

Aug 22, 2014

I got these three code routines for backing up an Access database file from two different forums. I installed them as is, on a test database, creating command buttons for each. The test database is not password protected. I intend (if I can get one of these working) to install it on simple, single file, password protected databases.The first two came from Access World Forums at: URL....


Function BACKUPS()
On Error GoTo Err_BACKUPS
Dim fso As Object
Dim sSourcePath As String
Dim sSourceFile As String
Dim sBackupPath As String
Dim sBackupFile As String


I got a compile error "Invalid use of property." on the button sub. Then there was a simple On Click sub:


Private Sub Backup_Click()
Dim fs
Set fs = CreateObject("Scripting.FileSystemObject")
fs.CopyFile CurrentProject.FullName, "C:", True
Set fs = Nothing
MsgBox "Database has been backed up successfully"
End Sub
Private Sub Command32_Click()
End Sub

On this one I got a "Permission denied." error on the CopyFile method. As I said before, my database is not password protected.I found this third bit of code on another forum: URL...

Public Function db_Backup()
On Error GoTo db_Backup_Err

Dim sourceFile As String, destinationFile As String
Dim aFSO As Variant
Dim path As String, name As String


On this one I got another "Permission denied." error on the CopyFile method. Again, my database is not password protected. This code had appeared to me to be the most promising of the three.

View Replies


Modules & VBA :: Permission Denied On Own Profile

Sep 12, 2014

I have a backup procedure that is giving me a "Permission Denied" on my own profile.

Public Function BackupFE()
On Error GoTo BackupFE_Err

Dim SourceFile As String, DestinationFile As String
Dim aFSO As Variant
Dim Path As String, Name As String

[Code] .....

I've been over this and over it again.

View 3 Replies View Related

General :: Table Opening With Permission Denied Message

Jan 14, 2013

I have a simple log table that I am opening from a button on a form and adding a new record to the table.The table opens bu I get "Permission Denied" as a message - however I can then enter the form and enter data with no problem.why the VBA code cant do the same? what does Permission Denied usually mean?

View 7 Replies View Related

Limit User's Security Permission With Code

Sep 15, 2005

My db is secured using Access security but now find myself needing to code a little security work around if possible.

I have a form that has a subform. On the subform is a field named "Comments". The subform security only lets a particular group write to the fields it contains (including "Comments"). I have a new user that I need to allow to write to "Comments" but not to any of the other fields on the subform. I could make another subform with "Comments" only field and redo my security so that the original group can write to both subforms and new user can only write to "Comments" subform but I think it might be easier to code in that the new user is only allowed to write to field "Comments" in the existing subform. Every user logs into the db so I can get the user ID.

Is it possible to do this?

View 2 Replies View Related

Run Backup Code In VBA

Jan 22, 2007

I'm having trouble with some code to backup my database. I thought I'd just have some code call a batch file that copies the backend to a new location. The problem is that when I call the batch file, it opens and runs from c:documents and settings\%username%, so the relative paths in my batch file do not work.

Is there a way to have access tell run the batch file from command prompt in it's actual location? Or maybe it would be better just to copy the back end from within the VBA code. But I don't know how to do that, either. Maybe there's a way to use the Backup Database function under Tools/Database Utilities? With Sendkeys maybe? (but I don't know the code to do it).

View 8 Replies View Related

Error-You Do Not Have The Necessary Permission..

Jul 12, 2006


I get this error when opening my MS Access database - You do not have the necessary permissions to use the ...[flie name and path]... object. Have your system administrator or the person who created this object establish the necessary permissions for you.

The database works fine on another computer, but every time I transfer it to mine (I am on a network), I get the above error. I have recreated the User-level security workgroup file, no joy.

Can you help?

View 7 Replies View Related

General :: No Permission To Open Database Object Error

Jan 20, 2015

I have a 2003 .mdb file and the associated Workgroup Information File which normally resides on a network in a folder V:V-Base-DatabaseDATA. I have the Workgroup Information File.

The database is unsupported and we need to migrate the data to a new web based database.

When I try to open the database with the shift key down I get the following message :

You do not have the necessary permission to use the V:V-Base-DatabaseDATAV-Basebe.mdb object.

What is the best way to access the data and do I need to do this on the server instead of a local drive off site?

View 1 Replies View Related

"access Denied, Not Allowed In This Context" Error Msg

Sep 21, 2005

I have written an Access (2000) Db that uses the SendObject function to send an email. Works quite happily for my Windows 2000 Op System users, but not on XP machines. XP machines error with message something like "access denies, not available in this context". Any ideas?

View 2 Replies View Related

Modules & VBA :: Code Runs OK Once But Error Next Time

Jun 26, 2015

The task is (1) output an Access query to Excel (2) overwrite that file if it already exists (3) apply specific formatting to the header row and the other rows in Excel. I have cobbled the code together from two sources. The beginning and end are adapted from code on but the large insert in the middle is code I got form a project a former colleague had done. But he's no longer around.

The problem: I click the button and everything works OK. The file is created and formatted just how I want. If I click the button a second time though, it seems to run OK, but when I open the file it is NOT formatted. However, theres another window behind it called Book 1 which has all the data and all the correct formatting it just hasnt been saved. If I click it a third time I get an error message that says Object variable or With block variable not set. Im not even 100% all that is accurate because I have tried it a multitude of ways, closing and re-opening the form, closing and re-opening Access itself, starting with Excel open or closed, never with the destination excel file open though. I dont seem to get exactly the same behaviour any two times. But as far as I can see, if I close and re-open Access, it always works the first time. So I can live with it.

Private Sub cmdExport_Click()
On Error GoTo Errhandler
Dim rs As DAO.Recordset
Dim oExcel As Object
Dim oBook As Object
Dim oSheet As Object


View 8 Replies View Related

Modules & VBA :: Object Missing Error On Code To Apply Two Filters

May 12, 2015

I've got a form that takes the members from my members table and allows me to take attendance. I have it set up with toggle buttons in the footer (so we can see what class we're currently looking at) and I want to apply two filters when we click on a button. The two filters are "SS_Roll = Yes (or True)" and "SS_Class = AD1 (or whatever the class is)". I did some research and found one code for it, but now that I'm getting the missing object error and upon further research, I'm starting to think the code I found was only an excerpt. Below is the code I currently have. It highlights the first line when I hit debug.


Private Sub OptAD1_Click()
Table![MembersTable].FilterOn = True
Table![MembersTable].Filter = "[SS_Roll] = " & True And "[SS_Class] = " & AD1
End Sub

View 11 Replies View Related

Modules & VBA :: Calculate A Field That Excludes Weekends And Holidays - Code Error

Sep 24, 2014

I am using the function below to calculate a field that excludes weekends and holidays. The weekends are excluded as it is now, but when I try to add in code to exclude holidays I am getting errors. The code for the holidays is in bold and a couple of the errors are Loop without Do so I remove the Loop then I get a Else without If.

Option Compare Database

Public Function WorkingDays(Due_Date As Date, Result_Date As Date) As Integer
'-- Return the number of WorkingDays between Due_Date and Result_Date
On Error GoTo err_workingDays

[Code] ....

View 6 Replies View Related

Modules & VBA :: Hide 5 Buttons Depending If User Has Permission Which Works Fine

May 14, 2014

i have the following code that hides 5 buttons depending if the user has permission which works trying to incorporate an IF statement if there is only 1 of the buttons visible then to automatically click the button. but if there is more than 1 do noting?


Private Sub Form_Open(Cancel As Integer)
Dim rsO As DAO.Recordset
Set rsO = CurrentDb.OpenRecordset("SELECT tblUserPermission.UserFK, tblUserPermission.CompanyFK, tblUserPermission.Permission " & _
"FROM tblUserPermission INNER JOIN tblUser ON tblUserPermission.UserFK = tblUser.UserPK " & _
"WHERE Username = '" & Me.txtName.Value & "'")


View 3 Replies View Related

Modules & VBA :: Backup Backend Using Batch File?

Aug 14, 2014

I've created some code to make a backup of my database backend. I've tested it and it seems to work fine, I just have some questions about it's use. Here's the code:

Public Sub backupBackend()
Dim TestFile As String
Dim strReplFile As String
Dim copyFromLocation As String
Dim copyToLocation As String
copyFromLocation = "S:Trust 2 AnalysisData"


It will be triggered by a button push. It creates a batch file to do the copy operation and then delete itself.

In an ideal world I would schedule the backup at a safe time through the Windows scheduler, but our IT department won't allow me to do so.

The concern I have is that we could potentially press the backup button while a user is performing an action that writes/modifies data. If this were to happen would my backup potentially contain corrupted data?

If so, is the workaround to simply press the backup button when nobody is using the database?

View 3 Replies View Related

Modules & VBA :: Create Backup For Table In Another Database?

Jan 7, 2014

How to create backup for my table in another DB with VBA ....

View 3 Replies View Related

Modules & VBA :: Backup Records Programmatically Daily To Another Table

Jan 8, 2014

i have 2tables,table1=productid,ProductName,Qty table2=Productid,productName,Qty,date(). I want to be able to backup Records programatically daily from table1 into table2 OnClose.But i do not want duplication of record in the same day. If changes occurs in table1 after backup,table2 should be updated Programatically.

View 1 Replies View Related

Modules & VBA :: Backup / Zip And Email Copy Of Database Programmatically

Sep 11, 2013

I need a way that I can simply have a User click a button on a form of the database and it will do automatically create a zip file of the entire database and start Outlook and attach the zip file and send it to me.....

View 4 Replies View Related

Modules & VBA :: Create Backup Of Database On Exit In Different Directory

Dec 20, 2013

I am looking to create a backup of a database on exit in a different directory then where I am storing the database now.

View 3 Replies View Related

" Error - "The Current User Account Doesn't Have Permission To ......"

Jul 31, 2006

I have a very important access database running on a Windows 98SE laptop with Access 97 on the laptop. I wish to have that database backep up and opened on an XP machine running Access 2003. The problem is that the laptop is a corporate laptop with lots of security features and the database can only be opened by that laptop. The laptop only has permissions to read the file, so cannot remove the protection. I have tried to copy the system.mdw file across to the xp machine (in the correct directory), but I still get the below error.

The current user account doesn't have permission to convert or enable this database.

To convert or enable a database, ensure the following:
* You must join the workgroup that defines the user accounts used to access the database.
* Your user account must have Open/Run and Open Exclusive permissions for the database object.
* Your user account must have Modify Design or Administer permissions for all the tables in the database, or it must be the owner of all tables in the database.
* Your user account must have Read Design permission for all objects in the database.
* Request that other users close the database.

I have tried to create a new database on the xp machine and import all the data into a new database, but again I get an error (but only when importing certain forms and macros) below:

"You don't have permission to import, export or link to 'item name'"

I have also tried to create a blank database and import data from the database into it on the laptop, with the same error message above.

Does anybody have any ideas about this one? For example is there a piece of software to remove the protection (not a password remover)? - help appreciated.

View 4 Replies View Related

Modules & VBA :: Calling Public Function To Backup / Compact Back End?

Dec 23, 2013

I have the following function that I found online. Unfortunately I can't remember where I got it since I've had it for a little while. Today, when I tried to actually put it to use it didn't work.

I'm calling it from a form as follows: CompactDB (tblHotword)

tblHotword is just a random table from the back end. My understanding of the function was that it would use that table to connect and get the file name of the back end.

Whenever I run it, Access pops up a window that says "Object required" and nothing else. It doesn't look like a standard error message popup. When I click 'OK', Access continues with the rest of the code as if nothing went wrong. The function doesn't run though.

Public Function CompactDB(TableName As String) As Boolean
On Error GoTo Err_CompactDB
Dim stFileName
DoCmd.Hourglass True
stFileName = db.TableDefs(TableName).Connect


View 8 Replies View Related

Modules & VBA :: Command That Will Create Backup Of Access Database Once Every Week

Feb 24, 2014

Im trying to create a command that will create a backup of my access database once every week. here is the code I've got so far. it works, but not once a week but every time I start the access:

MsgBox ("Hello! Starting Backup procedure")

Dim DateOfBackup As Date
Dim strSourcePath As String
Dim strSourceFile As String
Dim strBackupFile As String
Dim SQL As String


View 2 Replies View Related

General :: Disk Or Network Error With Error Code 3043

Jul 13, 2012

How I can get rid of Disk or network error with error code 3043? What this error indicates.

View 4 Replies View Related

Simple Error Trapping By Error Code

Dec 6, 2005

hi all

i have the following peice of code ...

Private Sub NextApplication_Click()
On Error GoTo Err_NextApplication_Click
DoCmd.GoToRecord , , acNext

Exit Sub

If Err.Number = 2105 Then
MsgBox "Cannot navigate to the next record. This is the last record."
MsgBox Err.Description
End If

Resume Exit_NextApplication_Click

End Sub

but even when this error occurs nothing is being properly handled the way i specified - any ideas ?

View 3 Replies View Related

Access Denied Trying To Open COM1

Jun 14, 2006

I have a printer attached to COM1 which I print barcodes to, when I try to run the code I get a File/Access Denied Error 75 message.

Is there anything in Access 97 that could be causing this?


View 10 Replies View Related

Comments Section, Modify Denied?

May 20, 2005

We have several users that access the same database. Is there a way to make it so that the users can add comments to the "coments" field on the form, but not remove any comments once saved?

View 1 Replies View Related

Access Denied To Copying Database Folder

Mar 2, 2007

Hi all,

I have a database stored in a folder, and this folder can be accessed through a Network.

Is there a way to protect users from copying this folder to other areas? That is I would like to restrict access from users copying the folder where the database is stored.

Thanks for any suggestions and help.

View 1 Replies View Related

Code Error

May 1, 2005

I can't get this working. The code was posted by someone else. Anybody that can help, thanks so much.
I have a table name main1.
I have a form name main2. (input box and command button)

..........................I placed the code into my command button......

Private Sub Command2_Click()
Set con = Application.CurrentProject.Connection
Set rs = CreateObject("ADODB.Recordset")
stSql = "SELECT * FROM main1 "
'I have the password stored in this table!

rs.Open stSql, con, 1 ' 1 = adOpenKeyset

If Not (rs.EOF) Then
If rs![PASSWORD] = Form_main2.Text1.Value Then
'Text1 is my unbound box for the user to enter the password!
DoCmd.OpenForm "intro"
DoCmd.OpenForm "main2"
MsgBox "You have entered the wrong Password!"
End If
End If
End Sub

View 3 Replies View Related

Copyrights 2005-15, All rights reserved