problem with newaccessproject method

K

Kurt V

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top