Find and replace not working In access after tables are linked to SQL Server
We have a forms in access and Find and Replace works fine before the tables are migrated to the ms SQL.Now after I migrated the tables to SQL,Find and Replace takes too much time and I guess i would say it does not work.Please advise.Thanks
Microsoft DevelopmentMicrosoft AccessMicrosoft SQL Server
Last Comment
Dale Fye
8/22/2022 - Mon
Barry62
Were you using the find and replace tools in access, or were you running SQL queries?
If you are now using MSSQL, you'll need some queries.
What, specifically, are you trying to find and replace?
EugeneZ
you need to run post migration DB maints: reindex;update stats; etc and probably consider to review your code for optimization: add indexes , etc
Josh2442
ASKER
It's using the vba code and I am using find and replace tools in access.I dont know anything about the vba code.By the way we have forms and find and replace is a binocular things in access ,when user tries to put the account number,it displays the form for that account number but after I migrated to sql,its taking too much time though the records are at the forms.
Sounds like you need to find a vb programmer to modify the code. Can you access the vba code and copy and paste it here? Maybe we can modify it for you.
Josh2442
ASKER
Option Compare Database
Private Sub Command85_Click()
On Error GoTo Err_Command85_Click
If you are now using MSSQL, you'll need some queries.
What, specifically, are you trying to find and replace?