Search results for query: *

I am having trouble while running a query which has two linked tables from SQL Server database. This query was working fine and suddenly, it start giving following error. "3146 - DBC - call failed" [Microsoft][ODBC - SQL Server Driver] Timout expired(#0) The query is; INSERT INTO...

I have a linked table from SQL Server 2000 database and a empty table, in Access 2000 database (.mdb file). There are around 170,000 records, which I am trying to insert from Linked table (SQL Server 2000) to a empty table (in Access 2000) using append query. When I run Append query, it gives...

PHV From VBE - Debug > Compile this way I tried and it finished without any error. But, when I come back to database window and Trying to split the database, it gives me same error message

Hi PHV, I really not understand, how do I do this? Can you give me more specific detail, if possible please?

It is from the database windows - using TOOLS - DATABASE UTILITIES - DATABASE SPLITER

I am trying to split the database (basically pull out database from other objects of mdb file and put as backend) by using DATABASE UTILITIES under TOOLS. But I am getting following error. Does anyone know how would I fix this error or what should I do to split the database please?? The error...

I am trying to extract data from a table where, I need final out put as summary of a field. I am using Crosstab query and pivoted by Duedate field. The date range is entered by user everytime. This crosstab query is giving me detail amount - not summary. So, I created another query where I used...