I don't know about a Jet API call, but you can compact an Access database through ODBC calls. Check the Access ODBC driver documentation and the ODBC driver API.
TO TRAILBLAZER:<br>
<br>
You need to install ODBC on all clients in order to be able to use ODBC from the clients, even if your datasource (database) is on an NT server.<br>
<br>
The ODBC Driver API allows registering data source names by having a piece of software doing it for you. Check the...
Make an Access file with the default workgroup file (system.mdw). From that Access file you can attach Oracle (ODBC) tables and ask to save username/password.<br>
<br>
The user shouldn't then need to enter any username/password at all.
SUB UpTrunc(x As double)<br>
Dim result As long<br>
result = Int(x) 'I believe it's Int, otherwise try Trunc<br>
If result<>x Then result = result + 1<br>
UpTrunc = result<br>
END SUB
There are several ActiveX controls you could use for that, or you could stick to 'Microsoft Win32 Internet API' (WININET) from Microsoft, which is a DLL that allows among others ftp-ing files.<br>
<br>
I've however never used WININET, but I have complete function reference on the MSDN library...
You could also use VBScript as a component ('Microsoft Script Control 1.0' or higher), included into your application. You can then fully dynamically create code (such as subroutines etc.) and have them run without any compilation or whatever !!!<br>
<br>
OK, OK, it's a heavy solution for what...
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.