Search results

I have two tables (same data but slightly different attribute structure) with a one-to-one relationship (the join field is "ID"). There are 69 matching records in these tables. How can I delete these matching records from table A, while leaving them alone in table B? I'm confused because I...

I have a query that I manually export as a dbf file (i.e. right-click and export). I manually export because I export to a unique directory each time. However, fields in the query that are of type string always get exported with a length of 255. Is there anyway in SQL that I can set the width...

If I import a text file and append it to an existing table (using the TransferText method), is there a way to undo the append if there are errors? For example, if a user tries to import a text file with an incorrect structure, sometimes data will still be appended to the existing access table...

I'm new to programming, and was trying to copy some code from a text book using Access 2000. Dim dbs as Database Dim rst as DAO.Recordset When I try to write this code, there is no "Database" class that shows up, nor is there any "DAO" "dot" anything, which of course leads to many errors...

Is there a way to loop through each table in your current database, and check each name? The reason I'm trying to do this is to see if there are any import errors from a "texttransfer" method I run, which appends data from a text file a user selects to a table in my database. I know that if...

Is there an easy way to import text files into a database? I've seen some sample code using the "transferdatabase" method, but the list of possible "database types" doesn't seem to include text files. I'm just a newbie so if anyone can just point me in the right direction it would be most...

Is there any way to customize Access to disable query pop-up messages, such as "You are about to modify 400 records..." or "You are about to delete a table..."? Is this possible either at the application, database, or macro level? Thanks in advance.