Hi..Could anyone please share from experience code samples that can synchronize an Access 2000 database to a SQL server 2000 database. Access 2000 runs on a client PC and the sql server 2000 is on a server PC on a LAN.
Help is greatly appreciated.
Thanks!!
Mur
HI!! is it possible to Synchronize an Access Database with SQL Server. I want to use a VB interface and is it possible to use MS Jet Replication engine to do that. My requirement is as belows. I have my Main Database on SQL server. I want my users to enter data while their offline (on an Access...
Thnx for your reply. No i want replicate a SQL server Database and a Access database. I want to create a DSN for the SQl server database and replicate it thru the Access Database. Will it be possible..How shud i modify the connection to ODBC?.
Hi i found the following code in MSDN where Jet Replication is used to sysnchronize between two Access databases. I want to use ODBC connection for the second database (FY96.mdb).i want to know how can i use this code with a ODBC connection.
Sub JROTwoWayDirectSync()
Dim repMaster As New...
thnx david for ur reply...anyways the below code
shows how to send a fake/custom referrer (mysite.com)
along with the usual HTTP headers.
Private Sub cmdConnect_Click()
Winsock1.Close
Winsock1.Connect "www.brinkster.com", "80"
End Sub
Private Sub Winsock1_Connect()...
Specify custom HTTP Referrer URL
Hi!.My downloader program requires the above functionality. In other words, when selected a file from a site the users have the option of specifying a Custom referrer URL. (useful on some sites that provides you access to certain files only if you clicked from a...
here's the log...
Event Type: Error
Event Source: W3SVC
Event Category: None
Event ID: 116
Date: 11/8/2003
Time: 2:36:20 PM
User: N/A
Computer: MUR
Description:
The service metabase path '/LM/W3SVC/' could not be opened. The data is the error code.
For additional information specific to...
thnx for the reply.. well i did as greg said. so this time it d'nt restart but it freezed. no error was given.
well my VGA card is a SiS6326. Windows automatically installed the driver for that. but its not a unique driver it shows the driver as SiS53XX/6326 (5328 i suppose!)..
Also i think...
hi!..well my problem is that whenever i work on winXp suddenly the system restarts. and when booted again the system screen displays strage colors across the monitor (like a motif) and freezes.
I checked my VGA cards & re-installed the driver too. But i dont think the problem is an hardware...
well i put my monitor on repair, guys there told me its bcos of dust..i'll be very happy if it was the real reason, bcos i'm so broke i cant afford a new monitor.. :)
thnx for the replies..
mur.
Hi!! thnx for the reply. well i checked the cables & the VGA cards, tighten em up but no problem there. now the whole screen goes yellow. I hav so much work & my eyes are sored looking at the screen. do i hav to replace my monitor??
sorry for taking so much time to reply...
thnx!!
Mur.
Hi!, i've been experiencing strange red patches around my monitor recently. sometimes When i start my PC the desktop icon borders gradually start to turn red & the whole screen goes red and then greenish. sometimes it doesn't happen but i see 4 or 5 red bars around my monitor. is the fault with...
Hi!, i'm searching for some script that would send a bogus/false HTTP-referer when linked from one page to another.
in other words lets say. i want to go to,
http://www.xxx.com/pg2.asp
from,
http://www.xxx.com/pg1.asp
so here the HTTp-referrer value will be 'pg1.asp'.
what i want to do is to...
send Datagrid items to a recordset
Hi! i want to print datagrid items to a crystal report. So i hav to send the datagrid datasource
(in form1) to a public recordset2, which i can use to retrieve when loading the form2 (reportform)
so i would really appreciate if someone could make a suggestion...
thnx mark!! thats great!!!
may i ask another question??
how to define a sql recordset not a table as in,
Report.Database.AddOLEDBSource "connection", "tbl_name"
to
Report.Database.AddOLEDBSource "connection", "select * from tbl_name"
thnx!
Mur.
well thanks mark,,,but may i know what data tag & table number means, as in line
Report.Database.SetDataSource rs, 3, 1
I always get a run time error '9', "subscript out of range!"
Can u explain why this error occurs & also what does data tag & table number actually stands for...
Hi i use RDC (CR8.5) to display reports. I'm finding it very difficult on how to use unbound fields in a report.
i use the following code on Report form,
Dim cn As Connection
Dim rs As Recordset
Dim Report As New CrystalReport1
Private Sub Form_Load() 'report form
Set cn = New Connection...
well been awhile since i checked it out.
anyways it d'nt work out for me..
thnx anyway, for ur idea!!!
so i turned to the more easier way...
using a recordset & a variable.
[code]
rs4.Open "SELECT sum(p.installment) as TotalIns FROM Payment AS p where p.regno=" & lngRegno
varTotins...
How to use sum in SQL Update query.
Hi i want to achieve the following,
which is, the paidamt field in Student table shud be
equal to Sum of installment field (in table payments).
I wrote the following SQL but why it doesn't work..
cn.Execute "update students as s,payment as p
set...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.