Using ADO in VB6 to compact an Access97 database which has a database password set:
jro.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & fName & "; Password=xxx", _
" Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & tmpFileName & "; Jet...
An access database uses a combo box as the lookup display control for a foreign key, to get the 'Description' field from the linked table into the main table (bound column=1, column count=2,column width=0cm,3cm etc.)
I cannot link the tables in crystal because the field in the main table has...
The date format for scheduled instances is showing as mm/dd/yyyy, where the regional settings are set to dd/mm/yyyy and English(Aust). This occurs on Win98 clients, not Win2000. We have modified the registry on the Win98 machine to reflect the Win2000 client without success.
Any suggestions...
A formula to allow "ALL" as an option for selection criteria works fine for discreet values - but if a parameter allowing multiple values is used, a "This array must be subscripted" error is returned. Tried using an array in the selection criteria to store each parameter...
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.