Well that all depends on what method you want to use to open it. There are many options such as ADO or DAO to create a connection to the database. Using DAO you would do the following.
Dim dbTest as DAO.Database
dim rsTest as DAO.Recordset
Set dbTest.OpenDatabase(<Database path and name>)...
Hi everyone,
My company is looking to upgrade the backend of our programs from Access 2000 to SQL Server 2005 Express. There are some issues we need to address with this before we can begin. We have 300 - 400 clients who use our product. The biggest issue we have is this. We have 10 -...