Search results for query: *

Does anyone have a solution for password protecting or write protecting a PDF file with .net code or a free third party tool writen i managed .net code?

Hi! Reporting Services do not support write protecting or password protecting rendered PDF files. How can I do it after the render? We render the document in our desktop application so we have full control over it. We have also developed a merge method to merge several pdf documents to a...

Hi, how do I abort an SQL-script when it contains the GO command? I want to be able to send the customer a script that creates tables, views and storred procedures etc. and be able to abort the script. At the start of the script I check some stuff and if it's not right I dont want to run the...

I try to use sql dmo (sqldmo.dll) on a computer. It works fine when an administrator use my application but it does not work for any other user. First I got error number 70 when I tried to create an instance of sqldmo. When I changed the access rights for the file sqldmo.dll the errormessage...

Hi, What scope does XACT_ABORT affect when I set it in a stored procedure? The entire server? The connection? SET XACT_ABORT ON SET XACT_ABORT OFF

Hi, Can I with vba-code check what version of Access the user is using?

Hi, if you write protect an .adp or .ade file you get a warning message when you open it: "The database xxx will be opened read-only...". Can I remove that warning message? Is't wery confusing! The user realy think that the DATABASE is read only when it's only the klient that is...

Hi, I want to set ownership (to "Administrators") with code. I know you can use cacls.exe to set permissions but how do you change ownership? //Martin

Hi, Does anybody know anything about components for editing images? I am looking for an alternative for the ImgEdit component that’s included in Windows. Just mention a name or point me in the right direction.

Hi, I have a rather large Access project connected to an SQL-Server. The larger the project gets (more code) the longer time it takes for it to start up. Even if I shift-start it. No code is running, and no data is fetched from the database. It's just the time to load the file. Do anybody have...

Hi, I have a rather large Access project connected to an SQL-Server. The larger the project gets (more code) the longer time it takes for it to start up. Even if I shift-start it. No code is running, and no data is fetched from the database. It's just the time to load the file. Do anybody have...

How do I use a variable in the FOR expression for a cursor. I want to do something like this: SET @sSQL = 'SELECT * FROM ' + @sLinkedDBName + '...Table1' DECLARE TheCursor CURSOR FOR @sSQL OPEN TheCursor . . . How do I use the "@sLinkedDBName" - variable in the FOR...

Hi, I want to use the values from a sp in a WHERE-Clause. Do any one have a example of how I can do that in the simplest way. This is what I want to do: SELECT * FROM Table1 WHERE Table1.ID IN (SELECT ID FROM sp_GetID)

Some times I want to use listboxes from "Forms 2.0" instead of the usual Access listboxes. The problem is that sometimes the background shines thru where the horizontal scrollbar use to be. Do somebody know why, and how to fix this problem?

If I try to execute a stored procedure including an insert into a temptable the sp don’t return any values. The problem only occurs when I am executing the sp from a Access project. The sp works fine in Query Analyzer. It works on one of the servers I’m working against but I don’t know why and...

If I try to execute a stored procedure including an insert into a temptable the sp don’t return any values. The problem only occurs when I am executing the sp from a Access project. The sp works fine in Query Analyzer. It works on one of the servers I’m working against but I don’t know why and...

If I try to execute a stored procedure including an insert into a temptable the sp don’t return any values. The problem only occurs when I am executing the sp from a Access project. The sp works fine in Query Analyzer. It works on one of the servers I’m working against but I don’t know why and...

If you create an Access project and use it with MSSQL-server you can’t specify "Default open mode"(Advanced tab on options). You can’t specify it by code either. It is always "Exclusive". I want the users to use the same .adp or .ade file on the server so I don’t need to copy...

If you create an Access project and use it with MSSQL-server you can’t specify "Default open mode"(Advanced tab on options). You can’t specify it by code either. It is always "Exclusive". I want the users to use the same .adp or .ade file on the server so I don’t need to copy...