>Have setup a Remote View to an Access Database with the following Code:
>
>

>SELECT Universal_data."social security number", Universal_data."last name", Universal_data."first name"
> FROM "Universal Data" Universal_data
> WHERE  Universal_data."last name" = ?vp_last
> ORDER BY Universal_data."last name", Universal_data."first name"
>
>DBSetProp(ThisView,"View","SendUpdates",.F.)
>DBSetProp(ThisView,"View","BatchUpdateCount",1)
>DBSetProp(ThisView,"View","CompareMemo",.T.)
>DBSetProp(ThisView,"View","FetchAsNeeded",.F.)
>DBSetProp(ThisView,"View","FetchMemo",.T.)
>DBSetProp(ThisView,"View","FetchSize",100)
>DBSetProp(ThisView,"View","MaxRecords",-1)
>DBSetProp(ThisView,"View","Prepared",.F.)
>DBSetProp(ThisView,"View","ShareConnection",.F.)
>DBSetProp(ThisView,"View","AllowSimultaneousFetch",.F.)
>DBSetProp(ThisView,"View","UpdateType",1)
>DBSetProp(ThisView,"View","UseMemoSize",255)
>DBSetProp(ThisView,"View","Tables",CHR(34)+"Universal Data"+CHR(34))
>DBSetProp(ThisView,"View","WhereType",3)
>DBSetProp(ThisView,"View","ParameterList","vp_last,'C'")
>
>DBSetProp(ThisView+".social_security_number","Field","DataType","C(50)")
>DBSetProp(ThisView+".social_security_number","Field","UpdateName",CHR(34)+"Universal Data"+CHR(34)+"."+CHR(34)+"social security number"+CHR(34))
>DBSetProp(ThisView+".social_security_number","Field","KeyField",.F.)
>DBSetProp(ThisView+".social_security_number","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".last_name","Field","DataType","C(50)")
>DBSetProp(ThisView+".last_name","Field","UpdateName",CHR(34)+"Universal Data"+CHR(34)+"."+CHR(34)+"last name"+CHR(34))
>DBSetProp(ThisView+".last_name","Field","KeyField",.F.)
>DBSetProp(ThisView+".last_name","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".first_name","Field","DataType","C(50)")
>DBSetProp(ThisView+".first_name","Field","UpdateName",CHR(34)+"Universal Data"+CHR(34)+"."+CHR(34)+"first name"+CHR(34))
>DBSetProp(ThisView+".first_name","Field","KeyField",.F.)
>DBSetProp(ThisView+".first_name","Field","Updatable",.T.)
>

>
>Whenever I attempt to Edit this View, I get a Syntax Error Message Box Dialog. After clicking OK I can run the View but it always comes up with an empty result set no matter what is entered for the View Parameter. Could this be an issue caused by the spaces in the Access Database?

In addition to Fernando's response try adding alias to each column, e.g. as FirstName, as LastName ...

Also, you don't need to provide table alias if you're selecting from a single table in the column's list.