I have a 98 machine where I have a shortcut to a dialup connection that I created. When I invoke it I go right past the opportunity to enter a password, it attempts the connection and I get Error 691 incorrect password.
I need to get to the Connect To window where I'm prompted for a...
I have a query that, when the results or the query are displayed in Access, I choose 'Save As/Export' to an external file, than specify .xls as the file type to export to.
I get an error message "The Microsoft Jet database engine could not find the object 'MyQueryName'. Make sure the...
I have a button that runs a query that dumps the data in my tables to an Excel file. When the data in the tables is modified and the query is run again, the Excel file does not reflect the changes made in the table. I thought this would occur in real time, i.e., change the data in Access and...
I have a user who has a doc created using the newsletter template. When doc is printed the entire body of text appears underlined when it is not actually underlined in the document. Print preview shows the text as not underlined. My user would like this doc to print without the text...
I have an end user who has a dial-up network connection that goes directly to the 'dialing' window bypassing the 'connect to' window where username and password and phone number are asked for.
I created a new connection for him from scratch thinking that the 'save password' box might have...
Is there a way to save the query once I've added that line of code? If I X out of the window and re-open the table, the line of code is gone. I'm at a loss as to how to save it.
When I attempt to open a table with return all rows in Enterprise Manager, I get the following error:
An unexpected error happened during this operation. [MS Design Tools] - Query Designer encountered a MS Design Tools error: ODBC error: [Microsoft][ODBC SQL Server Driver][SQL...
Sorry to bother with such a simple question, but when I open a table return all rows in Enterprise Manager, the sort ascending and sort descending buttons are grayed out. Would simply like to sort my table in ascending order. Have looked through BOL and don't see an obvious reason why these...
I have a table set up with a text field as my primary key. It is an Access front with a SQL back.
My impression was that my user would get an error message if they tried to enter a duplicate entry in a primary key field. I have looked closely at the entry to see if there might be a space, a...
I have a report based on a query. If I run the query I can choose through Office Tools to export the data to an Excel file. What I would like to do have a command button on a form that would either run the report based on the query or just run the query, and have the resulting data export into...
Thanks for your reply, I wasn't able to get back into this until this morning. It would appear the group by function is largely responsible for the pagination. I'm going to have to play around with it and see what I can learn. Thanks for your help.
This is a pretty basic question but I've had little success finding an answer in FAQs here or the books I have. I have a report header and I've set Force New Page before section in the hopes that I would have the header at the top of each new page. Unfortunately instead the header is printing...
I just went through this myself and while I'm not an expert I will tell you what I found to accomplish this on clients within our WAN. I got the same ODBC call error.
In Control Panel ODBC data sources have to have the SQL driver loaded and configured with your database as the default database...
Well, I figured it out. I didn't have the Inventory_be file on the client along with the .mde. Both are necessary on the client end after the database has been split. As soon as I moved the _be file to the client machine, it worked fine. One would think I would have been able to figure that...
Another interesting twist - I marked the folder on my hard drive that I have the database saved to as a shared drive on the network. My user went to it and tried to open the .mde directly from my hard drive. Got the same error message I mentioned above.
One thing I noticed was that when I...
Other than that path being it's point of origin on my machine, no, not that I'm aware of.
The interesting thing is that even if I create a folder c:\ets on his machine and rename the file to exactly what the error message says it can't find, I still get the same message.
Yet if I make a .mde...
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.