Search results

Anyone know the way to 100% secure your accdb/accde file ? What I mean secure is disable the ability to modify and see the design structure of the tables, forms, VBA code, etc. This is very important once you finish it and ready to distribute it to your users. Below are the tasks I made to...

Just want to make sure Access Runtime 2013 and 2016 can run on Windows Server 2012 R2 or not. As the official download site said Supported Operating System has only Windows 10 , Windows 7, Windows 8, Windows Server 2008 R2, Windows Server 2012

I create an accde by Access 2013. And "Microsoft Excel 15.0 Object Library" is need and was added. This accde is suppose to run on those Windows which has Access Runtime 2013 64bit installed. Problem arise if the Windows have no Office 2013 install. Because "Microsoft Excel 15.0 Object Library"...

I know the normal way to change the Application Icon - by go to "Access Options" > "Current Database" > "Application Icon" > Browse for an ico file But this not work if the path to the ico file is no longer valid. Since I only need the customized Application icon in the compiled accde file. Can...

I made an AutoExec macro in my accdb . Every time Access start, a "Marco Single Step" popup show and require to click on "Enable Content". I want to get rid of these, at the same time don't want to lose the security measure. Then I found this webpage...

The plan is: 1. A password protected backend accdb place in the network share drive 2. Frontend accde connect to the backend by the below code. The variable "theHashPass" store the encrypted password dbs.TableDefs(strTable).Connect = "MS Access;PWD=" & theHashPass & ";DATABASE=" & LnkDataBase...

I want to set form access permission base on domain credential. Then I found the below link (Can download a code sample at the lowest part of the webpage) http://www.accesssecurityblog.com/post/2011/02/05/Securing-Access-databases-using-Active-Directory.aspx It not work in my domain joined...

I've a main form name "FormA" with Navigation subform. Its Navigation button are target to the other form, I call these forms "FormB". These "FormB" has a subform inside. I call these subform "FormC". These "FormC" are all set to Datasheet View. User open "FormA". They can see these "FormC" and...

I've a form button, when click it'll first check if the target backend tables already linked. If not, it'll link to those tables. I made a function to do this task Function ChkLinkTbl(tableName As String) As Boolean Dim tdf As DAO.TableDef For Each tdf In CurrentDb.TableDefs If...

Below code works DoCmd.TransferDatabase acLink, "Microsoft Access", "path_to_accdb", acTable, "table1", "table1" In a for loop not work, show error 3011 "The Microsoft Access database engine could not find the object 'table1'. tables = Array("table1", "table2", "table3") For Each element In...

I've add the path in Trust Center - Trust Locations. Now, every time I link to those tables in the accdb file which inside the trusted location, there's no more warning show again. But, those not inside trusted location is still prompting the warning message. With a "Open" button that allow...

I've found some code on the web, like below Dim dbs As DAO.Database Dim tdf As DAO.TableDef Dim strConnect As String Set dbs = CurrentDb Set tdf = dbs.TableDefs("target_table") tdf.Connect = ";DATABASE=" & thePathToTheAccdb tdf.RefreshLink But I always got the error "Item not found in this...

I've attach the Excal and Access files. Just place the Excel file at "C:\", then click the button in the Access form. It suppose to run the SQL which copy the cell value from Excel file to the created Access table. It works if the cell value are number. But will show "Too few parameters Expected...

I know the Title is difficult to understand. Please see the example code below I want to run a serial of SQL in a for loop. Dim rst As Recordset Dim qryStr1, qryStr2, qryStr3 As String Dim i As Integer qryStr1 = "SELECT * FROM tableA WHERE blah blah blah" qryStr2 = "SELECT * FROM tableB WHERE...

I've a form that let user to input an ID, then click a button to show the result in a report's combo box. The reason I use combo box but not list box is because I need to limit the number of result show in the report. So I need "ListRows" which only can use with combo box. Private Sub...

I want to achieve the below tasks: 1. Create a form by VBA code 2. Dynamically add a control button to this form 3. Define the "Caption" for this button 4. Assign click event to this button 5. The click event is to delete the form itself 6. Form_Close() also delete the form itself Now, only...

I wrote a VBA code to get the field value of a csv file, then use it to update the database table. I paste some of my code below Dim objConn As New ADODB.Connection Dim objRs As New ADODB.Recordset Dim objUpdate As ADODB.Connection objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &...