Recent content by ibwebn

From what I can tell, to remove the special characters you must first upload the file. This will give you the cffile.serverFile variable containing the name of the file you uploaded. I'm not sure if you can change the value of the variable. You might be able to. But what you can definitely do...

I figured out my problem with linking the table. I had two columns that were using Bit variables in SQL Server. For some reason Access did not like these Bit variables. Once I removed the columns with Bit variables everything worked fine. I was able to use Access to link to a SQL Server table...

Unfortunately SQL Server Views are out. The user needs to use Access. One of the things that is confusing me is I do have a primary key, I do have a unique index, and I do have update permissions on the table. For some reason it still does'nt work.

There are no forms in the Access database file. The user will only be using Tables view. The user needs to make quieries to the tables. The queries are simple. They only query one table. I would use and Access Project, but I can't get it to make a query. I try using the Views section to...

I'm using ODBC in Access 2000 to link to an SQL Server table. When I try to edit existing data in the SQL Server table I receive the following error message: This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the...