Search results for query: *

Thanks, Just read the article and realise that short of migrating the BE to SQL Server Express, i'll be moving in circles. I have SQLEXPRESS (2005) instance running and wish to migrate development to that engine. Could you post a routine to create and save records using access forms with...

Actually all users have full permissions on the back end folder as advised in similar threads on this forum. The default open mode is shared. I need ideas on how to allow multiple users without reduction in speeds on the front ends.

Thank you but the purpose of splitting is to improve multi user experience,how best can one prevent the first user from locking out others? Can Disconnected recordsets help and would this close the lock when the connection object (ADO) is closed? Please point me to a practical approach for my...

I need help to prevent lock file from being created in the back end folder when users open forms from the front end copy on their desktops This back end lock slows down all users. Thanks.

No, but the whole file has comma separated values!! and the source application (legacy) has only two output formats, CSV and SLK .. I have no experience with BCP -it could be an alternative but when I used the BOL example, the conversion fails with an error about the record delimiters (CR/Lf)..

Hi, Transfer from CSV file to SQL table using DTS wizard fails SQL complains about delimiters, but when the file is first coverted to "txt" using MS Word 2K then the transfer works! Please advise -need to automate and eliminate conversion first to word OS - Win2K server SP3, SQK 2K...

I need a method where I can insert e.g 100 rows into an existing table but with a new serial number for each row. Kindly advise.

Hi all, I need code/algorithm that can return a list of 30 random numbers from a table with a column of integers (eg 200) thanks.

Hi, Try the Access menu- Tools->Options->Datasheet Uncheck the option labelled "Show animations" and try again.

thanks collegues, I have to look into other techniques .Could anyone list for me sites where I can get free taining on designing help systems.

How can I create a context-sensitive help system for an Access application that stores the help topics and details in the same application.mdb?

A collegue converted from A97 to A2k and lost some data of numerical type. Is this problem prevalent when you upgrade? Is there a list of pre-conditions before you convert? Have the Microsoft people acknowledged any data losses when upgrading? thanks.