Search results

In my VBA application access 2007 I used to work with SQL-DMO. This no longer supported by Microsoft so I have rewrite everything to SMO. If I try to add the microsoft.sglserver.smo.dll from the sqlserver 110 sdk assemblies dir in the reference I get an error: can't add a reference to the...

access 2003 sp3 os xp I want to query a table which as timestamp with 16 digit. With serial I made a timestamp but it looks like 2,0080221194445E+15. I declared timestamp as double with long I get a overflow. If I use this in my query in vba it doesn't except a comma. If I use the same number...

Access2003 sp3 OS XP I would like to make a csv file using ADO. I can do it with DAO but is it also possible with ADO. DAO solution Dim rs_rel As DAO.Recordset Dim qdf As DAO.QueryDef Dim db As DAO.Database Dim tblrel As String Set db = CurrentDb() Set qdf = db.CreateQueryDef(name:="abc") Set...