Posts tagged Access

MS Access – Remove “dbo_” prefix from imported tables

0
3 years ago
in
The procedure below, can be used to remove the “dbo_” prefix from all imported tables within a Microsoft Access Database. Public Sub Remove_DBO_Prefix()       Dim obj As AccessObject     Dim dbs As Object       Set dbs = Application.CurrentData       'Search for open AccessObject objects in [...]

The ‘Microsoft.Jet.OLEDB.4.0′ provider is not registered on local machine

0
3 years ago
in ,
I was in the middle of writing an application to retrieve the list of Access Database Tables, but I was getting the error “The ‘Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine.” I discovered, that as I was using Vista x64, I needed to change the “Advanced Compiler Options” [...]
Go to Top