Full-text Search with ADP to SQL Server

[codecontractor]

I have a database on a hosted SQL Server. I modify the tables on my local machine in a regular MDB file and upload new versions regularly through an ADP connected to the server. They recently set up full-text search for several tables.

Before they set up the full text indexing I would simply upload a new version of the table with a different name and then rename both tables. However, now that the full-text indexing has been added, that technique no longer works. As soon as I execute a query that uses CONTAINS(... I get an error saying that the table is not full-text indexed. If I swap the tables back, then it works again.

My host said that the full-text indexing would take place at midnight each night, so I left the renamed table on the database overnight, but I still get the same error.

So, I guess I'm looking for a way to update a table using an Access Project interface to SQL Server without blowing away the full text indexing...

Thanks,

-Ben

 

[cmmrfrds]

If you want to stay with renaming the table then it will be necessary to enable the full-text searching afterward. Talk to your dba. Example on setting up full-text search.

http://www.sqlserverfaq.com/content/kbase/store/Tutorials/61.htm#_Toc514412924

Otherwise, you will need to delete and insert records instead of renaming the table.