Search results for query: *

Hi, i'm about to switch server/domains so i'll be moving all of our files using robust copy. As our user where "migrated" or re-created on the new domain, i suppose that if i ask robocopy to copy the files and folders permissions it won't work as it will copy the premission associated with the...

When i wanted to deny these on my databases, i simply compiled a mde with some startup option forcing the user to go through my forms for adding/editing/deleting data from the databases. My forms have their own mechanisms for controlling access to the data. BUT... i just found out that you can...

Thanks again :) I got another question tough. I just realised that you can't use the "USE" statement in a view or functions, so my question is, how can i access the master database from a view?

I guess i could work with that. The other question is, how can i get my SPID? ;)

Is there a function in SQL Server that can get the IP address of the client running the query? Like "SELECT something, fn_clientipaddr() AS ipaddr FROM some_table" would returns something like that: something ipaddr --------- ------ somevalue 192.168.0.1 192.168.0.1 being my IP Anyone...

I'm trying to upsize the table (structure and data) of an Access database to a SQL Server. Everything seems to go smoothly, except that Access seems to freeze when it tries to create the extended properties of the tables. After some times it just gives an error telling that it "Cannot open any...

Hi, i'm having a trouble with my linked table... Everything seems ok, except the fact that Access doesn't seem to see the default value defined in SQL Server. Like, i create a table in the SQL Server Enterprise manager, one of the field having 0 as default value, i link that table to my mdb, and...

Hi, i'm having a trouble with my linked table... Everything seems ok, except the fact that Access doesn't seem to see the default value defined in SQL Server. Like, i create a table in the SQL Server Enterprise manager, one of the field having 0 as default value, i link that table to my mdb, and...

Well, my tables are all already indexed... i've ran the Index Tuning Wizard... and he couldn't offer me any improvement... As of indexing views... from what i've seen, it isn't possible most of the time

Well, i'm currently in the process of transferring an Access Database to an SQL Server with an Access front end. For now, i've upsized all of my table from access to SQL server. I've also "translated" manually most of my select query. Everything is working fine, except for one thing. Seems...

Well, i'm upsizing from an Access Database to an Access Project. I was having trouble with last(), i found a way around it, just to find it was causing me another trouble. My solution was to use an UDF to get my last row, here's an example: SELECT ProductID...

Because it's the last row doesn't mean it has the highest value...

I recently upsized MS Access Database to SQL Server, i only upsized the table and i'm now working on migrating the queries myself. Anyway, everything is fine, except for one thing. I've got a table contening ~14 500 products, the primary key goes up to around 15 500 as many products were...

Hi, i'm currently migrating an access database to an Access Project and i'm trying to achieve this in SQL Server: SELECT dbProductionCard.ProductID, Last(dbProductionCard.ClosingDate) AS LastOfClosingDate FROM dbProductionCard GROUP BY dbProductionCard.ProductID, dbProductionCard.Completed...