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 ...

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 ...

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 ...

I want to buy a computer but i do not konw

I have an Access database that I am converting from mdb to adp, with a SQL
Server the back-end.
I have 2 tables (Table A, Table B) in an Acccess mdb that are related by
primary keys in each table. THe slightly different aspect of this

I have this problem:
I have a rather large Access2003 application (adp) that uses a
sqlserver database in  the network at my work.
Now I want some users to work with this applicatoin from distance

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

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 ...

I have a subform that the user accesses to input data. The user then selects
a record from the subform, clicks a control button, and a reference to the
selected record is recorded in a table on the main form. All of this actually
works, but when leaving the subform, the user the ...

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 ...

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

I am trying to convert access 97 database to SQL server. Can you anyone help
on this?
Any help is appreciated...
thanks,

I have a childcare registration form to show Firstname, Lastname, Date of
Birth,Age
Age is not in a table it is a calculated field.
I then have a button that opens a report (which is based on Quey) to show

First off, I'm using Access 2007 SP1, Vista SP1 and SQL Server 2005 Developer
Edition SP2 (Build 3068), all on my local computer.
It seems that I can connect to my server from any application but from an
Access adp... I can't figure out why... It's the first time I'm using an adp, ...

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?