Issues upgrading VBA app to SQL Server
Posted on 2006-07-20
I have a VBA app, which I am know connecting to a sql server db. I used to link frontend to access db and now its connect to sql server db.
Certain forms work fine, but I am getting different results and errors from differnent events, I suppose its to be expected, but some i am confused about.
1: In the VBA app, I connected to databases as follows
dim db as database
dim rst as recordset
set db = currentdb
sql = "select *"
Set rst = db.OpenRecordset(sql)
' This works fine in VBA, but after sql server conversio it works with some forms and not otheres. so I have to use the following
Set rst = CurrentDb.OpenRecordset(sql, dbOpenDynaset, dbSeeChanges)
Very unsure why this works with some and not the others.
Im also getting issues with
for certain sql functions.
2: The vba app is running slower since conversion, i.e calculations are taking longer, in my app i use a lot of the following code
Can this slow my app down when connected to sql server?
Hope someone can assist in some way,
any advice would be extremly helpfull