Recent content by wfweirich

This is good stuff, and I will hang on to it. But, I need to see how output parms are handled, not a record set. Thanks. wfw

I have a stored procedure that I would like to run within an Excel macro. The usp_ has input and output parms. I currently have multiple examples of running usp_ to bring back record sets to .Net apps and Excel. I am struggling with the code needed to establish parms going in, then using the...

I have a web page that includes a datagrid. A button at the top of the page allows you to add a new record. When pressed a new record is added to the database(SQL Server), then the page is re-displayed showing the previously existing records and a new one. All entries in the datagrid are...

Thanks for your response. I'm really not sure what the .MDW file that the division developers were signed-on with looks like. My fear is that they did not open the .MDB with the correct .MDW. They may have been using the default (SYSTEM.MDW), completed their application changes, then created...

Our plant uses a QA tracking application that was created and distributed by our division headquarters. The database is written in Access 97. The Db is split with a .MDB as the back-end and a .MDE as the front end. The Db has Users and Groups with all the permissions tied to the groups. The...

I have a critical application here at work that was created using Access 97. This is a shared system which is why we are unable, at this time, to convert to Access 2000 or SQL Server with an Access front-end. At times we are asked to export raw data into Excel. Unfortunately, our tables...

Your 2 cents is very helpful. Thanks for your quick response. I like code that I can actually get my hands on. Programming with recordsets provides code that can be used over and over. I have done this many times with Access Dbs, but this time I am attempting my first shot at connecting to...

I am trying to create a form that includes a drop down for record selection. I have added an ADO Data Control to my form because I like what I have read about these vs. other dsn connections. I was able to hide the ADO Data Control and use it to populate a DataCombo control, but when I try to...

I am attempting to create a report that will print out on a special form. I need the data to print at the very top of the page. I have gone into "Tools", then "Options", then "General" and set all the defaults to zero. When I go into page setup, I can still only...

I don't need password recovery software, I already have access to one of those. I need something to run through an Access database and simply remove all of the permissions. It would be nice if it would return it to a db with default security. Thanks for the suggestion. I'll keep looking. wfw

I have tried the wizard, I get "no permission to import/export". It does state that in order to de-secure, that you must be a user in the "Admins" group within the workgroup information file that the db is secured with. This is very frustrating. Back to the drawing board...

I tried it, the back end converted just fine. The front end hit me with "no permission to convert this database", immediately. When you look at the permissions, all of the object owners are coming up "unknown". The user "Admin" has no rights, which goes against...

I have an Access 97 database(actually 2, cause it has been split) that I need to convert to 2000 and clean up some bugs. I have tried to create a new empty 2000 db and import into/export from old, in attempt to get all of the objects. I keep running into permission problems. The old db only...

I am working with an Access 97 database that has a security piece on top of it utilizing a workgroup. Some how the file has been corrupted and no one can access the data. I have tried to create a blank database and import the objects from the troubled database and I get stopped because of...

I have just finished creating a visual basic form that allows the user to enter a lot number and number of labels to print. This process then looks for an entry in an Access table and generates the label(s). On the input screen, there are 5 fields: lot prefix(2 numeric), lot number(3 numeric)...