IFELSETHEN
Thank you VERY much for the response, your code does what I was looking for, except it is reading the entire text file as one line for some reason, am I doing something wrong?
Thank you again!
I'm not sure what it is that you want but, from the sound of it, you want the user to be able to copy files that are on your local drive on to the server from the user's desktop correct? If so then you will need to make sure your directory is shared and that user has permission (or users) once...
I am reading a text file into a listbox and I want every line of text show except for the very last line in the text file, what I want to do with the last line is this: I want it to read it in to memory (for later use) and then delete it....after I am finished writing the rest of my text back to...
Just last week I was having the same problem while trying to connect to a 91b database.
A few things to check/try (Assuming you are using the SQL92 Merant drivers):
Make sure you have a broker working and that the broker is in your services file (both on the server and on the client).
A...
carrr,
Thank you for the reply, as dumb as this sounds, when I created the new databases, I was clicking right past the username and password fields!. Sorry to trouble you but I appreciate your quick response :)
I am using SQL server 2000. I want to create a user account with the same permissions as the 'Sa' account. I have done this, but here is where the problem comes in: I create the account in Enterprise Manager and all is well, UNTIL a new database is created...then my newly created account does...
Sandy,
Thanks for your reply, however, I am getting an error after cut/pasting your code. It gives me a "variable not defined" error. I am hoping that you might be able to help explain this for me.
I created the query using SQL, it works fine when I run it seperately, but for some...
I have a form with a combo box and a text field, after the user makes a selection in the combo box, I would like to have the text box show the results from a query I made that runs off of the combo box selection. Is this possible at all?
While not being very talented in Access, I have run across something like this before. When setting up the switchboard, you will have the option of which form you want to open as well as how you want it to open, such as open in add records, edit records, etc and etc. By opening the form in edit...
I have two databases, I need to compare them. The problem is, they are two different servers, right now I am copying one of them to the main server and then running my comparison. Is it possible to compare them in their native environments? I'm not sure how important this is but I am using SQL...
Pezamystik,
Thank you, the code works perfectly :)
You wouldn't also happen to know how to create a user account would you? If not, I appreciate the great help you have already provided.
Thanks again,
Leon
Hi all,
I am currently working on a project with access 97 and I want to be able to change the database password (old password being provided) using code. I am hoping that someone will be able to help me as I am VERY new to access and all help is appreciated.
Thanks in advance,
Leon
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.