.Net is very good and a good choice for SQL Server.  You can also use the Access Data Project(ADP).  It is a direct connection into the SQL Server.  The only...

Actually, there is no such thing as forms in SQL Server.  SQL Server is not the GUI that you would give to a user.  It is only the database behind...

Yes, that is what Cole was talking about also.

If you need help with this, let me know.  I often mentor beginning developers.  I teach/lead and Access Users group in Houston...

No, I am saying the same thing I did before.

Drop downs are done at the user graphical interface.  You cannot do it at the table level like Access and it...

Jackie,

All the lookups should be done from the GUI side of the application.  No one should be accessing the tables directly.  Especially with a SQL Server database.  Something else that...

Nothing BETA is ready for production.

Since MS is not enven shipping an interface to it yet, that also should give you an idea how "ready: it is for a production...

Since this is a SQL Server forum, you are not in the right place.

But, if you were using SQL Server, the answer is yes.  So, I would assume that the...

Try RIGHT OUTER instead.

It works for me now also.

It looks like it might work.  Try it and see (if you have a dev environment to play in)

The link you posted does not work.  If you can post a good one, I will look at it and see.

For those interested, I have a Word document with table and column anming standards.  And an Access MDB with the approved abbreviations.  I would eb happy to send it to...

I am not sure what a Data Administrator is.  But....

At the company I work for right now, it is the job of the Data Architects to come up with all...

As long as you are willing to install the framework, it should work.  Reporting services from what I understand is not dependent on ASP.net, but on the .Net framework.

You cannot "upload" directly using SQL Server.  You will have to create a front end tool (GUI) of some kind for the user.  You can do it in Access, ASP,...

Alamir,

Actually, the best if you are going to use an Access query is to use a snapshot.  Then there are no record locks of any kind that are active.