linking databases

[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

 

[golfinray]

All I do is file\get external data\link tables. It will ask you the location
and browse to it.

 

[KARL DEWEY]

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;

 

[KARL DEWEY]

Wrong thread --

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;

All I do is file\get external data\link tables. It will ask you the location
and browse to it.

 

[zufie]

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 -

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

 

[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 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

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