|
Future of ADP - new article
regarding the topic of the future of ADP's: here's new article from MS:
http://technet.microsoft.com/en-us/library/cc178973.aspx
Some notable excerpts:
"Office Access 2007 offers two ways to connect to SQL Server data: linking
to SQL Server and Access Data Projects (ADPs). The preferred way to connect
to SQL Server is MDB file format or ACCDB file format. This enables you to
use the...
|
13 |
11/5/2008 4:14:25 AM |
|
|
Additional SQL Link Fails for Trusted Logon
Hi,
I have select rights on a SQL server/database via my Windows logon but when
I use the Link Table Wizard in my MS Access 2007 ADP, create my .odc data
source file with a trusted connection and attempt to link tables (i.e. create
views on same) I ultimately fail with 'Login failed for user 'NT
AUTHORITY/ANONYMOUS LOGON'.
I don't have this problem when I authenticate with a SQL doma...
|
7 |
10/30/2008 7:51:10 PM |
|
|
web form getting data to SQL Backend
I had a split DB with a front and BE in Access. I am converting the BE to
SQL because of the size and number of users. I have all the conversion done;
however, I have various vendors sending me information via a web page that
works fine on the Access BE but doesn't connect once the BE has been upsized
to SQL. I tried to create a connection to the SQL DB that looked like the
old BE with the...
|
9 |
10/30/2008 7:45:37 PM |
|
|
link to the data source by creating a linked table
Hello, we are using Access 2007 with ADPs. One of our people would like to
connect to Excel and/or text documents, not import them just use the "link
to the data source by creating a linked table" choice. However, in an ADP
under External Data->Excel (or text), the choice link to the data source by
creating a linked table is greyed out. Is this standard for ADPs? Is it
possible t...
|
5 |
10/29/2008 2:17:24 PM |
|
|
import data into a SQL Server 200 table from a command button
Hi,
I was wondering if it is possible to import data into a SQL Server 200
table from a command button in excel.
Basically I need to send users (over 50) an excel spreadsheet for them
to fill out, once complete I then wanted them to press a command
button and the data be sent autamatically to a SQL Server table.
The data they fill out is: Client_ID, Business Group and Appointment
Date...
|
2 |
10/23/2008 7:41:29 PM |
|
|
Write Conflict
Hello All,
I am having problem with my database. I have an Access front end
and SQL back end. I have a main form that creates a record with some data
and a subform that allows the user the create multiple records in another
table that coinsides with the main form data. I have a button that allows
the user to add a new record to the subform and when the button is clicked it
takes th...
|
4 |
10/23/2008 7:38:14 PM |
|
|
Using Between in a Server Filter by Form
I have an ADP with SQL Server 2000 that I am trying to employ the Server
Filter by Form. In general, the Server Filter by Form works and I can filter
records to my hearts desire. I have even allowed my users to save their
custom filters so they can grab a filter and apply it without having to
remember exactly which conditions they use. The users use the form to create
the filters. Pr...
|
4 |
10/21/2008 4:59:26 PM |
|
|
INSTEAD OF TRIGGER to DELETE error
Need some help for my first SQL database.
I have an MDB front end linked to SQL EXPRESS tables. It has an INSTEAD OF
TRIGGER tied to a view to delete a specific row in a table when that row is
selected in a view. The view is based on 2 joined tables, the one with the
primary key is the table contains the row I want to delete.
My trigger is very basic : Delete from table1 where @var= d...
|
1 |
10/21/2008 4:55:01 PM |
|
|
ganhe 12 mil reais brincando!
COMO TRANSFORMAR 12 REAIS EM 12.000
Leia todo o formulário Participe, é uma brincadeira BEM DIVERTIDA E
LUCRATIVA!!!!!!
GANHE DINHEIRO FÁCIL!!! Por Favor, leia este texto para entender, é muito
fácil!! MULTIPLIQUE SEU DINHEIRO: Transforme R$ 12,00 em mais de R$
12.000,00!!! LENDO ISTO VOCÊ PODE MUDAR SUA VIDA!
FUNCIONA! Eu achei essa mensagem em um fórum e decidi participar. Eu estava...
|
1 |
10/20/2008 7:32:38 PM |
|
|
Inconsistant behavior passing InputParameters to a TVF
Hi. Any help appreciated.
I converted an Access 2007 .accdb to an .adp database. A number of the
queries converted to TVF. My attempt to convert one of them to deal with
parameters, shown under “TVF:†below, works fine when run from the Queries
Navigation Pane in Access 2007 – user is prompted for the parameters.
Upon opening a report that has its Record Source set, on the Data ...
|
5 |
10/16/2008 7:34:01 PM |
|
|
Database converison Access 97 to SQl server
Hi Guys,
I am trying to convert access 97 database to SQL server. Can you anyone help
on this?
Any help is appreciated...
thanks,
Hasi...
|
4 |
10/15/2008 9:05:23 PM |
|
|
EMPTY TABLE AFTER UPSIZING TO SQL
Hi,
I have an Access database that has a table which cannot be upsized to SQL
Server (the table is empty after upsizing).
Any suggestions on how I may procede to get the Access table into the SQL
database?
Kind regards,
Tom
...
|
5 |
10/13/2008 8:15:08 AM |
|
|
adLongVarChar parameter for TEXT data type size problem
I'm trying to run a sql stored procedure where one of the parameters is TEXT
datatype. Through some online research I found that the 2nd parameter in the
line below needs to be adLongVarChar to accomodate the backend's TEXT
datatype. But I have no idea what to put in the "size" parameter position.
I've tried a few kind of at random but get errors on the execute statement
that it's wrong. If I...
|
3 |
10/8/2008 3:24:17 AM |
|
|
Upsizing Access DB to SQL
When I'm using the upsizing manager, I get messages back that table was
skipped, or export failed. There is no explaination why this is happening.
Is there any where for me to look for more information on why it's being
skipped? Thanks for any help.
--
Jodie McNalley...
|
2 |
10/7/2008 11:58:48 PM |
|
|
changing #Error message to null is it possible?
can anyone give me some tips or codes in changing #Error message to null
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-adp-sqlserver/200810/1
...
|
3 |
10/7/2008 11:58:27 PM |
|
|
Date Difference
The query
SELECT DATEDIFF(Day, [DateOut], [DateIn]) AS Days FROM Calibrations;
gives error "Overflow"
All dates entered are entered in dd/mm/yyyy format. The error can be fixed
by setting the default Logon locale to British English. I have tried the
CONVERT function as follows
SELECT DATEDIFF(Day, CONVERT(varchar(10), [DateOut], 120),
CONVERT(varchar(10), DateIn, 120)) AS Days FROM ...
|
3 |
10/5/2008 1:14:01 PM |
|
|
problème_de_seveur
j'ai essaié d'envoyer une image scanner à un correspondant ayant une adresse
yahoo mail; mais cela a échoué car on me demande le serveur sachant que le
compteest:POP3
___________________________________________________________________________
J'utilise le logiciel antispam Vade Retro (http://www.antispam.fr) pour protéger ma messagerie des courriers indésirables.
Depuis son installation,...
|
2 |
10/4/2008 5:54:47 PM |
|
|
Access 2000 & SQL Server 2005
I am trying to first use an access .adp project of acces 2000 with sql
server 2005. I can create project, I can also connect it with existing
database using "sa" login, but when I try to add table I get the
folowing error:
"You do not have exclusive access to the database at this time. Your
design changes will not be saved."
If I try to create new database on server, after the message that...
|
2 |
6/30/2007 3:00:29 PM |
|
|
Problem with SQL query
Hello,
I'm an Access/SQL novice and I have an sql problem:
I have the following table Price:
FuelID PriceDate Price
LPG 1/05/2007 0,2
LPG 13/05/2007 0,21
SPS 2/05/2007 1,1
SPS 15/05/2007 1,08
And I have to make the following query:
FuelID PriceDate_from PriceDate_To Price
LPG 1/05/2007 13/05/2007 0,2
SPS 2/05/2007 15/05/2007 1,...
|
2 |
6/30/2007 2:56:03 PM |
|
|
Upload big text file via adp client and ado to sql server
I need to upload a .txt semicolon separated file (table) to sql server 2000.
Currently this is done via DTS and it works very well, but it would be more
convenient to do upload from the client if acceptable speed can be obtained.
The configuration is based on SQL Server 2000 and Access 2000
The.txt file resides in a folder on the client computer. It contains about
150 000 records and 3...
|
1 |
6/30/2007 12:50:01 PM |
|
|
Passing an adodb.command (which calls a stored procedure)to a func
Dim CMD As ADODB.Command
Set CMD = Build_SP_Command("spfm_User_SalesLeadSearch_Dynamic")
Execute_SQL_GetRows_Command (CMD)
Set CMD = Nothing
Public Function Execute_SQL_GetRows_Command(CMD As ADODB.Command)
......
End Function
When the above code executes it blows immediately on the
Execute_SQL_GetRows_Command giving a type mismatch error using the
adodb.command as a passed...
|
10 |
6/29/2007 8:50:41 PM |
|
|
display error message if constraint violation
is there a way for the database to display an error message when a
user violates a constraint?
an age limit for example?
tia,
mcnewsxp
...
|
5 |
6/29/2007 7:30:25 PM |
|
|
Access 2003 to SQL Server 2000 over a VPN
Hi,
I have a client who has a simple Access database, which he now requires to
be accessible to up to 50 concurrent users remotely over the internet, as
well as a small number of local LAN users.
I am looking at a solution whereby the data is stored in a SQL server
database, with front-end Access mdb's on each machine, connecting via ODBC,
either directly over the LAN or over a VPN f...
|
14 |
6/29/2007 1:38:06 AM |
|
|
listbox add items
Help! What is wrong with my code? I have a listbox that is supposed
to allow the users to select several items in the list and click a
button and it will add those items (contacts) to their record. But,
what is happening is that if i pick 3 different items, I get 3
records, but they are all the same item instead of the 3 different
ones. Any ideas on what's wrong with my code? Thanks for th...
|
3 |
6/28/2007 9:10:33 PM |
|
|
Remove subform filter does not show all records
Hello...
In Access 2003 Project...
I have two subforms on a parent form. One of these has a combo box
for selecting the filter value, and a button for clearing the filter.
On the AfterUpdate event, the subform filters and then
programmatically filters the other subform, which works fine. When
the button is clicked, it removes the filter from the subform, and
clears the filter from the...
|
3 |
6/27/2007 2:06:27 PM |