How do I discover the drives on this \\belmont server?

I'm not sure what you mean by a 'drive' on the server... all I can get to is \\belmont\c$ and the \\belmont\Databases\Data which is where I see BCCrestore.mdf and BCCrestore_log.ldf

running this gives errors too:

RESTORE DATABASE BCCrestore

FROM DISK = '\\belmont\c$\BCC_DB_backup_201505030017.bak'

WITH MOVE 'BCC' TO '\\belmont\Databases\Data\BCCrestore.mdf',

MOVE 'BCC_log' TO '\\belmont\Databases\Data\BCCrestore_log.ldf',

REPLACE,

...

With the first block of code I get this:

Msg 3201, Level 16, State 2, Line 1

Cannot open backup device '\\belmont\c$\BCC_DB_backup_201505030017'. Operating system error 2(The system cannot find the file specified.).

plus...

I used the GUI method and got the error "The backup set holds a backup of a database other than the existing BCCrestore database."

I tried changing it to 'BCCrestored' but it didn't create that DB and multiple errors popped up:

RESTORE DATABASE BCCrestored FROM DISK = '\\Belmont\c$\BCC_DB_backup_201505030017.bak'

GO

Msg 1834, Level 16, State 1, Line 1

The...

I found the actual drive needed so I try to run: RESTORE DATABASE BCCrestore FROM DISK = '\\belmont\c$\BCC_DB_backup_201505030017.bak'

GO

But I get an error:

Msg 3154, Level 16, State 4, Line 1

The backup...

No the SQL Server instance is not on my local machine. I'm not sure how to discover the physical location. Would it help to recode my restore query with the...

Thanks for simplifying and also pointing out the permissions risks... BTW can a SP in SQL Server be called from VBA code in MS-Access/ Like "EXEC TruncateTmpBank"?

Actually I'm trying to use the Upsizing Wizard in Access instead of the ODBC tool (the latter of which I can get to through the control panel or Access itself...

I went to Services and found nothing relating to SQL Server.

That worked... humble thanks! -

WHERE (tbl_pac2k.[Installation Start Date] > GETDATE() -8) AND (tbl_pac2k.[Installation Start Date] < GETDATE() +22)

I'm trying to find all the records that are 1 week before today and 3 weeks after today including today.

I put in WHERE (tbl_pac2k.[Installation Start Date] > DATEADD(DAY, -7, [Installation Start Date])) AND (tbl_pac2k.[Installation Start Date] < DATEADD (DAY, 21, [Installation Start Date]))

into my embeddded query and it did...

Actually this is a a SQL Server query embedded in a datasource on an asp.net page... not MySQL.... I removed the second WHERE and an error showed up:

Incorrect syntax near...