|
New user needs help!
trying to create ADP front end that will connect to company's SQL Server.
Need help in doing this since this is my first time.
1. Have an mdb form - would like to utilize it in ADP. I migrated the forms
and the tables and code over and am unable to make them work. I don't know if
the table have to be housed in SQL or can the form use a local table housed
in ADP? The error message state...
|
5 |
23.02.2006 23:40:07 |
|
|
SQL Rules
Dear friends:
I am a SQL developer known personally to most of the MVPs ( I have been one
for 5 years, and hope to be again soon). They know I am a proponent of the
superiority of SQL Server to Jet. This has been no secret for those 5
years.
My recent experience has trumped that to an incredible degree.
A client brought me an existing application that searched a large Jet table
...
|
23 |
23.02.2006 23:36:27 |
|
|
datetime in adp connected to an sqlserver 2005 database
I have some problem with datetime in sql server 2005.
In adp project connected to an sql server 2000 when I refer to a datetime
formatting I use something like this:
select * from aaa where mydate = '" & me!date & "'"
and all is ok.
In adp project connected to an sql server 2005 when I refer to a datetime
formatting I have to use sometime :
select * from aaa where mydate = '" ...
|
2 |
23.02.2006 08:01:13 |
|
|
Migrate from Access to SQL
Hi,
I have an apllication that uses Access but want to switch to SQL, is it an
easy process and are there any rescources to see.
Regards
Simon
...
|
2 |
22.02.2006 18:43:27 |
|
|
ADP with multiple users
I have setup an ADP linked to SQL on the server. Here are a few simple
questions that I hope are no too basic for this newsgroup...
1) Each user must be running their own version of the ADP since it is the
front end. Hence, if 2 people try to open the same ADP file, one will get a
"read only" message. Is this correct?
2) When modifying the primary copy of the ADP, it is easy enough to...
|
4 |
21.02.2006 20:10:50 |
|
|
username in adp
using mdb, when a user open the mdb file and put his username and password,
the windows keeps username for next time...
but...
using adp, the username's default always is the connection's username
how can I change this situation?
...
|
4 |
21.02.2006 19:28:08 |
|
|
'Insufficient base table information' using ADP's connectionstring
Hi,
I'm adding and updating some rows in my ADP. I get an error on rs.Update...
(ADODB)
Does anyone know why I get the 'Insufficient base table information'-error
when I use the ADP's connectionstring? (Only when I use a client side cursor.)
CurrentProject.Connection.Connectionstring:
Provider=Microsoft.Access.OLEDB.10.0;Persist Security Info=True;Data
Source=SERVER\INSTANCE;Inte...
|
2 |
21.02.2006 17:31:58 |
|
|
Sql code in access form in adp
Whats wrong with this Private Sub Save_Record_Click()
Dim SQL As String
SQL = "INSERT INTO log ([Admin],[Issue])" _
& "select [adm_name],[Problem]" _
& "from forms!frm_tick_entry"
DoCmd.RunSQL SQL
End Sub
Access2003 - sql200 back end
I am trying to create a code which will copy information from a form to a
table.
table = log
Form = frm_tick_entry
I...
|
11 |
21.02.2006 04:02:57 |
|
|
How to update queries on BE with a new version of FE?
Hello,
After conversion of my MDB project to ADP/MSDE I ran into a following problem
- how to update changed views and procedures after releasing a new version of
FE?
While developing an MDB project I split FE and BE so I had only tables in BE
which made it possible to develop locally and then ship only a new version of
FE to my Customer that linked to Customers’ BE. Keeping the table st...
|
5 |
20.02.2006 20:56:53 |
|
|
Permissions question
I don't understand a couple of things about permissions in ADP. I have a form
with a function as a record source. I gave only SELECT permissions to a role
directly on the table and both SELECT and INSERT permissions on the function.
When the user attempts to create a new record he gets an error saying INSERT
permmision denied at the table.
My understanding of this is that unless a specifi...
|
2 |
20.02.2006 20:50:37 |
|
|
Can's see Server objects unless i'm dbo
I have created 2 databases on a SQL Server 2000 and use one for developement.
I have been successful on the developement database in createing all the SP's,
UDF's and Views and just this weekend created all the users and groups and
all works just fine until I switch to the production database. Now I can't
see and tables, or any objects in the Query pane unless I put my test user
login under t...
|
2 |
20.02.2006 18:16:13 |
|
|
No tables visible in SQL Server connection
Hi,
i am setting up an ASP.NET site and have connected to the SQL Server
successfully.
When I click on the connection it shows tables 'none' ?? I know there are
tables just cant see them.
When I set up an ASP site and connect to the SQL with DNS all tables are
visible.
I have spent a whole day on this tried everything.
Tools Dreamweaver MX
Server Windows Small Bu...
|
8 |
20.02.2006 15:08:34 |
|
|
Many-to-many relationships via subform
Mainly because of fear of corruption of an .mdb in a multiuser
environment, I have been experimenting with the format of an .adp front
end to a SQL Server back end (using the Express version of SQL Server
2005).
Although it seems that the ADP option is perhaps going to be phased
out, I don't see many practical alternatives for a front end to the
otherwise esteemed SQL Server.
I've encou...
|
1 |
19.02.2006 02:58:32 |
|
|
Parameterized queries
Hi, I am using ADO against an Sql Server 2000 backend. My problem is
I'm trying to use a dynamic sql query as part of an import csv process.
The final stage after matching field names, etc is to build a
parameterized query.
Unfortunatly when it comes to executing the command all I get is the
error "Must declare the variable @name". From what I could find it
seems that ADO will not support ...
|
6 |
18.02.2006 22:31:17 |
|
|
Complicated Connection Problems bewteen ADP and SQL Server
About 3 years ago, I was told to create a SQL Server 2000 database for a
client of ours, and to set up an Access XP/2002 project (adp) front end that
would be used on their network to interact with the data. This database
needs to be updated every six months. Since there has been some "feature
creep" in the front end, I have almost always needed to install a new adp
front end on the 5-8 wor...
|
6 |
17.02.2006 19:18:28 |
|
|
Dynamic Table Form
how can I hide the 'total' line in dynamic table form ?
how can I use event procedure on it ? something like 'double click'...
...
|
1 |
17.02.2006 14:56:11 |
|
|
sao paulo na libertadores
o sao paulo na libertadores nao e novidade,mais sim a maior dor de cotuvelo
dos corintianos .
oque podia consolalos era a conquista do brasileirao mas
com a midia creditando esta conquista a luiz esveiter, nao sobrou nada para
eles.
para consolalos digamos que eles terao a chance de jogar pelomenos a
primeira fase da libertadores com a gente,
talves nao ganhe nem uma partida nao disem por a...
|
3 |
17.02.2006 03:55:03 |
|
|
Newby - needing Help
Hi all,
I have an sql2000 backend and wish to use access2003 for a front end.
I have created the sql tables required and inan access adp have link etc the
tabled ODBC.
The questionis that I want to fill out my form and when its completed click
a "save" button to transfer the data in the form to the sql table (held on
remote server). We will have upto 4 ppl entering data at any one ...
|
5 |
17.02.2006 03:37:27 |
|
|
How to insert a New Line into a text field?
How do I insert a new line into an nvarchar field?
If I'm using Access, I can set the Enter key behavior for a text field to go
to a new line. When I look at the table data, it appears as new lines. If
I'm not using an Access form however to input the data (I want my VB code to
insert a new line and some text to the field), how do I do that?
Thanks,
Ryan
...
|
4 |
16.02.2006 23:27:56 |
|
|
connections
when I type 'select @@connections' in sql query analyzer, it show about
200.000, and never decrease, just increase, is it a problem ?
I have just 50 hosts
...
|
2 |
16.02.2006 21:54:20 |
|
|
test
...
|
1 |
16.02.2006 03:52:08 |
|
|
Help with Master/Detail UI in ADPs
In Access DAO/Jet applications, I handle Master/Detail relationships by
using unbound fields for the Master table and a subform bound to a local
temp table for the Detail rows with OK, Apply and Cancel buttons on these
forms. If the user clicks OK or Apply, I do concurrency checks then I write
from the unbound fields to the Master table on the server and from the local
temp table to the ...
|
9 |
16.02.2006 02:16:10 |
|
|
Append to a text field
Is there any way with T-SQL to append to a text field?
Thanks,
Ryan
...
|
3 |
15.02.2006 20:08:12 |
|
|
Top10 from another view
I would like to create a view based in a sp or another view like the
following example:
SELECT dDate, Well
FROM dbo.J1_WTzDL
WHERE (dDate = iDate())
We have results as below:
dDate
Well
10/12/2005
ALB - 4H
10/12/2005
BAG - 4L
10/12/2005
CHO - 1
10/12/2005
EST-A-2
10/12/2005...
|
7 |
15.02.2006 19:51:31 |
|
|
Tools/Macro/Service.. Not there.
This is making me nuts... any help will be much appreciated.
I installed Office 2003 Pro at home and at the office.
In Access, the macro warning keeps coming up when
opening an .mdb. At work I can get to the security tab from
Macro on Tools. At home, there is no Security under Macro.
I see this in help, but don't see any Security tab.
To stop displaying macro warnings, change the securit...
|
4 |
15.02.2006 17:23:11 |