Search results for query: *

I saved my db on a cd-rom, and I copied it to another computer, but now it says it is read-only. I tried even making a copy of it, but it still says read-only. Is there a way to make it not be read-only? Need help. Thanks Ray

What is the best way to link an access db to a dreamweaver driven web site, so my online forms results are written to the access db? Can some one give me the steps in completing this task? Thanks Ray

I want mutiple poeple to be able to use the same database, but how can two poeple make chnges to content within the same table. We have a database that stores all of our contacts. I have two columns one that says bad mail and do not email. I need to go in and check off those records that...

Does anybody know the best way to link an access db to a form within FrontPage?

I have a list of accounts that I would like to mark HTML_Unable. I have a field called Html_Unable that uses a yes/no data type. How would I create an UPDATE SQL statement that would allow me to find all contacts within a specific account and set their Html_Unble value to yes? Any direction in...

Below is the code that I'm using: SELECT First_Name, Last_Name, City, Postal, First(Do_Not_Solicit), First(Account), First(State), First(Country), First(Email), First(Bad_Email), First(Bad_Email_Host), First(Do_Not_Email) FROM [marketing lists] WHERE (((Do_Not_Solicit = no)...

I would like to take a form that people fill out online, and all the results go into an access table. Within this table will be people that we have sent an email too, so I would like when a person enters their name within the form that if they already existed in the database all the fields that...

I have records within a table that I know have duplicates. The problem is I may have two records that are identical except one is in upper case and the lower case. I've been just doing is the following: 1. I make a copy of my table (structure only) 2. I set Frist name, Last name, city, and...

I'm trying to create a starter query, so that all other queries that I make in the future would use this query but with some addtional criteriab. Here is what I want to include within my starter gtoup: Following are the columns that I do not want null: First_Name Last_Name Account Address1...

I'm trying to create a starter query, so that all other queries that I make in the future would use this query but with some addtional criteriab. Here is what I want to include within my starter gtoup: Following are the columns that I do not want null: First_Name Last_Name Account Address1...

I have columns that use the yes/no datatype, so in the table it puts a check in those that are yes. I would like to create a select statment that can gives me a query results of just those records that have a check within one of these columns. But how?

I would like to find all duplicates and move only the first instance of two similar records to a duplicate table. What query or code will I need to do this? Thanks

I would like to only get back distinct rows but one of my select columns will prevent this from happening because one of my columns that I would like to include in the select is notes. Notes represents what list it was imported from. This means I may have two John smiths from the same company...

Hi, I have an excel file that I wish to import into a new table within my MS 2000 db, but I would like to keep the same order of the records from the excel file to Access. Whenever I try importing it, I notive the records are not coming in the same order as they were in the excel file? I...

I have a column which is the first name of contacts, but some of the names include their middle initial. I would like to move the middle initial characters to the middle initial column. There is alway a space between the first name and the middle name. How can I globally do this? Thanks

I have two tables. I have a list of accounts that I would like to look for within one table, and any contact from these accounts I would like to move them to my second table. How would I do this? Need help Thank you

I would like to create a query in the query gride view that contains the following criteria: Contacts that come from specific accounts, titles are blank, email address is blank, in the US, within MA or RI or Part of CT (zip codes that start off with 060, 061, or 062). How would I create this...

THe message that I get when I try to convert my 97 db to 2000 is "There were compilation errors during the conversion or enabling of these database." I also compress the 97 db before converting it.

I tried to create a query within Access97 that would give me all contacts within a list of accounts. I used the like command and the (*) wildcard for each accoint name e.g. like "aventis*" which I listed all 26 accounts that I wanted. When I tried to run the query, I keep getting a...

I was doing a query to find all contacts that are from a list of accounts. There is around 30 accounts that I'm looking for contacts that are from these accounts. I keep getting "Query is too complex". WHy? Need help asap. Thank you