Hi,
I am sure i already posted this question, but it seems to have disappeared??
Is the syntax of my code snippet below correct, as my app can’t find “AC.db” ?
db.DatabaseFile = GetFolderItem(SpecialFolder.ApplicationData.Child(“Accountancy Suite Data”).Child(“AC.db”))
It may not be semantically correct if the “Accounting Suite Data” folder does not exist or does not contain the “AC.db” file. You should probably create separate FolderItems to point to each of them so you can check their Exists property to ensure the folder and files are where you expect.
dim f as folderitem
dim ok as boolean
f=specialfolder.applicationdata.child("Accountancy Suite Data")
ok=(f.exists)
if ok then
f=f.Child("AC.db"))
ok=(f.exists)
end if
if not ok then
msgbox "no such database"
exit sub
end if
db.databasefile=f
This is off the top of my head so it might be “buggy” (or buggered???) use as example only… Not US centeric