Creating a Recordset Using a Path

It is not recommended to hard-code paths into your application. However, if your application can retrieve a path from a registry entry or an environment variable and build the string below, using a path is an easy way to access a data store without having to define a named database.

rs.Open "Course", "Provider=PervasiveOLEDB;Data 
Source=C:\Pvsw\Demodata", adOpenDynamic, 
adLockBatchOptimistic, adCmdTableDirect