Recent content by phweston

Hi, I need to create a contraint to check for CHr(10) and chr(13) at the beginning and end of a text field. I was given this code to use, but I get the error message "'chr' is not a recognized function name". Using the following example: The Table name is CustomerName The Field Name is...

Works great. Thanks!

For starters, we have this code in SQL. We are trying to convert this to Access VBA. The purpose of the funciton is to scramble names to make this unreadble. The function will convert a name by taking each character and moving it up one in the alphabet. For example A would becomie B in the...

We have a SQL table where we want to set the default value for some of the fields = 0. This is too avoid having a null value in the field when there is no value for these fields. These fields are set to the data type "money". When we append records to the table(using MS Access as a front...

We are all set up using Windows authentication, including myself. The users with the read/write priveleges are set up through a Windows group. I am set up as an individual user in SQL.

Hi, I am currenlty set up as a Db_owner on a SQL Server 2000 DB. I have a windows user group set up datareader and datawriter as well, where they do not have permission to delete data from a 4 or 5 tables in the db. They have full permission on the remainder of the tables. For some reason, I...

Is it possible to set up a table in MS Access and making it read only without going through a form?

I am in the process of setting up a SQL database, and need to set up different users. Is it possible to set up a user who would have limited Admin ability, such as the ability to change table set up (new fields, delete fields, etc.)but not be able to actually make changes to the data. This...

I am in the process of setting up a SQL Server Database with a MS Access Front End. The problem that I am having is that when someone else is logs into the database, myself or someone else gets a Connection Fail Error and needs to re-link the tables using the DSN I set up. Once I do that, the...

I am in the process of setting up a SQL Server Database with a Access Front End. I have 4 people who are going to share this database. I set up the security so that each person has his/her own log inand Password. We did this to because we have Audit trail triggers set up to track any changes...

Thanks as well. I usual break out my code into separate pieces if I am having an issue with. That way, I can find what the problem or issue is.

Thanks. This is what I came up with, and it seems to work okay. ALTER TRIGGER Customer_Name_Update ON Table1 for update as if update(Customer_Name) UPDATE TABLE2 SET TABLE2.CUSTOMER_NAME = INSERTED.customer_name FROM INSERTED WHERE TABLE2.CUSTOMER_CODE = INSERTED.CUSTOMER_CODE...

I am putting together a trigger to update 2 fields in a second table when a field is changed in the first table. The Trigger should work like this. The user updates a customer name in Table 1, and the customer name is updated to reflect the changes in Table2. In addition, the trigger should...

Thanks. The database we are using is a Back End Database, and the Front End(in Access) is already set up with these field names with spaces in the name. All our queries are set up using these Field Names, so we are debating whether or not we should start changing stuff.

Hi, I am in the process of starting to switch over an Access Database to SQL Server. The Access DB was not origanlly set up by me, and there are Field names with spaces in the actual Field name(Example: Customer Name as opposed to having Customer_Name or CustomerName). I tried importing the...