For several months I have used a database I will call DB1 on my own drive. I
also have an Excel report that imports a query from this DB and all was
working fine. I copied DB1 and the Excel report to a Department Folder on
the shared drive so others could run the report. When I try to re-direct the
query to to this drive I receive "Syntax Error From Clause". I even rebuilt
the database and all queries on this drive and still the same. I can copy
this DB to another shared drive however and it works just fine. It seem
there is something wrong with how the folder is set up as it works fine in
the other shared drive but am unable to convince our IT to look into. Any
ideas, or am I way off base. Really appreciate any help with this.
Thanks. (Not sure if this is an Access or Excel question)
Ken

On Aug 1, 9:02 am, Ken <K...@discussions.microsoft.com> wrote:
> For several months I have used a database I will call DB1 on my own drive. I
> also have an Excel report that imports a query from this DB and all was
> working fine. I copied DB1 and the Excel report to a Department Folder on
> the shared drive so others could run the report. When I try to re-direct the
> query to to this drive I receive "Syntax Error From Clause". I even rebuilt
> the database and all queries on this drive and still the same. I can copy
> this DB to another shared drive however and it works just fine. It seem
> there is something wrong with how the folder is set up as it works fine in
> the other shared drive but am unable to convince our IT to look into. Any
> ideas, or am I way off base. Really appreciate any help with this.
> Thanks. (Not sure if this is an Access or Excel question)
> Ken

Ask them about the difference in permissions on the two folders. When
you open a database, you have to have create permissions on the
containing folder so Access can create the LDB file. If it can't do
that, the database cannot open.

Thank you. I have asked them this. I believe I have discovered the problem.
The name of the folder they gave us is Svc.Parts. I believe the period in
this folder name is causing the problem. I have tested this theory in my own
drive by changing folder names with a period and receive the same message.

Thank you for your suggestion and I appreciate your help
Ken

"(E-Mail Removed)" wrote:

> On Aug 1, 9:02 am, Ken <K...@discussions.microsoft.com> wrote:
> > For several months I have used a database I will call DB1 on my own drive. I
> > also have an Excel report that imports a query from this DB and all was
> > working fine. I copied DB1 and the Excel report to a Department Folder on
> > the shared drive so others could run the report. When I try to re-direct the
> > query to to this drive I receive "Syntax Error From Clause". I even rebuilt
> > the database and all queries on this drive and still the same. I can copy
> > this DB to another shared drive however and it works just fine. It seem
> > there is something wrong with how the folder is set up as it works fine in
> > the other shared drive but am unable to convince our IT to look into. Any
> > ideas, or am I way off base. Really appreciate any help with this.
> > Thanks. (Not sure if this is an Access or Excel question)
> > Ken
>
> Ask them about the difference in permissions on the two folders. When
> you open a database, you have to have create permissions on the
> containing folder so Access can create the LDB file. If it can't do
> that, the database cannot open.
>
>