Rabu, 03 Juli 2019

Re: [MS_AccessPros] database very slow on network

 

hi Sarah,

Local will always be faster. One thing you can do to enhance performance is to use a short path. Where is the drive physically located in relation to where you are? And do you know the path of the cables?

a couple suggestions to help performance:

Use short primary and foreign keys like AutoNumber/Long Integer as opposed to text fields with big Size

Build indexes on fields that are used for searching

have an awesome day,
crystal

free code you can use in your projects
https://msaccessgurus.com/code.htm

On 7/3/2019 2:08 PM, sarahk@schemesoftware.com [MS_Access_Professionals] wrote:
I just installed a new application: MS Access 2003, split. When I run it on a network drive it is extremely slow, but when I run the exact same application on the local drive it is very fast. I had to move the front and back end to the local drive, just moving the front end did not improve the performance. its a small db , less than 3MB for now.

What could be the reason?


All help is appreciated.

Thanks??
Sarah

__._,_.___
Posted by: crystal 8 <strive4peace2008@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)

SPONSORED LINKS
.

__,_._,___
Diposting oleh di Tidak ada komentar:

[MS_AccessPros] database very slow on network

 

I just installed a new application: MS Access 2003, split. When I run it on a network drive it is extremely slow, but when I run the exact same application on the local drive it is very fast. I had to move the front and back end to the local drive, just moving the front end did not improve the performance. its a small db , less than 3MB for now.

What could be the reason?


All help is appreciated.

Thanks 
Sarah

__._,_.___
Posted by: sarahk@schemesoftware.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)

SPONSORED LINKS
.

__,_._,___
Diposting oleh di Tidak ada komentar:

Senin, 01 Juli 2019

Re: [MS_AccessPros] Dim Color

 

Dear Crystal,

Thanks a lot.

Best Regards,

Kevin

On 01-Jul-2019 5:41 PM, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] wrote:
??

hi Kevin

Color is Long Integer, not String

have an awesome day,
crystal

free code you can use in your projects
https://msaccessgurus.com/code.htm

On 7/1/2019 3:54 AM, qingqinga@yahoo.com [MS_Access_Professionals] wrote:

Dear All,


I my code is written as follows:


Private Sub Form_Current()

Dim clr01 As String

clr01 = Me.Parent.txt01

Me.Detail.BackColor = clr01

End Sub


After running, it returns error. Please help. By the way, the value behind the txt01 is RGB(0,0,0)

Thanks in advance.??

Best Regards,
Kevin

__._,_.___
Posted by: Kevin <qingqinga@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (3)

SPONSORED LINKS
.

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [MS_AccessPros] Dim Color

 

hi Kevin

Color is Long Integer, not String

have an awesome day,
crystal

free code you can use in your projects
https://msaccessgurus.com/code.htm

On 7/1/2019 3:54 AM, qingqinga@yahoo.com [MS_Access_Professionals] wrote:

Dear All,


I my code is written as follows:


Private Sub Form_Current()

Dim clr01 As String

clr01 = Me.Parent.txt01

Me.Detail.BackColor = clr01

End Sub


After running, it returns error. Please help. By the way, the value behind the txt01 is RGB(0,0,0)

Thanks in advance.??

Best Regards,
Kevin

__._,_.___
Posted by: crystal 8 <strive4peace2008@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)

SPONSORED LINKS
.

__,_._,___
Diposting oleh di Tidak ada komentar:

[MS_AccessPros] Dim Color

 

Dear All,


I my code is written as follows:


Private Sub Form_Current()

Dim clr01 As String

clr01 = Me.Parent.txt01

Me.Detail.BackColor = clr01

End Sub


After running, it returns error. Please help. By the way, the value behind the txt01 is RGB(0,0,0)

Thanks in advance. 

Best Regards,
Kevin

__._,_.___
Posted by: qingqinga@yahoo.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)

SPONSORED LINKS
.

__,_._,___
Diposting oleh di Tidak ada komentar:

[belajar-access] File - Tata Tertib dan Aturan.txt

 


Tata tertib dan peraturan
Mailing List: belajar-access@yahoogroups.com

1. Mailing list ini membahas mengenai pemrograman Microsoft Access.
2. Tidak diperkenankan mem-posting topik yang tidak ada kaitannya sama sekali dengan pemrograman MS Access, peluang kerja atau tawaran kerja sama dengan keahlian di bidang MS Access, atau pengajaran/kursus MS Acces. Pelanggaran terhadap aturan ini akan di-ban dari keanggotaan milis ini.
3. Mohon berdiskusi dengan baik, dengan semangat membangun, demi kemajuan kita bersama. Hindarilah perbantahan (flame) yang bisa menjadi pertengkaran yang tidak perlu.
4 Hindari reply permintaan one-liner seperti 'saya minta juga dong', 'saya setuju', dan lain-lain yang tidak perlu.
5. Sedapat mungkin memberikan data-data yang lengkap dalam mengajukan suatu masalah untuk memudahkan rekan-rekan sesama member mengidentifikasi dan mencarikan solusi, termasuk memberikan subject yang sesuai dengan isi email, tidak dengan kata-kata seperti "tologing dong", "pusing...", "ada yang bisa bantu..", dll.

Moderator

__._,_.___
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (148)
SPAM IS PROHIBITED

SPONSORED LINKS
.

__,_._,___
Diposting oleh di Tidak ada komentar:
Langganan: Postingan (Atom)