Using VB 6, I'm trying to append (or import) data from a secure Access 97 database into a secure Access 2k database. They have two different .mdw files. The VB code to set up and access the Access 2k Database is:
DBEngine.SystemDB = "C:\Program Files\Keepers\Time.mdw"
DBEngine.DefaultUser = "TimeUser"
DBEngine.DefaultPassword = "timeuser"
WorkSID = "K" & Text1(0).Text
WhatUser = "TimeUser"
WhatPassword = "timeuser"
Set TimeSpace = Nothing
Set TimeSpace = DBEngine.CreateWorkspace(WorkSID, WhatUser, WhatPassword)
Set TimeIt = TimeSpace.OpenDatabase(WhatDataBase)
do I need to set a new workspace id for the 97 db? can I just write sql statement and pass security info?
Thank you
DBEngine.SystemDB = "C:\Program Files\Keepers\Time.mdw"
DBEngine.DefaultUser = "TimeUser"
DBEngine.DefaultPassword = "timeuser"
WorkSID = "K" & Text1(0).Text
WhatUser = "TimeUser"
WhatPassword = "timeuser"
Set TimeSpace = Nothing
Set TimeSpace = DBEngine.CreateWorkspace(WorkSID, WhatUser, WhatPassword)
Set TimeIt = TimeSpace.OpenDatabase(WhatDataBase)
do I need to set a new workspace id for the 97 db? can I just write sql statement and pass security info?
Thank you