Search results for query: *

The other server is a SQL Server 2000. In SQL Server 2000 you can have several "instances" of SQL Server on one server. So that is not actually the domain name, but the name of the server, and that instance of SQL Server 2000 is the NAICT011/MFGSQL. For posparity sake, the final...

I have a SQL Server 7.0 database I'm trying to get to talk to a SQL Server 2000 database. The communication actually needs to be 2-way in the end. I've been trying to use the sp_addlinkedserver stored procedure in conjuction with sp_addlinkedsrvlogin. So far, her is what I have: exec...

OK, please forgive me as I do not know a whole lot about networking. This is not my area of expertise, and somehow I was sucked in to fill in for a guy on vacation. I have four different PCs, all on the same network and setup the same way (i.e. logged in the same username/password and into the...

Is there a way that once the user has selected a certain maximum for the list box, to disallow them to select anymore? I would like to limit my user to be able to select a maximum of 10 items, with multi-select set to extended. Any help is greatly appreciated, thanks! Miriam

OK I fibbed in the previous post. I think that I accidentally did have the "allow save password" on or something. Anyhow, I went ahead and implemented the idea to have the dummy username and password. However, my recordset is not updateable when I do this. Here is my code to start...

OK, I later found the solution. The CurrentProject.Connection.ConnectionString property gives the password. So when I create the new connection for the transaction, I just need to add this ".ConnectionString" to the end and it works! Miriam

That is a very good idea. I have four different sets of permissions (with two more coming later). It could get a little messy figuring out who has what permission, but it is better than nothing! :o)

My problem is this: I have an Access Project connected to an SQL Server. The user is required to login when the project is opened. Since the "allow saving password" is unchecked in the connection window (because I want users to have to login), then the CurrentProject.Connection does...

OK, I doubled checked just to be sure, they are all the same height and and are lined up properly. So I guess that's not it... Miriam

Thanks, but that isn't it. I just checked, it is none. Miriam

I have an Access report. I print several fields out that are the result of a query. It looks something like the following: fld1 fld2 fld3 fld4 fld5 fld6 fld7 fld8 All the fields are bound text boxes. I have the can shrink/grow properties set to "no". Everyone once in awhile I...

Oh that works wonderfully! Thanks! :o) Miriam

I know this thread is old, but I am having the same problem as Walt (i.e. the licensing problem). I have no idea what the problem is, and can not seem to find an answer on the microsoft knowledge base. Does anyone know what the deal is? I have Access 2000. Is there something special needed...

I'm sorry if this is a repeat question, however I searched through the forums and didn't really find the answer I'm looking for. I have an access project connected to an SQL Server 7.0 Database. I have approximately 25 forms built so far. Not all of them are fully functional yet. Yesterday I...

Oh, I forgot to mention I did the debug.print right before the assignment. I don't have a beforeupdate event, which is the crazy part! This is suppose to be in the "afterupdate" event!

No, I have debug prints before to print out the value, and make sure that h1name is set properly...and it is. Any other ideas? Miriam

Hi all! I am trying to use an option box to fill some boxes below. My problem is that whenever I click on any of the radio buttons, I get the following error: Run-time error '2115': The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing Microsoft...

OK, I'm having a bit of trouble. I'm using MS Access as a front end for my SQL Server. I'm using stored procedures for all my queries. I have a stored procedure that takes in a list of IDs and some other information, puts the records into a temporary table, and then returns a recordset with...

Thanks! I'm going to give it a try. If I have problems, I'll be sure to let you know. To answer your question, yes they do have a relationship. As my team leader always says, "Sometimes you just need a second set of eyes!" This solutions seems to obvious now. :o) Miriam

I have a subform. In this subform, I would like for some information to show from one table. I also want some fields from another table to be updateable. I had the idea to put all the information into a single recordset, but I couldn't figure out how to combine it all. It seems to me the...