Recent content by marks2007

Hi, I am using SQL Server 2005 I try this select firstname & lastname, id from list I get error,it seems '&' is wrong. Please let me know how to combine the two fields Thanks Mark

Hi, I have a problem about SQL outer join I have two tables ----------- table one id value1 1 a 2 b 3 c ------------- table two id value2 2 d 4 e 5 f --------------------- I like get the results id value1 value2 1 a 0 2 b d...

Hi, I try this way but it doesn't work SELCT * FROM TABLES WHERE ApplDt > 2007-10-01 which format I have to use.Thanks Mark

But CHANGE LOGON PASSWORD is used for current logon user and not for the new setting up user. May I change password for any users?Thanks Mark

Hi, I add a new user through the menus Tools -> Security ->User and Group Accounting -> users -> new But I do not know how to set a password to the new user. Please help me to find out this Thanks Mark

How to do decompile? and why we need to do that? Thanks Mark

I have a question. sometimes I can not open the code again after I change the code in module. I have to redo the coding. Do you know why? Do you have the same problem before?How do you fix this. Thanks Mark

Hi WayneRyan, the code is like this Set tdf = dbs.TableDefs("tblSomething") tdf.Connect = "Driver={SQL Server};" & _ "Server=" & Me.txtServerName & ";" & _ "Database=" & Me.txtDatabase & ";" & _ "Trusted_Connection=Yes;" & _...

I build a adp file and add a start up form in it. But I have to enter database password when I start to adp app. May I embed the password in adp file so I just see the startup form without asking password. Thanks Mark

Hi, I want to know how to build a linked table to SQL Server view with DSN - less connection.I can not do this from menus and I hope I can do this with VBA code. Thanks Mark

I am using Access 2003 aS FE and SQL Server as BE. I read a article that said you can change Subdatasheet Name Property to none in BE and then application performance will change better. But I do not know how to change Subdatasheet Name Property if I use SQL Server as BE.Please help me .Thanks...

Hi I moved all of my tables in from access to SQL server 2005. But the forms are very slow now ,update and add data forms are more slow. Please give me a idea how to fix this.Thanks for your help Mark

Yes.I check SQL database .they are index names,do I have to keep the indexs in SQL Server.Thanks

Hi, I get some strange index when I upszing a Access to SQL Server This is part of report Loading objects into database... Analyzing metadata... Preparing schema TESTTAB.dbo... Preparing table TESTTAB.dbo.[Conversion Errors]... Preparing table TESTTAB.dbo.[MSysCompactError]... Preparing table...

Hi, I have a Access 2003 application that include two Access files(one for frontend and one for backend).it works fine. I just move the backend Access file to SQL Server 2005.now I use Access 2003 front end to access lined tables with DAO and the linked tables are linked to SQL Server 2005...