ASP.NET, SQL Server, WPF, C#, VB.NET

CENTRAL ÚNICA DE VENDAS 
 
10 Marcas de ratreadores, Compare e Compre. 
 
Rastreador de Veículo 
 
Rastreadores de Veículos 
 
Rastreador GPS 
 
Rastreadores GPS 
 
Rastreador Ituran 
 
Rastreadores Ituran 
 
Rastreador Portátil 
 
Rastreadores Portáteis. 
 
Assistência 24 Horas 
 
Visite agora mesmo nosso site. 
 
http://tel011-50523122.vila.bol.com.br/ 
 
Graber - Teletrim - Tele Trim - Ituran - 
 
Rastreadores gps , Localizadores, Bloqueadores 
 
Graber - Teletrim - Tele Trim - Ituran - 
 
Ra ...

If you have experience converting a MS-Access2002 business application (about 
 
130 different processes) to a web product with SQL backend and using , 
 
preferably, ASP.NET can you tell me: 
 
Did you use a conversion software product and, if so, which one. 
 
Briefly your experience - was it successful? 
 
Any tips and/or caveats? 
 
Comments are most appreciated. 
 
Thank you, 
 
Igor

If you have experience converting a MS-Access2002 business application (about 
 
130 different processes) to a web product with SQL backend and using , 
 
preferably, ASP.NET can you tell me: 
 
Did you use a conversion software product and, if so, which one. 
 
Briefly your experience - was it successful? 
 
Any tips and/or caveats? 
 
Comments are most appreciated. 
 
Thank you, 
 
Igor

If you have experience converting a MS-Access2002 business application (about 
 
130 different processes) to a web product with SQL backend and using , 
 
preferably, ASP.NET can you tell me: 
 
Did you use a conversion software product and, if so, which one. 
 
Briefly your experience - was it successful? 
 
Any tips and/or caveats? 
 
Comments are most appreciated. 
 
Igor

I use an ADO connection to add new records to a SQL Server 2K database. After 
 
a 
 
new record is added iit is supposed to be the current record. Yet, I cannot 
 
seem to retrieve the primary key (autogenerated) for the record. I just get a 
 
zero. The added data goes in and can be queried and viewed. Here is a code 
 
snippet: 
 
Dim cnSQL As ADODB.Connection   ' SQL server 
 
Dim rsTR As ADODB.Recordset     ' SQL table 
 
Set cnSQL = New ADODB.Connection 
 
Set rsTR = New ADODB.Recordset  ' ...

Hello 
 
I'm connected to foo2 dbase on sql msde server . 
 
? CurrentProject.BaseConnectionString 
 
PROVIDER=SQLOLEDB.1;INTEGRATED SECURITY=SSPI;PERSIST SECURITY 
 
INFO=FALSE;INITIAL CATALOG=foo2;DATA SOURCE=ADIXPD001 
 
I want to make a new access project , an adp file 
 
Dim obj1 As Access.Application 
 
Dim str1 As String 
 
str1 = CurrentProject.BaseConnectionString 
 
'Instantiate Access session 
 
Set obj1 = CreateObject("Access.application") 
 
'Save Access session as Access project po ...

I have Access database that contains column of type “OLE Object”. This column 
 
can store any OLE object including images, word doc, excel sheet etc. 
 
My task is to read this OLE data from “OLE Object” column & store it into a 
 
temp file say data.tmp so that the OLE data can be retrieved without any 
 
information loss. 
 
Since the definition of OLE object storage is not documented (contains some 
 
header information before actual data), simply extracting the field contents 
 
as  ...

here is the code it opens dab and then give the error 7866 when opoencurrent 
 
dbContab.Close 
 
Set dbContab = OpenDatabase(dirbase & archbase, False, False, ";pwd=" & 
 
clavebd) 
 
On Error GoTo 0 
 
'error 7866 exclusive mode which is not true when opendatabase why 
 
Set appAccess = CreateObject("Access.Application") 
 
appAccess.OpenCurrentDatabase dirbase & archbase, , clavebd 
 
For Each tdf In dbContab.TableDefs 
 
If Not (tdf.Attributes And dbSystemObject) <> 0 Then 
 
If tdf.Name  ...

If you have the "Use Access Special keys" (in Start up) unchecked in 97, you 
 
will not be able to step through code in 2k until you check this box, even 
 
though you could step through code in 97 without the box being checked. 
 
Thanks for the assistance Dave Patrick

I have just converted several Access97 DB's.  Now that they are converted I 
 
can no longer use the 'F8' to step through the code when I am in the visual 
 
basic window.  I cannot seemed to figure out why

I am writing a function that tests if a record has been created in a table; 
 
it is used before creating a record: 
 
Dim cvdb As Database 
 
Dim cvjoinrst As DAO.Recordset 
 
Dim cvjoinspec As String 
 
Dim mytest As Integer 
 
' specify the database 
 
Set cvdb = currentdb() 
 
' open the join table 
 
Set cvjoinrst = cvdb.OpenRecordset("joins_group_person") 
 
cvjoinspec = "[index_groups]=2 AND [index_persons]=8" 
 
With cvjoinrst 
 
cvBookmark = .Bookmark     ' Store current record location ...

Network OS = w2003, desktop = XPPro, Access = 2003 
 
Database #1, using all access tables and queries, uses the same code as DB 
 
DB #2 is linked to 4 SQL tables, and has 3 access queries, one of which is 
 
used by the main form. 
 
DB # 1 works when doing a record search. 
 
DB#2 using the same code (Copied from DB#1), fails with the "Not a valid 
 
bookmark error" message.  I have compacted and repaired several times. 
 
Started with the decompile switch - did not fix. 
 
rsObject.Supports( ...

Hi all, I have the following code in a module 
 
"Sub exeProperties() 
 
Dim db As Database 
 
Dim tbl As TableDef 
 
Dim prp As Property 
 
Dim str As String 
 
Set db = CurrentDb 
 
Set tbl = db!Books 
 
str = "" 
 
For Each prp In tbl.Properties 
 
str = str & prp.Name 
 
str = str & " = " & prp.Value 
 
str = str & " (" & prp.Type & ") " 
 
str = str & prp.Inherited & vbCrLf 
 
Next prp 
 
MsgBox "Books has " & tbl.Properties.Count _ 
 
& " Properties: " & vbCrLf & str 
 
End Sub" 
 
but the ...

Hi. 
 
I have an append query to call from within a vba module. I'm new to this so 
 
please excuse the basic nature of the question. 
 
The code I have looks like: 
 
sub AppendTemp() 
 
dim db as dao.Database 
 
Set db = DBEngine(0) (0) 
 
db.QueryDefs("appendQueryName").execute 
 
End Sub 
 
When I try to run this, I get "Run-Time error '3265' Item not found in this 
 
collection." 
 
The query is a long one so I thought it best to reference it from the VBA 
 
for simplicity. The query runs O ...

Hi, 
 
I'm looking to add a double field primary key using DAO - the same thing as 
 
highlighting 2 fields before clicking the PK button.  The code I have is 
 
below, and it keeps erroring out when I try to append the second index to the 
 
TableDef.  Please help! 
 
Thanks! 
 
'-----------------------Code Start--------------------------- 
 
Sub AppendKey() 
 
Dim db As DAO.Database 
 
Dim tdf As DAO.TableDef 
 
Dim idx As DAO.Index 
 
Dim idxfld As DAO.Field 
 
'code to add Sequence field 
 
 ...

add it into script to run sync? 
 
The script used to sync data requires fullname of file, including drive 
 
letter.  Some users map the network folder to differing drive letters.  I 
 
want to write a script to allow the user to browse to the location of the 
 
network data file and then drop the file name 
 
("P:\networkfoldername\appname\data\data.mdb") into the script below to sync 
 
to the local data file. 
 
intMsgBoxReply = Msgbox("Do you want to Syncronize your data file?", 
 
vbOKCanc ...

Hi, 
 
Subject is extremely vague, let me explain: 
 
Have a table with the following fields: 
 
ItemID (Pkey) 
 
Price1 
 
Price2 
 
.... 
 
Price 10 
 
I have some code which is used to retrieve a specific price for a specific 
 
item. The price returned is dependent on user input. ie: The user will 
 
request "Price1", or "Price7" etc 
 
Is it possible in VBA to retrieve the requested field using code similar to 
 
the following: 
 
Function GetPrice(ItemID as long) as Double 
 
.... 
 
rsTem ...

Hi, 
 
Anyone have any code to extract MetaData from Word Docs, Excel files, 
 
Powerpoint files, PDF Files, etc? 
 
Thanks in advance.

I have an Access 2000 database that contains six tables. They all 
 
contain the same fields (Object, Name, Desc, CodeNo). I want to copy all 
 
the data from each table into one big table in another database file 
 
(mdb). Is that possible? 
 
Thanks, 
 
Mark

Hey All, 
 
This one is weird.  I have a disconnected ADO recordset. 
 
I can filter on the first column no problem. 
 
gRSet.Filter = "ID= '" & UCase(txt1.Value) & "'" 
 
But if I change it to this I get an error saying Arguments are of the wrong 
 
type...etc. 
 
gRSet.Filter = "DOOR STYLE = '" & UCase(txt2.Value) & "'" 
 
Both underlying values are of string type and my arguments are of string 
 
type.  The only difference is that DOOR STYLE is the second column in the 
 
recordset. 
 
Here i ...

Hi, 
 
I am novice and I have problem. I need import some data with Excel file 
 
to Access. 
 
Problem introduces as follows: 
 
In Excel(first sheet) i have data: 
 
"TYTUL" - column "A" 
 
"NAZWISKO" - column "B" 
 
"IMIE" - column "C" 
 
"PRZEDMIOT" - column "D". 
 
Excel file name is AND.xls 
 
In Access i have table - AS_PRZEDMIOT. 
 
Table "AS_PRZEDMIOT" contains fields: 
 
ID_PRZEDMIOT (Auto), 
 
P_AKTYWNY (Number), 
 
P_ID_GRUPA (Number), 
 
P_ID_KATEDRA (Number), 
 
P_ID_KIERUNEK (Numb ...

Win2003, XP Pro, Access 2003 
 
Creating an Access app for a client.  Installed a prototype of 1st module on 
 
client's machine about two to three weeks ago.  Every thing is fine. 
 
Was adding some additional functionality today and when I try to open the 
 
database I get the error that says it cannot find the file.  Nothing has 
 
changed, same path, same file name.  Happens on new code as well as old code. 
 
New code is a copy of old code! 
 
Here is the code: 
 
cnObject.Open "provider =  ...

Highest rate for all type / brand 
 
24-Hrs +91 9810577227 Puri

Hi, I'm trying to add new record to a foxpro free table connect to the 
 
database by odbc. After all tests with DAO (the method don't accept '.update 
 
') I tried with this that I found on this site but always I get : 
 
Run-time error '-2147217900 (80040e14)' 
 
the code is (the ole db driver has been installed): 
 
Dim cnn As ADODB.Connection 
 
Dim cmd As ADODB.Command 
 
Dim fox As ADODB.Recordset 
 
Dim szName As String 
 
Dim szConnect As String 
 
Dim szSQL As String 
 
szName = "c:\fol ...

Hi All 
 
Please forgive cross-posting, also posted in 
 
'microsoft.public.access.modulescoding'. 
 
I have 'inherited' a part complete Access 2000 database which has in it the 
 
module shown below. The idea is, I think, to take a number of days and a 
 
start date then give the finish date excluding weekends and bank holidays. 
 
The problem is that while it is excluding weekends it does not appear to be 
 
looping through the dates in the table tbl_BankHols and excluding any dates 
 
in ther ...