Recent content by sueb859

FancyPrairie, Would you be able to share code where you set and retrieve the Custom property? Sue

Access Developers Guide to SQL Server. Found it on Amazon and it was great! I use Access frontend with data in SQL Server extensively. Let me know if you have any questions.

I was wondering how people who are using ADP are able to determine if a user of the front end has the most recent version of the program. In the mdb a local table is often used to store this information but this is not an option in and ADP. Sue

I've not used a library database. Is the library database on a network? Do they need a reference set to the library database? Does the user need anything special on the computer to make this work? How do you refer to functions in your library which are run? Not something I've worked with...

FancyPrarie, Are you doing all of this checking from Access? Are you using linked tables? Are you able to share any of your code? What I've been trying to do is fiqure out a way to determine if an mdb is the latest version without having to open the database to look at a table which stores...

Is there a way to receive some type of email notification if a job fails to start or if the job does not succeed?

Jimmy211, I finally did get it to work by setting up a proxy account on the server. Right click on SQL Server Agent and go to properties. Go to the tab Job System. At the bottom you need to uncheck only sysadmin can execute CmdExec and hit button Reset Proxy Account. This was set up to an...

Jimmy211, So this is an ActiveX script that is scheduled as a job that then runs a DTS package? Is that correct? Don't you still need to be a sysadmin, or have a proxy account set up to run this?

I have tried using the EXEC master..xp_cmdshell 'dtsrun /S /E /N' command in a stored procedure but permission is denied due to not being a sysadmin. Is there a way around this?

Jeremy, I like your solution but wondered if you have a way to get rid of the old text files that keep track of the version when a new text file get installed. Sue