Search results

Hello, I have an Access Database that connects to a split back end database. I have 2 tables that link to the backend tables. I need to secure the links to the DB. Right now, you can double click on the table and enter in any information. I want to use the table to view data from but I don't...

Hi, I have a new program and this is the first one I have made in MS Access 2007. I have split the DB so I only have links on the Front End to the BAck End Database. I want my users to only see the forms and never see the DB Links. I have tried going to Office Button --> Access Options -->...

Hello, I am in need of a function that will automatically link to my SQL DB upon logging into the App. I have set up an AUTOEXEC command that calls a module. In the module I have the following code: Dim cnlink As New ADODB.Connection Dim cnlink As New ADODB.Connection Dim rst As...

Hi, I have the below function that I thought would pull the Max # out of a field in my SQL table. strSQL = "Select (Max(ManualAutoNumber))+1 from ManualNextNumber" Public Function UniqueNumber() As Integer On Error GoTo Err_UniqueNumber Dim cn As ADODB.Connection Dim rs As...