Search results for query: *

Thanks to earlier responses, I already have useful Update Query routines to, say, fill every blank cell in a table's field with a value. They run very quickly, so now I'd like to use UQ routines instead of Find & Replace in Table view (which, with my database's 1.4 million records, takes ages...

Anyone know whether it is possible to install Access 2000 (from Office 2000 Pro CD-ROM) on my remote Web server using FTP or whatever? And if so, how's it done? Many thanks.

Anyone know whether it is possible to install Access 2000 (from Office 2000 Pro CD-ROM) on my remote Web server using FTP or whatever? And if so, how's it done? Many thanks.

Using SQL 2000 on a W2000 Web server with 1512MB RAM and a Pentium III 933MHz single processor, searching a specific field of the 1.4 million-record database presents results in from 8 seconds (where each field cell contains just a short alphanumeric string) to timeout after 70 seconds (where...

Having successfully used update query routines from Jeff Bridgham and Joe Miller (Thanks guys!) to fill blank cells with a common value, it occurs to me that technique could be used to modify existing cell contents much faster than Find/Replace in Access 2000 - but I can't figure out the syntax...

The .asp-based shopping cart sofware I'm using does not permit use of the Access 2000/SQL 2000 upsizing wizards but provides two scripts - convert.sql and sqlserver.bat. The first is said "to recreate the database. It can be used with ISQL or Query Analyzer to build the database". The...

Forgive such a fundamental query from an SQL newbie but I'm really stuck. The third party, ASP-based cart software I'm implementing draws on a 27-table database. Upsizing using the Access 2000 wizard is not permitted, say the cart authors, because of its particular construction. Instead, one is...

Apologies for my confusing terminology. I meant "single (text) column".

Is there a way of retrospectively filling any empty cells that may remain in a single (text) field of an Access 2000 table - say an X or even a few words? Many thanks in advance to anyone who can help.