Synopsis:  I'm trying to launch an SP that makes use of BULK INSERT and
getting permissions errors.
I have a stored proc - dbo.p_Import_Sales_Transactions which takes as its
single argument the path to where the data resides, having been created by

Ok, I am working on upsizing a FE/BE DB that I have to a SQL 200X BE.  I did
the upsizing and everything works except one thing...
I have a main form that has multiple subforms under tabs...
the subforms show data linked to the main form by an autonumbered ID

I want to add a column in my table with data type bit in access database, and
after add cloumn if i swith to design mode then it desply 0 or 1 by default
value,
but i want to display Checkbox for bit data type , Please help me out its,

I have ADP front end to SQL 2005 data. This front end is a conversion
from an older MDB. The old MDB links to views on the SQL server. These
views are used as datasources for a number of reports.
The ADP links to the same views, same SQL side permissions. When run

I am running an Access 2003 project to a SQL Server 2005 DB. SQL Server
2005 allows you to document each column with a description. Is there a
way that an Access project can get access to this property of the
column?

On 10/6/2004 Chicago Dave asked about updating linked tables and Steve
Jorgensen replied that adding a timestamp column to the table will allow
Access to figure out whether a record has been changed.
I'm wondering what the impact of a timestamp column has on a database.  

I have an access database that links in some SQL tables. There is a form
where end users select options for what they want to display. Once an option
button is selected the text box associated with it is enabled and they can
enter in thier criteria. I have this working for two ...

Consider the following query:
SELECT
    Projectid,
    'fldValue_1' =

I created an access application for several users. At times, they forget
that have the application already open and execute a new one reducing their
available memory. I'd like them to be notified when they try to open a new
application. Can it be done, and if so, how?

I have an app that uses an MDB file as it's database. I want to run the app
on 3 different computers but use the same database. I tried putting the
database on a server share and configuring each app to point to the file,
but found that this is less than reliable.

I created a seemingly simple query to combine 2 fields. It works as long as
there is information in both fields however if there is a null in either the
field is blank. Fields are of type NVARCHAR
This is what I would like to have happen.

I created a SQL that will work sometimes and other times it doesn't.   When
it doesn't work, I copy and paste the SQL string from the immediate window
into a query in sql view.  It normally doesn't work unless I remove some the
carrage returns and then I can select the normal ...

I have a small Access database created in Office 2003 that won't open in
Office 2007 when using Vista Ultimate 64 as OS. It says something about a
broken reference called RMOC3260.dll. However when using Office 2003 and XP
it opens up without any difficulty. Somebody who has had ...

I have a text box that I want to display a specific value from a table when I
click a control. But I can't get this to work in the click event statement of
the control:
Forms!FormA!TextBox.ControlSource = "SELECT TableA.number, TableA.item FROM

I upsized a 2002(Saved as 2000) Database BE to SQL Server 2000.  However I do
not know what kind of permissions to grant in SQL to allow my users to use
the Access FE.  I am connecting via ODBC and using a trusted connection.
I have several Select Queries for teachers and most ...