Search results

Hi, When I make the Application role active, the User function will be changed to Application name. How can I retrieve the current user name (Window network user id)?

Hi, I created mdb and ADP files. Both file tables are from SQL Server. When I input the data on the forms in mdb, it works faster, whereas running ADP, it works a bit slowly. I thought that ADP is faster to run the forms. Maybe ADP access the tables faster, whereas run the forms slowly.

Hi, ----mdb file if DCount("*", "tbl1", "Format([Date Submitted],'m/d/yyyy') < #" & DateAdd("d", -2, Format(Now, "m/d/yyyy")) & "#") > 0 then ............................. end if -- ADP if DCount("*", "tbl1", "CONVERT(Char(10), [Date Submitted], 101) < '" & DateAdd("d", -2, Format(Now...

Hi, When I input the criteria in the View, it will show N before the word, what's that mean?

Just basic Views, I create the query (select * from tbl1 where [f0] = 'a') in the MS Access. I want to move this query to SQL Server. I went to Tools->Database utilizes->upsiding wizard It only work for tables. no queries. We cannot move queries to SQL Server.

Hi, I create the application role. But, I want to update the new password on each month. So, do we have statement to update/modify the password on the application role? And, can we copy application role and paste it with the new name?

Hi, I know how to move the tables from mdb to SQL Server. But, how can I move all the queries from mdb file to SQL Server?

I know that same mdb file can support 225 simultaneous users. If I use ADP, how many users can access the same adp file at the same time?

Hi, I want to do Sendkeys "{NUMLOCK}" when the form is Active. But, the sendkeys statement doesn't work. I want to use the VB code to turn on the NUMLOCK. And, I want to check whether or not the NUMLOCK is on/off, how can I check it?

Hi, In SQL Server, I have one table called "tbl1". I have 3 fields, f0,f1,f2 f0 is primary key I linked this table to MS Access. I insert data of the f1 in MS Access environment, and delete it, the <Null> value is still shown in SQL Server table, if I delete the value in SQL Server table, then...

Hi, I apply Compact On Close (Tools->Option->General tab). So, every time, it will compact the database when closing the file. However, will it do repair the database automatically? It seems just do compacting.

Hi, In View, can I use DLookUp("[ID]","Employees","[Username] = '" & Environ("username") & "'") statement in the criteria? Thanks.

Hi, I have 2 databases, db1, db2 in the SQL Server. In db1, I created the view to link one table from db2. When I run it, it is just read-only, I want to edit/insert data in the view. Can we edit/insert the data in the view from db1(which linked table from db2)?

Hi, I saw many posts in here. Most of the posts are said that we need to use Access Developer Edition to distribute the Access Runtime for our clients. Can we just buy/use the Access RunTime Modules and unlimited licenses without using Access Developer Edition?

Hi, I have full version MS Access, and Office Developer Edition to disribute the Access RunTime for my clients. I don't want to create the package (adp file), I just want to create the package for Access RunTime, and then install it into my client machines, we want to run the same adp file on...

Hi, I created the table in SQL Server, and the fieldnames are as field0 => char (and setup this field as primary key) field1 => char Select => bit After that, I used ODBC link the table to MS Access database, I input the data in the linked table in MS Access, then I jump to next record...

Hi, if I link the SQL Server to MS Access, then execute application role to grant read permission to the user when the user open mdb file (forms). Can we use this way in the mdb file?

Hi, Suppose I have sharing drive, let's say "\\server1\sharefolder\Databases\db1.mdb" if I run this CurrentProject.Path inside the database file, it will retreive the current path with drive letter, but how can I retreive the server, and sharefolder information?

Hi, I created the table1 and one application role (read/update permission) in SQL Server, and then link the table1 to the MS Access. I created the form1 in MS Access, and attach the recordsource = table1, and I write the codes which execute the application role (make it active) in order to...

Hi, When I restore the database, I got this message, The media set for database 'ASP.NET' has 2 family members but only 1 are provided. All members must be provided. RESTORE DATABASE is terminating abnormally. What's the problem?