Search results for query: *

Is there a maximum file length on importing an external file into access, I am having trouble defining fields after 500 charachters, is this a limit in access?

I have an Access 97 Database (FE) that has a 97 (BE) on a server. In the database there is a procedure that tra sfers the results of a query to a text file (in a designated folder on the server) for a mail merge. DoCmd.TransferText acExportMerge, , "qryACK&quot...

I just got a new computer that came loaded w/ Office XP. Our Department is running Office 2000 and 97. I have created a database in Access 2000 format, but am unable to create a 2000 MDE file. Is there any way to do this without converting to Access 2002 first. If not is my only option to...

I am trying to launch a Dos Batch file from access which ftp's a file from our mainframe to a text file on a server. I have a line of code that runs the batch file, Call Shell("batchfile", 1), this runs fine, but the problem I am having is that once the batch file is done, I then...

How would I allow a user who has already entered data for a new record on a form exit that form without saving that record?

I have a database that has an SQL Server backend and MsAccess front end. I load the front locally to the users PC's. In the front end when I make the ODBC connection should I save it as a File or Sytem DSN on the server? I am in the process of setting up an auto update feature on the Front...

I am trying to create a procedure to allow me to create one complete table using data from 2 seperate tables. I am able to do what I am trying to do but I feel I am being kind of repetative. I need to save this process as I will have to do this on new files periodically. I have been creating...

Our Department has installed the latest security patch for Outlook, and I am developing an application that sends emails from MS Access using the Send Object Method. We would like to be able to automatically send these emails from MS Access without needing any user intervention. Since the...

Our Department has installed the latest security patch for exchange, and I am developing an application that sends emails from MS Access using the Send Object Method. We would like to be able to automatically send these emails from MS Access without needing any user intervention. Since the...

I am working with an existing Access Databse, to try to enhance performance. I have copied the main tables from Access to SQL-Server 7.0 I have then linked them to the Access from end in place of the access tables. When I attempt to open up a form in Access (with a number of subforms on it...

I have the following stored procedure that when I run it i keep running out of locks. I can't figure out a way to batch it so it does a managable # of records at a time, I am dealing with about 3 million records in this table. There is no Key field. CREATE PROCEDURE sp_editimportdata AS...

I have a table of data with about 3 mill records, all are text fields. I want to move them into an empty table with the correct indexes and primary keys. I need to transform some of the data on the insert. I am using the following code.CREATE PROCEDURE sp_editimportdata AS insert into [sales...

I am trying to link an Access Database to some SQL tables and I need to translate some code into a stored procedure. I am having problems translating the I statements into a proper t-SQL format. I am stuck on how to do and update and set statement with an IF THEN or CASE statement embedded...

How would I rewrite this code using a variable for the #temptbl I am creating? CREATE PROC proctestSearch @name varchar(61) =null AS Select * into #temptbl from Maintbl where myname = @name Thanks, Phil