Hi Guru
I convert one access 2000 database into SQL server backend, this is no problem.
The problem is:
There is another portable database called traveller is a 'snapshot' copy of Master database in it's entirety, which loaded onto a laptop and carry on the plane, so the traveller database has to be standalone database(data and forms have to be same package). Now I convert the master database as SQL backend, I can’t do the traveller as linked table of SQL backend.
Original code as:
Set FSO = CreateObject("Scripting.FileSystemObject")
SFile = strAppPath & "\traveller2*" ' set source files variable
DFile = strTraveller ' set destination directory variable
FSO.CopyFile SFile, DFile, True ' copy the files overwriting as necessary
Above code I copy all master database to traveller, Which I don’t want the linked table, how can I do making it as standalone database, all the table structure and data are the same?
I prefer using VBA if possible, or maybe I have load SQL server into the laptop (this is last choice).
Any ideas are welcome.
Cathy
I convert one access 2000 database into SQL server backend, this is no problem.
The problem is:
There is another portable database called traveller is a 'snapshot' copy of Master database in it's entirety, which loaded onto a laptop and carry on the plane, so the traveller database has to be standalone database(data and forms have to be same package). Now I convert the master database as SQL backend, I can’t do the traveller as linked table of SQL backend.
Original code as:
Set FSO = CreateObject("Scripting.FileSystemObject")
SFile = strAppPath & "\traveller2*" ' set source files variable
DFile = strTraveller ' set destination directory variable
FSO.CopyFile SFile, DFile, True ' copy the files overwriting as necessary
Above code I copy all master database to traveller, Which I don’t want the linked table, how can I do making it as standalone database, all the table structure and data are the same?
I prefer using VBA if possible, or maybe I have load SQL server into the laptop (this is last choice).
Any ideas are welcome.
Cathy