I am at present looking into upgrading an Acc97 back end to SQL Server, I have done a few tests and am finding that there are some wierd performace issues.
I was looking at improving sections of the database and leaving other sections alone and linking (via odbc) the remaining tables so that...
I have several fields in several tables that contain a numeric ID representing a contact record in another database (hence not linked) I am in need of creating a method to update this ID in every occurance, I was thinking of
For Each tbl In CurrentDb.TableDefs
For Each fld In tbl.Fields...
I have a frontend A97 database that is automatically distributed to users pc's there is a refernce to a DLL that is only installed on some machines. to avoid putting the DLL onto all the machines I tried to un-reference it when it is not present. But all I get is an error:
runtime error '48' -...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.