Search results for query: *

There is no "save password" option on my Access 2003 when I create a new linked table. I did however find out that if I use a file data source ODBC instead of a system one, it doesn't prompt me for the password after it's initially set up. So I think I'll go that route for now at least. Not...

Where does it present you with the option to save the password? I did not see it while I was setting up the ODBC connection or when I was connecting to the linked table. Please let me know. Thanks.

Hi, We are currently linking an MS Access 2003 front end database to an SQL server 2005 backend. When using SQL Server security and creating a dummy login on the SQL Server for all users that use the front end system to connect to the backend db, I'm getting a login box in the Access database...

Thanks again! I can join the two of those together to get what I need.

Thanks. Is there any way to display the data stored in the description property for the fields and tables as part of the above?

Hey all, Is there an easy way to generate a report listing all my database tables, fields, data types, and the stored table/field descriptions alike the metadata reporting features in MS Access? I know I can generate the diagrams with this information, but they can get a bit hairy to look at...

I get the message 32 times. All the tables in the db are linked since it's a front end. In total, I have 80 tables. 12 tables come from one database. The other 68 are from another database. So unfortunately I'm not sure if it has anything to do with the links at all at this point. Any...

I don't think it's the batch because if I directly try to access the database FE file on the user's machine, I get the same error. The batch is simply there to check for front end updates so the user doesn't have to manually do anything.

When the FE starts up I have it set so that they do not view the database window and a splashscreen form that's saved in the database displays on a timer. Once that form closes, the switchboard displays. I think it has something to do with the links to the tables on the backend, but I can't...

Hello, I have an issue with my Access front end databases. A little background. Workgroup security has been implemented. The front end client is an Access 2003 application that sits on the users machine. The user runs a batch file on their desktop to check for updates to the front end and then...

Hi, We are in the process of trying to set up a transaction log shipping operation and are currently having issues with the copy job. The primary server backup job runs fine and then the copy job which runs from the secondary(copy) server is not able to copy the backup file from the backup...

Thanks!

We have a test server that I would like to use as both a "mirror" for our live databases and at the same time on this test machine, I would like to have an instance that would be used specifically for testing of new code. Am I able to do this and how does one go about installing a separate...

Thanks everyone. Still haven't gotten all of the different formatting functions down in SQL yet. This works great though. Thanks.

I'm trying to display in a field the previous month. Since it's currently May, I want the field to display April. I can get the field to say '4' but can't figure out how to get the month as a char. Using Datepart DatePart(Month, Getdate()) - 1 <--Gives me '4' Using Month Month(Getdate()) - 1...

I realize that now, Thanks. Can't format it on the presentation layer since depending on other data - This percentage appears as part of a text string. We handle most of our complex formatting on the db side since if a change needs to be made, it's quicker for me to just go into the view and...

Is there a way to format a floating integer to display as a percentage inside of a query? I have the number stored in the table as 0.75. However, I would like to display it inside the query as 75.00%. Is there any way to do this besides converting to decimal(18,2) and multiplying by 100?

Thanks! That worked perfectly.

Hello, I have a field in a query that I want to either show a dashed value '---' or a date. So I use this: CASE WHEN [RegStatus] = 4 THEN '---' ELSE [Step7Date] END AS Step7 Problem is, it tells me "Conversion of the char data type to date time has resulted in an out of range value". If I...

Is there a way to do the following in excel through a formula? For each value in Column A, I would like to find the maximum value in Column B. So for example: A B Monday 10 Tuesday 15 Monday 20 Wednesday 5 Monday 15 The formula would return...