Group:  Microsoft Access » microsoft.public.access.adp.sqlserver

Threads Replies Last Post
44 Pages: <<  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  
What would you like to fix in Money?
Hello, please respond to this thread with the annoying things you would like fixed in Money. I will try to reproduce them in the next Money Beta, so there will be a chance to have them fixed. Ideally, please post in the form of steps to take/expected result/real result. regards, Vadim Rapp ...
2 4/19/2006 10:17:32 PM
Form with Disconnected Recordset, Will not allow edits.
I have a form that I want to have use a disconnected recordset. The disconnected recordset works fine, but I am unable to update or even type in the textboxes. When I try I get a "Recordset is not updateable message" My intention is to have the recordset reconnected and for it to do a batch update when the client pushes the "Save" button. I know I could have the text boxes unbound, l...
2 4/19/2006 7:07:07 PM
Wizard
How do I tranfere old files to a new computer,I have XP home addition,is there a wizard needed Les ...
1 4/19/2006 4:04:33 PM
test
test -- Serafim Bernardo web designer manager free lance 01614857737 ...
2 4/19/2006 3:50:31 PM
Form: Invoke a change when record is left
In a form, I neeed to invoke a change when a record is left (next, previous, or exit). How do I do this? -- Mark Matzke...
9 4/17/2006 10:37:29 AM
for sale: internetDotComs.com
domain for sale: internetdotcoms.com http://www.afternic.com/name.php?id=11866440 ...
1 4/16/2006 1:28:30 PM
Estrategia para administrar usuarios en inicio de sesion
Buen dia Estoy desarrollando una aplicacion, mi primera sobre SQL Server, ya que lo demas lo hice con Access, en el cual para cuando desarrollaba una aplicacion tenia una tabla con los usuarios, contraseñas, permisos, etc de cada uno, ahora necesito poner seguridad en la aplicacion que estoy desarrollando, para que solo un empleado con user y psw validos pueda iniciar sesion, pero no ...
1 4/15/2006 7:40:23 AM
SAVE THE BEE WITH GOOGLE ADSENSE!
<HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P> </P> </BODY> </HTML> ...
1 4/14/2006 3:07:54 AM
ImportXML => "Run-time error '31550': Not all of your data was successfully imported"
This is a multi-part message in MIME format. ------=_NextPart_000_0087_01C65CAE.B081CF80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear MS Support, I get the error=20 Run-time error '31550': Not all of your data was successfully imported. Error descriptions = with=20 associated row numbers of bad records can be found in the...
4 4/13/2006 9:01:02 AM
8
...
1 4/11/2006 7:16:25 PM
Express 2005 to 2000
Hi, I've created a new database in Sql express 2005, only to find out later that my hosting doesn't support 2000. So i need to recreate the database in sql 2000. I tried a few different ways from *.bak to script to file.. sql 2000 doesn't seem to be able to excute them. I'm pretty new to sql server altogether, how can I do that? I'm running out of solution and I can't seem to goog...
2 4/10/2006 3:21:02 AM
Upsizing Wizard tries to Convert Memo Field to Date/Time vs nvarchar
I am attempting to upsize an Access 2002 mdb to an adp linked to MSDE 2000. When I run the upsizing wizard everything seems to work except for one table that contains a memo field. I dropped the (empty) target table that resulted from the first attempt and ran export from the file menu to an ODBC data source that points at the new SQL database. ODBC can connect to the DSN just fine but I ...
1 4/9/2006 5:33:52 PM
Can't insert into inner joined table
Access 2003 + SPx, ADO 2.8, MS SQL Server 2000, .adp, bound form. Into the load event, me.recordsource is set to SELECT tblA.*, tblB.* FROM tblA INNER JOIN tblB ON tblA.IDB = tblB.IDB None of the fileds of tblB is shown nor updated in the single form; tblB is only joined for sorting purposes. Now when inserting a new record from the form (basically in tblA) I get an error: "C...
10 4/7/2006 12:22:57 PM
HELP !!!! Access Runtime 2000 and Sql 2000
Hi, we have the following problem. We developped an access 2000 application working with Sql 2000. We have to install the runtime on a workstation. On it, we find office 97. The problem is that the runtime shows error trying to connect to Sql 2000. We tried to add more references like msado at the runtime generation, but the installation can't process. We tried to manually copy some sql...
1 4/7/2006 7:34:02 AM
SQL 2005 - works GREAT with ADP
team i just had to give you guys a heads up.. .ADP 2002 works GREAT against SQL 2005. I am quite impressed. does anyone know when the patch is going to come out to allow us realworld developers to update sprocs and views? this from the company that shipped Access 2000 and SQL 2000 when they wouldn't talk to each other. bunch of drunk retard product managers at microsoft; they sho...
5 4/6/2006 6:25:36 PM
how can I show...
how can I show tables that contains a specific column ? Everaldo Ricardo ...
2 4/6/2006 7:26:21 AM
Procedure names ;1
Just upgraded database from SQL 2000 to 2005. All works fine on development computer. Other users computers are showing different problems. The strangest is that the stored procedures are showing up as procedure_name;1 (dbo) When you run the procdure it prompts for required paramaters but then says it can not find it. What dll's are used to access SQL database? ...
5 4/6/2006 7:18:39 AM
Miscrosft Access link to SQL 2000 table view is #Deleted
I had this problem and noticed a few other people have experience this also. No real solution has offered by most groups. I believe the best work around is to use the SQL import and Export utility to export the view or table you are after into Microsoft Access and then setup to schedule the process. Works like a dream!!! ...
1 4/6/2006 4:41:58 AM
Managing ADO warnings
Is there a way to manage in the .adp VB code the ADO warnings? Example: If you try to delete a record that conflicts with cascaded deletes rules you get an error like "DELETE statement conflicted with COLUMN REFERENCE constraint ....." bla bla bla. Any hint ? I undesrtand you could go for a query-before-delete approach but...... ...
5 4/5/2006 4:42:05 PM
ÀÏÆÅ
¶öÁ衃 µÈÏÂÈ¥³Ô·¹ ...
1 4/5/2006 10:30:21 AM
²»»áÔõôµÄ
²»ÊÇÎÒÎÞÄÜ Ö»ÊÇÎÒÎÞÄÎ ...
1 4/5/2006 10:26:02 AM
sdgsgsdgsdg
sdgsdgsdgsdg ...
1 4/5/2006 10:17:52 AM
SET DATEFIRST ignored by adp
Hello I'm running Access XP (German) along MSDE on an english Win2k server and I seem to have a problem with the DATEFIRST. The query SELECT @@DATEFIRST AS 'FirstWeekday' returns 7 in my SQL (MSDE) environment. But the same query returns 1 in my Access project (adp). The interesting thing is that it always returns 1, even if I use the SET DATEFIRST command on my SQL server to set it...
3 4/5/2006 10:12:41 AM
Convert from Access 2003 to SQL
We want to expand our DB from Access to SQL Server. 1)Is SQL 2005 stable enough to use yet? 2) Does anyone know of any documentation I can use to research this conversion (i.e setup, architecture, risks, benefits, disadvantages...) Thank you ...
2 4/5/2006 4:22:27 AM
Stored procedure
I have this problem and I hope that someone can help me. When I create a stored procedure in access Xp with this command: Set cnn = CurrentProject.Connection criteria = "create procedure " & ProcedureName & " as select * from " & Txt35 & " where " & Txt38 cnn.Execute (criteria) cnn.Close and I execute the procedure DoCmd.OpenStoredProcedure ...
7 4/3/2006 9:54:41 PM
44 Pages: <<  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  

Home | Search | Terms | Imprint
Newsgroups Reader