I'm guessing its the security warning dialog box (which is not visible). If you run your command from a command prompt, when MSAccess opens does it display any security...

Surely value1 = value3 would just evaluate to false and return no rows, assuming (value2 = value2 AND value1 <= value3 - in which case it by my understanding...

Florian Reischl (6/12/2009)

---

Tom Brown (6/12/2009)

---

You can use a STATIC cursor instead.

See BOL.

But I couldn't say that without also advising you to look at the numerous articles on this site about...

you have FROM FROM on line 2.

sometimes you just need someone else to look at the code 😉

If its still not giving the results you want, post...

You can use a STATIC cursor instead.

See BOL.

But I couldn't say that without also advising you to look at the numerous articles on this site about cursors and how to...

at a command prompt

SQLCMD -L

The output is a bit variable though - probably due to network response times, but its good for a quick idea of what's there.

also OSQL -L

but...

My first idea on reading the OP was a simple directory listing of the DATA directory - sort by date. I would probably find a bunch of files with...

If you want word matches then full-text search is the way to go. If you are OK with partial word matches (e.g search for 'miss' - results include 'mission'...

Ten years ago I was team leader in a small software house. When things went wrong there was a bit of a ...

No you can't just shrink a table on its own. - SHRINKFILE acts on a database filegroup. (data or log)

The table would have to reside on its...

tosscrosby (6/10/2009)

---

Don't shrink the files unless you're out of...

My first thought is to accept Visual studios error and check the data type conversion.

Is the column ID_Facultare a BIGINT or just INT?

can you post the table def too?

Deleting data does not free up the space on the hard-disk.

You need to shrink the files

see DBCC SHRINKFILE in BoL

I have seen such read locking handled in an application with a separate lock table, where all access to the table goes through the application - the application keeps track...

I usually run OSQL -L from a command prompt

It only gives a list of servers, and no other information,