Search results

Did it change using a regular DSN connection? Typically it is an issue with primary keys. But not always, I have one on a view right now i can't figuer out.

SQL server 2008, ODBC connection. Both DEV. and PROD same. DEV. can update a view via open it (forms based off the view) and update in form, etc. PROD, won't allow updates either in the form or opening the view directly. View permissions are the same on SQL both DEV and PROD. Delinked and...

What if you do this instead: SELECT Customers.Type, Orders.* FROM Orders INNER JOIN Customers on Orders.CustomerID = Customers.CustomerID Where OrderID = SomeOrderID Given OrderID is also indexed. Technically it should not matter, but I have seem Access do some things one would not think would...

The SQL server table should have a UNIQUE PRIMARY key you can use. Access keeps track of the rows by the key you define when it asks. how ever if you do not define keys to make each row unique, it does strange things).

The Avg(scc) should do that for you, however you need understand what your GroupBy is doing. It will only AVG for each unique row your groupby returns. Since weight, pickupdate and pickup are part of your group by, you get a unique row for each combined value. Avg is doing what you ask. select...

Do you not have to supply the security when you connect? SQL server and Oracle connections popup a security window if you do not supply that at connection time. Typically when you setup a USER/SYSTEM/FILE DSN you supply connection security, I don't see that in your connection string. Not sure...

You need to resort to VBA, build the filename with the date and then export the results. Or you could try using a function to return the filename in the macro and build the file name externally (in the function) in VBA. Have not tried using a function in a macro such as that, so not 100% it...

you could setup a function to multiple the value (times 2) and insert that many tabs in the front of whatever it is you have. So basically: Function AddTabs(MyValue) as String Dim LpIt integer AddTabs = "" If MyValue = 0 then exit function End If For LpIt = 1 to MyValue AddTabs = AddTabs &...

2003 MDB working in 2007. So I removed the ODBC linked table from Access. I dropped the table on the SQL server. I use VBA code to refresh the links. I get an error that says the table does not exist (DAH). I'm using DAO and it errors on the RefreshLink command as it is doing a FOR EACH through...

Can you use SQL's dateadd function to calculate instead?

Not 100% sure, but have you tried registering the DLL with windows?

have you looked at a crosstab query?

it seems to me the question is what ties these two tables together. I.E. how do you know the products go with that Contract? A cross reference or juncture table maybe the proper approach, unless the data in your products table is unique to a specific contract. If the product data is unique to a...

Well you could select your event ID, and use two subselects to select the desired date based on the event ID and the activity ID. But it would not be an updatable query (display only or report only type thing).

Typically we do this by using a common (per format) import table. Than using one or more queries to place that data where it belongs. The advantage is you clear out (delete all query) the "work" table before importing. So you are only dealing with the current data. Now how you decide to do that...

Oh the problem should be resolved, I pointed out many issues with their design, and was told, no money to fix, we need to let only one person in at a time. Sometimes we are just stuck with it.....

We have had some issues using the Native SQL Client (10), and have reverted some of those back to ODBC, even if they are using SQL 2008. mostly if you are trying to do fancier stuff, like pass parameters to a SP (and they are not hard coded), stuff like that, mostly using Net Framework stuff...

DNS is what converts a name to an IP address, so DSN is the proper term in this reference. if it is any consolation, i get them confused all the time. DSN also MAY use ODBC or OLEDB or native clients (maybe more even). DSN is a method to describe the connection properties and method to...

I'll give that a try. Thanks

i thought it was just Replace()