Search results

Hmmm ... if you are putting them in as Views, then they would appear as tables in Access. If you put them in as Stored Procedures, then you would have to create Pass-Through queries in Access to them and then they would show up in your query tab.

Well, I've never heard of a transaction log being placed in a location like that, but ... What error are you getting? If it is a transaction log, then it is probably attached to a database and that is why you are not able to move it. You can look at the sysfiles table in each database and...

I do not have this, but you should be able to backup and restore the databases. Be sure to have all of your logins on the server prior to the restore. You may still have to re-link the users and the databases, though. This is done through: EXEC sp_change_users_login 'auto_fix', 'YourUser'...

Since the package is already created and the structures are also created, let's re-use the Create Table task that should have been generated. Nuke the code in there and put in: TRUNCATE TABLEA TRUNCATE TABLEB : :

Well keeping it in SQL would look something like this: declare @Var char(8) select @var = '20021001' select substring(@Var,1,4) + '/' + substring(@Var,5,2) + '/' + substring(@Var,7,2) select convert(smalldatetime, substring(@Var,5,2) + '/' + right(@Var,2) + '/' + left(@Var,4)) Similar logic...

May need to do Ye Olde /Decompile. Search ...

Raskew, uhh ... never mind. Gemma is on top of it. SELECT Glorber.MyId, Glorber.MyDate, Glorber.Biopsy, DateDiff('d',DMax("mydate","Glorber","MyID = " & [MyID] & " AND MyDate < #" & [MyDate] & "#"),[mydate]) AS DaysSince FROM Glorber;

I second the No Local Tables mandate. What is the result set from the second database? #3 should have two sets of data. A listing from Database A and a listing from Database B. These two items are what are needed to be compared for the objects referenced in your query. Here is where your...

My suggestion would be to use a QueryDef object to re-write the underlying SQL.

Huh? Huh? Maybe post your query.

One of the tables in the query is named differently in the other database. 1) Post your query here 2) Run this on both databases SELECT MSysObjects.Name, MSysObjects.Type FROM MSysObjects WHERE (((MSysObjects.Type)=4)); 3) Post results here Is the query using SQL Server linked tables? If...

Happy to help.

Nice, hit some concerts at Red Rocks, then, I would assume.

You will have to iterate each field and alias the fields that are the same. Cumbersome, but the cost of having the same field names in different tables. SELECT Customers.Field1, Customers.Field2, Customers.RetailWeek1 AS Cust_RetWk1, SalesManagers.Field1, SalesManagers.Field2...

Shadow, this book will be fine. As someone who will be creating Tables, Stored Procedures and Views, SS2000 and SS2005 are the same. Different interface, but that will take you about 3 seconds to get over. SS2005's power comes from the integration of .NET principles, how DTS (data...

Try this: =DSum("MCcounter","Miracle_Cloth_Main","Cust_ID = '" & [Cust_ID] &"'")

Just to be clear, use the /decompile switch when opening your database. Here are Pat's instructions: http://www.access-programmers.co.uk/forums/showthread.php?t=113692&highlight=%2Fdecompile Afterwards, recompile.

Sure thing. I live in Beaverton and work in Lake O. Hwy 217 is a b!tch most of the time. I'm guessing your commute isn't too bad.

In your original post, you only had two distinct equations (showed 3, but two were the same) I'll abbreviate the equation to make it more readable: A: [WAPA Net]-([Med Bow 8]+[Med Bow 9])*[City Loss]+[City Energy Adj] B: [WAPA Out]-([Med Bow 8]*[City Loss])-[Clipper Energy]+[City Energy Adj]...

Well, 37560 represents 10/31/2002, so, I'm guessing that since the FALSE part of your equation matches what you want to be followed, I am guessing that what you want to do is replace the 37560 with "#10/31/06#" (remove the quotes) because right now it is following that logic for dates after...