Search results

i have 2 mdb and both mdb have table link in one of the mdb , they had a link to dbf (paradox) and they have lot of queries and reports created. Now the functionality has changed so we have created a access table and need to replace the dbf with the table. The problem is we need to retain all...

an import is done from access to excel using docmd.transfersheet DoCmd.TransferSpreadsheet 1, 8, "dbo." & QuerySending, SavedName, True, "InputRange" In ADP the error displayed is runtime error 3274 and in ade it displays "The file is not in recognizable format" This happens for only one...

i have an mdb with lot of tables in it. But now since the old mdb is not so flexible the way user wanted, the requirement is creating a new mdb with different tables some of them matches the way the old table but some it is combination of fields from more than table in old mdb. For example...