I want my VB application to open an access97 instance. I need this to be done without any user interaction,
The problem is that opening the database requires login and password, so when I'm creating the new access
instance, it first opens a login screen and wait.
Is there a way that I can automatically insert the login/password without user interaction?
I set up an Access DB, set the password to "Password", I haven't tried yet with User name - but try this first.
Note no error handling
Private Sub Form_Load()
Dim acc As Object
Set acc = CreateObject("Access.application")
Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!
There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function. While writing that article I realized that no o…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…