Recent content by ChiOscar

Try the the following query: "select top 1 * from table order by fieldid" Remember the sort order is important with this query.

ADP maybe will not stop people from linking to the SQL server but i can stop anyone from doing anything by not giving them access to the database and in turn use an APP ROLE to process the data in a controlled front end application. I think your method is an excellent to secure the back end...

That tells me that you are using the forms to control security which works great. I did the same thing and worked beautifully when my database was in Access. My new issue is that I need people to enter data specifically the way the form allows them to which is designed based on our processes...

Can anyone please advise on a security design to use Database Roles in SQL server 2008 when using MS Acess 2007 as a front end. How can I integrated DB Roles into MS Access when the security use to be handled by the forms when the database was is Acsess? I link the database through ODBC. I...

It turned out that I should have done ADODB.recordset vs DAO.recordset.

I have the following code that use to work fine when my front end was in a .ACCDB file. After I migrated the backend to SQL server I changed the fron end to a .adp file and now my code won't work. I get the following error message "Run-Time error 91". Can someone please help. Sub GetDBUsers()...

Is there a way I can connect SQL Server 2008 through MS Access 2007 application through an Application Role? If so how would I go about it?

Use this query sample: SELECT MARKET, SUM(IIF(MARKET IN ('NY','NJ','PA'),Sales,0)) AS EastSales, SUM(IIF(MARKET IN ('NY','NJ','PA'),Goals,0)) AS EastGoals FROM SampleTable Group by Market Hope this helps.

What Reference Library should I use if I wanted to send CDO messages through VBA? Thanks

I have a database split into front end and back end(password secured). How can I prevent users from viewing the MSysObjects table in the front end.

Try the following code: SELECT TOP 1 UpdateLiningStatus.MachineNumber, UpdateLiningStatus.TimeStamp FROM UpdateLiningStatus WHERE UpdateLiningStatus.MachineNumber="CLN33501" ORDER BY UpdateLiningStatus.TimeStamp DESC

See attached database. This works now.

If you only want to get the short date try: Format(Date(), "mm/dd/yyyy") If you only want to get the month try: Format(Date(), "mm") This should work.

Hi everyone from Chicago. My name is Oscar and I have been programming fo 6 years of which 4 have been MS Access 2003 and 2007. I really enjoy this site and has helped me much in the past. Hopefully, I can share what I have learned here along with my experience to help others as well as to...