Hello
I'm connected to foo2 dbase on sql msde server .
? CurrentProject.BaseConnectionString
PROVIDER=SQLOLEDB.1;INTEGRATED SECURITY=SSPI;PERSIST SECURITY
INFO=FALSE;INITIAL CATALOG=foo2;DATA SOURCE=ADIXPD001
I want to make a new access project , an adp file
Dim obj1 As Access.Application
Dim str1 As String
str1 = CurrentProject.BaseConnectionString
'Instantiate Access session
Set obj1 = CreateObject("Access.application")
'Save Access session as Access project pointing at str1
obj1.NewAccessProject "c:\access11files\foo2", str1
after i run this sub nothing happens , there's no adp created on the c
drive , i don't know what the problem is, can somebody help me ?
Thanks
|