Search results for query: *

I have an Excel Add-in that works with an Excel Template, and you need to enable macros when opening the workbook to get all the functionality. I'd like to handle errors encountered when users don't enable macros by displaying a message. Is there a way to check programmatically in VB.Net if...

I have a VB.Net Add-in for Excel that I'm updating. It works with a previously created Excel Template. I am updating the Add-in and the template, and would like to programmatically make my template changes in existing workbooks created from the template. I've found that I need to change some of...

Thanks. I was hoping there was a way to do it without recreating the table, or adding a new field. I didn't realize that what Enterprise Manager did was recreate the table. I guess I will do that programatically. Thanks again for your help.

I have a number of tables that use an identity field as a primary key. I need to change the key of the table, and I'd like to leave the original key in the table, but to no longer be an identity field. Is there a way to do this using T-SQL? I tried the following, but it's not removing the...

What about folders in the Start menu for All Users? I have one there now that was added by my company as part of our standard image, and it uses a different icon instead of the default file icon. Does this mean that it is a program group? And if it is, how can I change the icon used for a...

I have a small vb program in which I create a folder in the Start menu and move some files around. Is there a way to specify an icon for the folder that I create so that it does not use the default folder icon but one that I specify? I don't care about the icon for the vb application, I just...

I have SQL Server 2000, while other people only have MSDE. We are trying to detach a db from 2000 and attach it (using OSQL) on another computer that only has MSDE. We're getting an error that says the header information is not recognized, which seems to indicate a version problem - is MSDE not...

I'm pretty new at this, but I want to create a program for distribution that will create a shortcut to MS Access on the desktop, and I want to include in the target a command line switch to force it to use a specific workgroup. I have come across some examples of code that use API calls to...

The switchboard idea sounds good, but won't work for me. I've got people in remote sites with local databases. They need to be able to get into all of their databases (that use the particular workgroup file), both 97 and 2000, and because of the workgroup information resetting by Access 2000...

What's going on is we are using Access 2000 and 97 (2000 for new databases, and 97 for older ones). I've joined the permissions.mdw file (that has our application specific permissions) to both WRKGADM.exe for Access 97 and Access 2000. Because we sometimes have to go back and forth (while we are...

I took over management of a number of Access databases for someone, and I want to get rid of the permissions system that he used. Is there a way to disassociate a workgroup information file in Microsoft Access but still be able to get into the database? I was able to clear the password (for...

I have a set of applications that use an ActiveX control. If the users do not have the ActiveX control, can I copy the control files to their computers? Or does this cause a licensing issue? They have a licensed version of the software we are using (Microsoft Access), but the install we used was...