Error "Alias currently not opened."

[Rickinrsm]

This worked well before but for some reason it fails now with the "Alias currently not opened" error.

I tried changing the esert: to :MYDIR: etc., but this failed also.

Ideas anyone . . ???

method pushButton(var eventInfo Event)
var;----------------Declare Variables-------------
Desert               table
DesertChangeToTable  table
qbe			   query
endVar;-------------End Variable List-------------
addAlias("MYDIR","Standard","D:\\Pdoxwin7\\Desert\\Desert.db")
;----------------------------------------------------------------

qbe=Query

:Desert:DesertChangeToTable.db | OfficeID | NewOfficeName |
                               | _ID      | _Name |

:Desert:Desert.db | ListID | ListName |
	      	| _ID    | changeto _Name |

endquery
	if not qbe.executeQbe()then
errorShow()
	return
	endif

qbe=Query

:Desert:DesertChangeToTable.db | OfficeID | NewOfficeName |
                               | _ID      | _Name |

:Desert:Desert.db  | SellID | SellName        |
                   | _ID    | changeto _Name  |

endquery
	if not qbe.executeQbe()then
errorShow()
	return
	endif
endMethod

Rick ~ Access Newbie

 

[TonyMcGuire]

You can't add an alias with a *TABLE* in the path.

Directory only.

Tony McGuire

http://www.thedbcommunity.com

"It's not about having enough time. It's about priorities.

 

[Rickinrsm]

Tony - I know you've had 16+ years with Paradox but I just don't know how you can understand it so intimately?

Thanks so much . . . Rick

ps . . . it worked of course.

Rick ~ Access Newbie