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

It was just a syntax problem, but if anyone needs it here's the way I rewrote the concatenation that works:

Select

A.tp_LeafName as Filename, 'http://mysite.com/' + A.tp_DrName + '/' + A.FileName...

Thanks! this worked

CREATE TABLE [dbo].[tblTransactions](

[PO_Number] [varchar](50) NULL,

[Buyer_Initial] [varchar](50) NULL,

[Quantity] [int] NULL,

[Unit_Price] [money] NULL,

[Software_Description] [varchar](100) NULL,

[AllocationAccount] [varchar](50) NULL,

[PurchaseAccount] [varchar](50) NULL,

[HeatTicketNumber] [varchar](50) NULL,

[PurchaseCostCenter] [varchar](25) NULL,

[PO_Date] [date] NULL,

[Transaction_Date] [date] NULL,

[Transaction_Number] [int] IDENTITY(1,1) NOT NULL,

[AllocationDate] [date]...

Thanks! Works!