If the access database is located on another computer, then you can
use date() function of the access database, which I suppose uses the
current date of the original computer.
for example
insert into my logFile(logMsg, logDate), values('hi', date())
Waqas...
On Wed, 1 Dec 2004 03:42:38 -0800 (PST), Arnold Marquez
<[EMAIL PROTECTED]> wrote:
>
>
> thanks for the information. but how about in VB do i need to run this
> command everytime i save a record in the database. actually, i have a
> transaction log database and i use it to save
> all the information when the user has saved and modified the records using
> the server date and time. can i do this using any API command or script?
>
> thanks
>
> Arnold
>
>
>
> Waqas Hussain <[EMAIL PROTECTED]> wrote:
> Hi Arnold,
>
> Here's an option..
> If your client's OS is NT based, i.e NT/2000/XP.. you can use a shell command
>
> net time \\myservercomputer /set /y
>
> this command synchronises time of current computer to the computer
> given in the command.
>
> Just figure out a way to run this command, and you'll be done..
>
> Waqas...
>
> On Wed, 1 Dec 2004 01:14:26 -0800 (PST), Arnold Marquez
> <[EMAIL PROTECTED]> wrote:
> >
> >
> > I want to synchronize date in my office network. How can i do this in VB?
> > i want to reflect the server date istead of the client date. is there any
> > possible way i can do this. as of now im using MS access database. pls help
> > thanks. . ..
> >
> > Arnold
>
> '// =======================================================
> Rules : http://ReliableAnswers.com/List/Rules.asp
> Home : http://groups.yahoo.com/group/vbHelp/
> =======================================================
> Post : [EMAIL PROTECTED]
> Join : [EMAIL PROTECTED]
> Leave : [EMAIL PROTECTED]
> '// =======================================================
>
>
> Yahoo! Groups SponsorADVERTISEMENT
>
> ---------------------------------
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/vbhelp/
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
> ---------------------------------
> Do you Yahoo!?
> Take Yahoo! Mail with you! Get it on your mobile phone.
>
>
>
> [Non-text portions of this message have been removed]
>
>
> '// =======================================================
> Rules : http://ReliableAnswers.com/List/Rules.asp
> Home : http://groups.yahoo.com/group/vbHelp/
> =======================================================
> Post : [EMAIL PROTECTED]
> Join : [EMAIL PROTECTED]
> Leave : [EMAIL PROTECTED]
> '// =======================================================
>
> Yahoo! Groups Links
>
>
>
>
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/k7folB/TM
--------------------------------------------------------------------~->
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [EMAIL PROTECTED]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
