D
Dreamear
This table was originally created using Access 2003. I am using this
database in Access 2007 but there are several other access databases all
linked to this database. I have changed the "linking" table, it shows up in
the table list and I can go there and move it to the correct place.
The problem is with all the queries and reports. Since the tables no longer
exist on the orinigal table I need to direct them to the correct table.
Everytime I go into design view and use SQL codes (thats what it appears as)
and change the FROM to the correct location I get the error back stating FROM
is not correct. I have checked it multiple times, everything is exact!!!
When I try to run tables and reports connected to the same queries, they give
errors stating the "xxx.mdb" is not a valid file. It is correct it is NOT a
valid file, it has been moved but it will not allow me to state where I have
moved it to.
This has been frustrating me for days!!! I cannot find a way to make this
database understand the basic file and table it needs to find and use for all
queries and tables has been moved. On top of it all, the table in the table
list is correct, but it appears that each querie when you go into design view
has the old table listed.
This is what i see when I go into design view for one of the queries...
SELECT tblIssue.*, tblIssue.IssueID
FROM (\\na.jnj.com\norusdfsroot\Silverside\Team Shared\SAP Implementation\SAP
Issues\SAPIssues-Database.mdb) tblIssue
WHERE (((tblIssue.IssueID) Is Null));
The Change has been made to...
SELECT tblIssue.*, tblIssue.IssueID
FROM (H:\Velocity_UserVersion) tblIssue
WHERE (((tblIssue.IssueID) Is Null));
The error it gives is symtax error in FROM clause and it higlights "tblIssue"
yet THAT is the EXTACT name of the table.
How do I correct this?? Is there anyway to browse and point to the correct
item? Can I do this in one fell swoop or do I need to change this in each
querie and form in design view?
Any help would be great!!!
Thanks.
database in Access 2007 but there are several other access databases all
linked to this database. I have changed the "linking" table, it shows up in
the table list and I can go there and move it to the correct place.
The problem is with all the queries and reports. Since the tables no longer
exist on the orinigal table I need to direct them to the correct table.
Everytime I go into design view and use SQL codes (thats what it appears as)
and change the FROM to the correct location I get the error back stating FROM
is not correct. I have checked it multiple times, everything is exact!!!
When I try to run tables and reports connected to the same queries, they give
errors stating the "xxx.mdb" is not a valid file. It is correct it is NOT a
valid file, it has been moved but it will not allow me to state where I have
moved it to.
This has been frustrating me for days!!! I cannot find a way to make this
database understand the basic file and table it needs to find and use for all
queries and tables has been moved. On top of it all, the table in the table
list is correct, but it appears that each querie when you go into design view
has the old table listed.
This is what i see when I go into design view for one of the queries...
SELECT tblIssue.*, tblIssue.IssueID
FROM (\\na.jnj.com\norusdfsroot\Silverside\Team Shared\SAP Implementation\SAP
Issues\SAPIssues-Database.mdb) tblIssue
WHERE (((tblIssue.IssueID) Is Null));
The Change has been made to...
SELECT tblIssue.*, tblIssue.IssueID
FROM (H:\Velocity_UserVersion) tblIssue
WHERE (((tblIssue.IssueID) Is Null));
The error it gives is symtax error in FROM clause and it higlights "tblIssue"
yet THAT is the EXTACT name of the table.
How do I correct this?? Is there anyway to browse and point to the correct
item? Can I do this in one fell swoop or do I need to change this in each
querie and form in design view?
Any help would be great!!!
Thanks.