linking databases

  • Thread starter Thread starter zufie
  • Start date Start date
Z

zufie

I am trying to link one database that contains tables containing data,
queries, forms and reports with a second database that only contains
tables & data within those tables.

I get the error "could notfind file" then it lists the last file path
I used for the two databases.

For example, if I placed both databases on my computer desktop then
the error would read:

Could not find file 'C:\Documents and Settings\jmarruff.IDPH\Desktop
\HLTT.mdb'

I looked up the error in Access help, "Could not find file <name>.
(Error 3024)"

It listed the following Possible causes:

The specified file does not exist.
You misspelled the file name. Check for missing underscores ( _ ) or
other punctuation, and make sure you did not enter leading spaces.
The network connection has failed or has not been established.

Thanks for your ideas!

John
 
All I do is file\get external data\link tables. It will ask you the location
and browse to it.
 
Try this --
SELECT Q.Year, Q.Month, Q.[Total Sales], (SELECT COUNT(*) FROM [Product] Q1
WHERE Q1.[Year] = Q.[Year]
AND Q1.[Total Sales] > Q.[Total Sales])+1 AS Rank
FROM Product AS Q
WHERE ((((SELECT COUNT(*) FROM [Product] Q1
WHERE Q1.[Year] = Q.[Year]
AND Q1.[Total Sales] > Q.[Total Sales])+1)<=5))
ORDER BY Q.Year, Q.[Total Sales] DESC;
 
Wrong thread --

KARL DEWEY said:
Try this --
SELECT Q.Year, Q.Month, Q.[Total Sales], (SELECT COUNT(*) FROM [Product] Q1
WHERE Q1.[Year] = Q.[Year]
AND Q1.[Total Sales] > Q.[Total Sales])+1 AS Rank
FROM Product AS Q
WHERE ((((SELECT COUNT(*) FROM [Product] Q1
WHERE Q1.[Year] = Q.[Year]
AND Q1.[Total Sales] > Q.[Total Sales])+1)<=5))
ORDER BY Q.Year, Q.[Total Sales] DESC;

golfinray said:
All I do is file\get external data\link tables. It will ask you the location
and browse to it.
Click to expand...
Click to expand...
 
All I do is file\get external data\link tables. It will ask you the location
and browse to it.
--
Milton Purdy
ACCESS
State of Arkansas













- Show quoted text -
Click to expand...

I am so dumb!. I really am. That's why I'm trying to transition out
of
the IT field.

It took nothing more than to open Windows Explorer and to move the
SourceCode folder up one level as my boss fixed it.


I should have known how to do this after 3.5 yrs in IT!


John
 
I am trying to link one database that contains tables containing data,
queries, forms and reports with a second database that only contains
tables & data within those tables.

I get the error "could notfind file" then it lists the last file path
I used for the twodatabases.

For example, if I placed bothdatabaseson my computer desktop then
the error would read:

Could not find file 'C:\Documents and Settings\jmarruff.IDPH\Desktop
\HLTT.mdb'

I looked up the error in Access help, "Could not find file <name>.
(Error 3024)"

It listed the following Possible causes:

The specified file does not exist.
You misspelled the file name. Check for missing underscores ( _ ) or
other punctuation, and make sure you did not enter leading spaces.
The network connection has failed or has not been established.

Thanks for your ideas!

John
Click to expand...

I am so dumb!. I really am. That's why I'm trying to transition out
of
the IT field.

It took nothing more than to open Windows Explorer and to move the
SourceCode folder up one level as my boss fixed it.


I should have known how to do this after 3.5 yrs in IT!


John
 
Back
Top