M
muratas
Guest
Hi,
I have an mdb database and want to upsize it to SQL server. I've been changing all DAO codes to ADO made a trial shot. While below codes runs without any problem on mdb module, when I try to run it in adp module I receive an error message on the last line (operation requested by the application is not supported by the provider, run time error 3251).
Where am I wrong? How can I chang my queries in code in Access Project modules?
Thanks in advance
Murat
Here is the code;
Public Sub ADOtry()
Dim cat As New ADOX.Catalog
Dim cmd As ADODB.Command
Dim cn As New ADODB.Connection
Set cn = CurrentProject.Connection
cat.ActiveConnection = cn
Set cmd = cat.Views("qryDel").Command
End Sub
I have an mdb database and want to upsize it to SQL server. I've been changing all DAO codes to ADO made a trial shot. While below codes runs without any problem on mdb module, when I try to run it in adp module I receive an error message on the last line (operation requested by the application is not supported by the provider, run time error 3251).
Where am I wrong? How can I chang my queries in code in Access Project modules?
Thanks in advance
Murat
Here is the code;
Public Sub ADOtry()
Dim cat As New ADOX.Catalog
Dim cmd As ADODB.Command
Dim cn As New ADODB.Connection
Set cn = CurrentProject.Connection
cat.ActiveConnection = cn
Set cmd = cat.Views("qryDel").Command
End Sub
