Recent content by jerem

The solution is to use Native Client. Solution cross-posted here: http://www.utteraccess.com/forum/index.php?showtopic=2037903&st=20

Hi I have a connection issue. My Ms Access 2010 database is made of linked table to SQL Azure. I have tested the connection string with the following code and it works well: Dim qdf As DAO.QueryDef, rst As DAO.Recordset Dim strResults As String Set qdf = CurrentDb.CreateQueryDef("")...

Cross post with answer: http://www.utteraccess.com/forum/index.php?showtopic=2036611&st=0&gopid=2594651&#entry2594651

Just a quick question. If you have a Ms Access front end with a DSN-less connection to a Ms SQL server database (2008). What would the implications or would there be any implications for the Ms Access front end if we activate data encryption in the SQL server database?

I see. I will have a look. thank you.

Here is the entire SQL for the view. Access connects to that view directly: SELECT DISTINCT dbo.tblPersonal.NbEmployee, dbo.tblPersonal.LegalName, dbo.tblPersonal.FullName, dbo.tblPersonal.StartDate, tblPersonal_1.LocationID...

Hi, I use an SQL view as my Form source. The form opens correctly, however I get an error message when running the report as a subreport (no master / child link): "Conversion failed when when converting the nvarchar value "[FullAddress]" to data type int. (#245)" Here is the function behind...

Ok you might be right... I made some changes to that query and it runs faster. However, it still doesn't explain why when the code was called from the VB editor it ran faster.

I have drilled a bit further. The area that is hanging is when executing the update query "qryUpRenormalize". When I trigger the code from the VBA editor, it takes about 3 sec, when clicking the button in the Form it takes 45 sec.

Here you are... Private Sub cmdSave_Click() On Error GoTo ErrHandler Application.Echo False Call NormalizeIt LoadCrosstabForm blnDataChangedInSubForm = False Me.cmdSave.Enabled = blnDataChangedInSubForm ExitSub: Application.Echo True Exit Sub ErrHandler: Call...

Hi I have a sub that is in a standard module. It is triggered by a button placed in a form. If I click on the button, the procedure takes a very long time but if I go into the VBA editor, run the sub while the form is open, it does the trick in no time at all. So I am at loss. Please help! Thank you

I see what you mean but in this case it seems necessary. Here is how it looks: There is an item which is the source of the main form. Then there is a subform (continuous form) with a Master/Child link with a bunch of sub-items. Then there are two other subforms (continuous forms) with parameters...

Hi, I am trying to create a versioning function in Ms Access. That means that I have a bunch of related data that I would like to duplicate with a new version number, also the child records should be duplicated and linked to the newly duplicated items. I can't get my head around what the best...

Thank you The_Doc_Man

...Alright... the only way I found was to change the source object of my subform to "" before deleting. Not sure what it indicates though.