Search results for query: *

I like this response very much. It looks like a great way to see if the employers (or at least interviewers) are smart enough to make the job enjoyable. Have a star.

An adp will allow you to add queries (they're actually SQL views) and reports just like an MDB. The views will be stored on the database server. It's not really a good idea to let most users go wild in a raw SQL database though unless they knwo what they are doing. End users adding columns to...

If you don't have the problem in your development environment, there is probably something different in the runtime. Have you thought about installing a copy of Access 2002 on the Terminal Server and seeing if the problem goes away? This suggests to me that the users are probably all sharing...

Have you run a Windows Office Update on the Terminal Server to make sure that you have the latest version of the runtime and the latest MDAC? Old versions have caused problems for me in the past. Otherwise, find out what sequence of events is causing the crash. It will probably be one form or...

I do something similar, but I use functions to set and get the parameter rather than a global variable.

If you make your ADP into an ADE before distributing it there will be no code visible to break into. There is a lot you can do on the SQL Server end. Use views and stored procedures and never allow direct access to tables. Put all your users in a group or heirarchy of groups and set access...

Happy to help.

I too think not much has changed. It would be interesting to work out why project management seems to lag so far behind the advances in technology.

You can't update a SQL Server table through an ADP form without having a primary key unless you write a lot of code to do it. It is not good to use columns that have any meaning as a primary key (don't use something like client name as your primary key). It is much better practice to use a...

I think it could be fun to compare and contrast between a couple of major projects run 20 or 30 years ago and a couple of recent ones. The evolution of technology and development languages is quite well documented, but have development tools, methodologies and project management techniques...

Why not simply take your first query, add a set of brackets round the WHERE clause and put AND (final.TXPD <>(SELECT MIN(TXPD) FROM final)) on the end of it. Like this: SELECT final.[SSN P], final.TXPD, final.[LFRZ-RFRZ], final.[TC-150], final.[TC-290], final.[TC-291], final.[TC-300]...

I get the feeling that I am coming in half way through a conversation, but let's try. DISTINCT is an SQL keyword normally used after SELECT. I don't believe it is a function unless you have written your own. You could use more meaningful names to aid debugging. There is no way I could know...

Chas, This forum is for Access Data Projects (ADP) that normally have a SQL Server backend. Workgroups aren't a feature of an ADP so you might have more chance of an answer in one of the other Access forums.

Make sure that you have a primary key on all the tables you have created in SQL Server. If you don't, you can't update the tables through an ADP. If you are trying to update a view formed from multiple tables, it can help to set the primary table.

I don't knwo the answer, but some of the questions below might point you in the right direction. Has he also changed from Office 2000 to Office XP or 2003? Check that all Office patches and service packs are loaded on the laptop. Is the full version of Access loaded on his machine or the...

There are only three possibilities that I can think of: [ul square] Convert the ADP to Access 2000 Upgrade the other users to Access 2003 Use the Office Developers Kit and distribute the Access 2003 runtime with the ADP Loading Service Packs won't help you.

Make sure you have a primary key defined on the SQL Server table so Access can uniquely identify each row.

I'm in Australia and have never had this problem with BETWEEN dates in Access 2002. It sounds to me like your date is not what you think it is. Are the fields that you are passing into the stored procedure declared or formatted as dates? Have you tried a debug.print "Day is " &...

I am not sure if I fully understand the problem but it sounds like the data displayed in the form is not being refreshed after you update the individual row. If you are using a stored procedure to populate the form you should refresh or requery your recordset after the update otherwise the data...

In the front end database, select the menu option Tools, then Startup... and set the database to open with your main form. Then, when you next open the application, it should launch that form. You are better off asking this sort of question in one of the other forums such as Microsoft:Access...