Hi I am a Network Admin (not a programmer) who started creating a Company DB
programs with Access. I want to be proactive and understand why and when I
should consider moving from MS Access to MS SQL. Can somebody tell me what
limitations Access has? When I should be ready move ...

I have a UDF with two parameters and I'm trying to pass multiple values to
either parameter and can't figure it out. I'll show what I have tried.
Me.RecordSource = "SELECT * FROM fn_QcQuestions(IN(1,2,3),In(4,5,6))"
Me.RecordSource = "SELECT * FROM fn_QcQuestions(1 OR 2 OR 3, 4 OR 5 ...

I need to review the SQL statements of queries in Microsoft Access. I am
opening each one individually. Time consuming and tedious. Is there a way I
can download these queries and only their SQL statement to one table, excel
or word doc?

The following dynamic sql, compiled as a stored procedure, returns the
correct number of rows but only the columns from the first SET statement.
It's as if it executes the query which is the concatenation of the first and
second SET statement without the SELECT in the middle. ...

haaaaaaaaaaaaaaaaaaaaaaaaaaa   yaaaaaaaaaaaaaahhhhhhhhhhhhhhh

I have a form in Access mdb that I am trying to get to work in adp. In the
mdb version, a query underlies the form. One of the fields in the query is a
check box, the value of which is pre-determined by whatever item is selected
in another field on the form. In other words, there ...

I have a database to log annual appraisals. It holds details of each
appraisal, including date, and the year of the appraisal, recorded as
'2005/6', '2006/7' etc. I wish to identify all those who have not had an
appraisal in 2007/8. The SQL below, of course, does not just ...

´óѧÉú´ßÈé´´ÒµÖý»Ô»Í
Ëæ×Å´óѧ±ÏÒµÉúÊýÁ¿µÄÔö¼ÓºÍ¾ÍÒµÐÎÊƵÄÑϾþ£¬2005Äêר¿ÆԺУ±ÏÒµÀî¼ÑºÍËùÓеĴóѧÉúÒ»ÑùÔÚÉç»áµÄ½ÇÂäÕõÔú×Å£¬È»¶øÀî¼ÑÊÇÒ»¸ö²»¸ÊƽӹµÄÅ®º¢×Ó£¬¾¡¹Ü¼Ò¾³Æ¶º®£¬ÊÇÒ»¸öÏçÏÂÈË£¬µ«ÊÇËýÒÀÈ»»³´§×ÅÃÎÏëÏ£Íû¿¿×Ô¼ºµÄÇÚÀͺÍÖǻ۸ıäÉú»î¡£

any tips on creating ribbons for an access adp project.
I cannot get the database to read the USysRibbons Table and display
customized ribbons. Thanks
- Alibaba

I have an application written as an Access 2003 ADP. As long as an ADP is
supported in an Access 2007 environment I do not intend to switch to a MDB
with ODBC.
Are there any issues when migrating to the Access 2007 environment I will

ativazione imeil

اعتقد انا العراق بيوم من الليام ونشاء الله قريب يكون بلاد السلام والامان بعد
الي شفنا من دم وتفجير وقتل ياريت تدعون معاي الحب وسلام وامان العراق واشكر كل
الي يقرأ رسالتي اخوكم عراقي بضمير تحياتي

²Ì´ºÁỶӭ2008±±¾©°ÂÔË

³Â°²ÄÈ»¶Ó­2008±±¾©°ÂÔË»á

I have an instance and I want to transfer data to it from my main databases.  
Problem is that it needs to be updated on a constant basis from either a
trigger or updated hourly and even some updated daily.  So how should I go
about doing this?  Replication or updates based on ...