If its as simple as a date range, why not put the following query?  Or if you're looking to calc reservations over time, then group by month,

SELECT...

If you are remoting onto the same box that SQL Server is on, then open SQL Server Management Services. You'll get a logon dialog. Either select the SA account assuming...

what version of SQL Server did you install? It looks like a permissions error.

SQL Server is a backend server. SQL Server Management Services (SSMS) is a client app for administering databases. If you are creating an application, then you would need...

The ODBC connection/Access client has to be on the workstation that you VPN into.

I'm sorry. But again, I don't understand your need.

- Are you building an application to connect to your database?

- Are you trying to connect to it from...

In reading the replies, not sure if you are building an internet application or attempting to connect via a VPN. Your scenario isn't clear. If it's as simple as...

You can only use ORDER BY at the end of the query as it must put all the sub queries into a singular data set before it can apply the...

Good article...

One comment though...

I would not filter on a row value in a having statement, the code is wasting CPU cycles and too much memory swapping.

The last example would be...

create a Sub Main in VB5 and run the 'startup' code there.

Why not just rewrite the app as an asp.net app with SQL Server? MS isn't supporting VB6 anymore.

Hmmm...

Access Issues:

- Multi-user/network corruption

- Huge Loss of indexing/performance

- Driver bottleneck.

- Jet engine vs sql engine

- scalability

Need I go on....

Convince your boss to byte the bullet and do the conversion.

just an additional thought: When I have 'internal' access issues, I've found that creating a new .mdb and importing all the objects fixes many things. It's saved hours of debugging....

I keep a separate .asp page with that configuration and 'INCLUDE' it at the very top on all pages.  Take the code out of global.asa.

<!--#INCLUDE virtual="/virtualFolder/globalconfig.asp"-->

If you're using visual...

setting up SQL Server for Windows Security and using 'trusted connection' in Access is the most secure!!! That way, security is set up in sql server for any application that...

Not sure when SQL 2005 is due out. If you need to upsize it now, do it. Then, if you purchase a license later, set up a server for testing...