G'd afternoon ahmed!!
The error you get is because you need to initialize one or more of your variables before you use them. Something like this:

Global db As NEW Database
Global vn As New...

G'd evening Dru!
The sintax seems to be fine, but we don't know the values you are sending nor their types. I would sugest to store (just for tests purposes) the sql string in a varible and then...

G'd evening Sham!
Here you may read all about adp's Choosing and Using MSDE 2000 as the Database Engine for Your Application...

Hi Clonman!
By this time i hope you have found the way to stop the security alert from access, but for other readers:
In the main menu --> Tools ---> Macro --->Security
In the popup window select...

G'd evening helpwanted!
Requeriments to be in the 1NF are:
1. The rows are not ordered.
2. The columns are not ordered.
3. There are no duplicate rows.
4. Every row/column intersection contains...

G'd evening!
In case you still need to change the table's column type from T-SQL , the sintax for MS SQL is:
ALTER TABLE table ALTER COLUMN column_name new_data_type
Ex.
ALTER TABLE MyTable...

G'd evening All!
Manish, in my opinion SQL is not designed to work without a Front End, so, we can't expect sql to have all (same) functions that almost any other OOL have, insted we should take...

G'd evening Jared!
At a glance the problem might be in the WHERE sintax. What i left in blue is not valid in MS SQL:

WHERE ( t_form_data_fish_hd.form_key *= t_form_data_fish.form_key) and (...

G'd evening arron!
For your first question the short answer is Yes. That's all what you have to do, the same as in win 2k server.
For the second question...it is hard to say. First i would like to...

G'd evening pramodDR!
It seems like the problem is not with the sql server, but with the domain controller, see or ask which property.
Good luck
Estuardo

G'd evening kitkatsavvy!
I'm not aware of any SQL functionality that you can implement to block an IP address, nor i have any experience in web programming.
With sql you can limit the privileges of...

G'd evening Kate & sqlchopper!

Also you can donwload the BOL from here (http://www.microsoft.com/downloads/details.aspx?FamilyID=a6f79cb1-a420-445f-8a4b-bd77a7da194b&DisplayLang=en).
Good luck...

G'd evening sqlchopper!
If that happens often you should consider to run your sproc(s) within transactions. It will not just avoid your application hang, but also and more important it will keep the...