Jumat, 09 September 2011

[belajar-access] Re: Access ke SQL Server ...

 

Tentu saja ndak bisa berlaku.

kan kalau di access project, nama tablenya sudah sama dgn di SQL Servernya.

kalau mo rename object dalam database pake aja sp mas.
namanya master..sp_rename.
contoh2nya bisa dilihat di :
http://msdn.microsoft.com/en-us/library/ms188351.aspx

by the way anyway busway,
kalau masih di bawah 10 biji sih rename langsung aja dari accessnya.

Salam hangat dan jabat erat,
Edy Wiyono

--- In belajar-access@yahoogroups.com, Andria Rismawandi <arismawandi@...> wrote:
>
> he..he...he.., suhu edy kalau di access project berlaku nggak mudule ini?
>
> salam,
>
> Andria
>
>
>
> 2011/9/6 Edy <murid.belajaraccess@...>
>
> > **
> >
> >
> > Program ini dijalankan kalau tangan sudah pegel rename manual.
> > Kalau masih bisa manual, gak usah pake program.
> > Ntar dimarahin loh... :)
> >
> >
> > --- In belajar-access@yahoogroups.com, Haer Talib <haertalib@> wrote:
> > >
> > > hehehe.. pake program :)
> > >
> > >
> > > On Tue, Sep 6, 2011 at 10:29 AM, Edy <murid.belajaraccess@>wrote:
> >
> > >
> > > > Silahkan taruh ini di module.
> > > > lalu jalankan.
> > > > Gunanya untuk menghilangkan tulisan "dbo_" tsb.
> > > >
> > > > Sub RenameDBO()
> > > > For Each tbl In CurrentDb.TableDefs
> > > > If Left(tbl.Name, 4) = "dbo_" Then
> > > > NewName = Trim(Replace(tbl.Name, "dbo_", ""))
> > > > DoEvents
> > > > DoCmd.Rename NewName, acTable, tbl.Name
> > > > End If
> > > > Next
> > > > End Sub
> > > >
> > > >
> > > > Semoga bermanfaat.
> > > >
> > > > Edy Wiyono
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > SPAM IS PROHIBITEDYahoo! Groups Links
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > --
> > >
> > >
> > > Haer Talib
> > >
> > > *RumahAccess Indonesia* <http://www.rumahaccess.com>
> > > *Tempatnya Belajar Microsoft Access*
> >
> > > Artikel | Forum | Milis | Download | Training | Links | Blog | Event
> > >
> >
> >
> >
>

__._,_.___
Recent Activity:
SPAM IS PROHIBITED
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.


A bad score is 598. A bad idea is not checking yours, at freecreditscore.com.
.

__,_._,___

Tidak ada komentar:

Posting Komentar