Search results for query: *

I am on access 2000 and I need to convert the database to a prior version to send the database to my client. But when I run the convert database to prior access version (tools->database utilities) I get the following error: "Invalid field data type" , "some errors happend during...

I have been using a macro with the Transfer text action to export data. I had a problem with my machine and it got formatted. Now when I attempt to run the macro I get the following error :"The data being formated does not match the described in the schema.ini file." As far as I...

I have been using a macro with the Transfer text action to export data. I had a problem with my machine and it got formatted. Now when I attempt to run the macro I get the following error :"The data being formated does not match the described in the schema.ini file." As far as I...

I have set-up one System-DSN with a generic data source name. I hoped to just override the database name to point to the database I would like to access at that point in time. But I now discovered that when you link the table, the table properties store the database in the description...

I have set-up one System-DSN with a generic data source name. I hoped to just override the database name to point to the database I would like to access at that point in time. But I now discovered that when you link the table, the table properties store the database in the description...

Using ODBC I am connecting to an external system which does not store the client initials only the "given_names". I would like to write a function that will return the initials. The other painful method is to extract them in query one initial at a time but this it time consuming...

How can I use access to FTP extracted files?

How do you set defaults for parameter based queries? For example a date parameter with a default of "01/09/2000"

Instead of using a parameter query I used a form to gather the critera for a query. My problem is : Macro line 1: "OpenFrm" - The macro opens the form and a button on the form opens & executes the append query. No problem here. Macro Line 2: "OpenQry" - should execute the...

I would like to know if it is possible to concatenate fields in access and retain there field size. For example: Product_code length = 10 value = AIMS Language length = 3 value = AFR When I concatenate the fields in the following manner: [Product_code] & [Language] I get:- "AIMSAFR&quot...