I need someone to help me.

1) My access database is very slow on client systems, only the server is ok with speed.
what do i do. network is wired not wireless
2) How can i convert the database to vb.net
3) How can i lock it not to allow access to the primary table.

Thank you

topea:

I need someone to help me.

1) My access database is very slow on client systems, only the server is ok with speed.
what do i do. network is wired not wireless
2) How can i convert the database to vb.net
3) How can i lock it not to allow access to the primary table.

Thank you

I will respond to your questions in hope that you will answer my own question at the end of this post:

1) How did you measure the speed of your Access Database? Are you measuring Speed times of read or writes? How do you know that the server speed is OK?
2) You can not convert a Database ( Access ) to a Programming Language ( VB.NET)
3) Why would anyone want to do this? Well one solution would be use a DB user ( I am not sure if Access even has this) that does not have access to the primary table.

Now my MAIN Question: WHY IN THE NAME OF SATAN ARE YOU USING MS-ACCESS AT ALL?

Cheers!

1) How did you measure the speed of your Access Database? Are you measuring Speed times of read or writes? How do you know that the server speed is OK?
The upload and write time on the server is much fast and almost instantneous, but it drags on the client before it uploads or writes


2) You can not convert a Database ( Access ) to a Programming Language ( VB.NET)
To what program can i export my tables, forms and reports to make it executable.

3) Why would anyone want to do this? Well one solution would be use a DB user ( I am not sure if Access even has this) that does not have access to the primary table.
Please tell me how to use a DB user.

Now my MAIN Question: WHY IN THE NAME OF SATAN ARE YOU USING MS-ACCESS AT ALL?
I am not a professional programmer and i just got to learn Access just as we learn excel and Word. I perfected it and able to do a lot with it. Did not learn programming perse.
I hope you can understand my position and assist to help me further.
Thanks

I can only anwer 2 and 3 right now:

Question 2: You cannot convert it to VB.NET because VB.NET uses web controls. Access uses Windows controls. However, you can 'connect' the Access database to the VB.NET. Here's how:

Open your VB.NET application. Click on Project menu, select component. Insert an ADO control. Select the ADO control. On the Properties, specify the Record source (which is your access database). Then, you specify the Data Fields (which are the fields in your Access Database).

Your database should be able to connect to your VB.NET application very well.

Question 3: You can stop people by using any of these options:
a: Hide the Primary Table. To do this, just select the table in the navigation bar of Microsoft Access. Right click it and choose Hide.

b: Alternatively, you can convert the Access Database to a MDE or ACCDE file. To do this, (if you are using MS OFFICE 2007) click on the Tools menu, click Database Utilities, then click on Make MDE file. But if you are using MS OFFICE 2007, click on the menu called 'Database Tools', then you click on Make ACCDE file'

Warning:The MDE or ACCDE thing is a permanent change o. Make sure you have a backup copy before you do it.

If you have any other challenges or other things you'd like to do, you can call me on 08037971139. PS: Access is very powerful. The only thingis that SQL Server or ORACLE are better Database engines for server-based applications

Thanks a lot .NET. I really appreciate this. i will let you know as it goes. If I have any other challenge I will sure let you know.

topea:

1) How did you measure the speed of your Access Database? Are you measuring Speed times of read or writes? How do you know that the server speed is OK?
The upload and write time on the server is much fast and almost instantneous, but it drags on the client before it uploads or writes


2) You can not convert a Database ( Access ) to a Programming Language ( VB.NET)
To what program can i export my tables, forms and reports to make it executable.

3) Why would anyone want to do this? Well one solution would be use a DB user ( I am not sure if Access even has this) that does not have access to the primary table.
Please tell me how to use a DB user.

Now my MAIN Question: WHY IN THE NAME OF SATAN ARE YOU USING MS-ACCESS AT ALL?
I am not a professional programmer and i just got to learn Access just as we learn excel and Word. I perfected it and able to do a lot with it. Did not learn programming perse.
I hope you can understand my position and assist to help me further.
Thanks

I tip my hat to you topea, most people would have taken my post as offensive but not you. You have been able to eloquently reply to most of my questions. I must say that I am quite impressed!

If you need any help or have any further questions , please put it here and I promise to offer as much assistance that I can give. ( Sorry I can not put my number)

And another point, if you continue with your attitude I am quite certain that you will become a professional programmer if you want to .

Thank you my pal.
I am a person that see objectivity in criticism, to me the post was make to challenge me
and make me to learn, so it is not at all offensive. thanks all the same.

@topea:
Sorry to troll and I'm not trying to diss you but you should consider upgrading your knowledge because I'm sure you are the only person in the world still using MS Access :d

Thank you all.
Can someone just tell me how to start a VB application?
Is one of those CDs we get to buy from computer village the right one to load?

Just get me to the point where the platform is loaded on my system and i can start and continue with my project.

I am willing to learn, please tech me.

Thanks

Hello again.

I was of the impression that you were already developing your application in MS - Access. Have you changed your mind?

Anyway if you need VB , you can install Visual Studio 2005 ( the last VS I was in any way familiar with) but it takes a lot of resources ( memory, disk space, virtual mem) and yes you can buy Visual Studio from the roads in Computer Village.

Visual Studio has Visual Basic as part of its suite of Applications as well as DB integrators for DBMSs such as Access.

Post if you need any further information.

BR,

tundebabzy:

@topea:
Sorry to troll and I'm not trying to diss you but you should consider upgrading your knowledge because I'm sure you are the only person in the world still using MS Access :d

wrong! I still use Microsoft Access. Yes, and it has proved helpful. In as much as I agree he has to upgrade and learn more sophisticated Database Engines, Microsoft Access is a powerful Database software. It's not every project that requires you to engage SQL Server or ORACLE. Some small databases intended to run on just a few systems can be arranged with Access.

Topea, you can get a free copy of Microsoft Visual Studio. I think Microsoft provides an Express Edition for learners to work with. Let me warn: It consumes a lot of hardware resources e.g RAM, Processor, etc.

Thank you guys. i appreciate you all. i will be asking for more assistance as i move further in the upgrade of my knowledge.

Thank you all once again. Please how can i build an SQL server? I also understand Access can be upgraded unto an SQL Server, i have tried this but its not working, it tells me SQL server name not valid or does not exist (not using precise words) but something in that line).

I see you all as my teachers and you will help me in the upgrade of my knowledge.

Thank you

You can either build an SQL Server database from scratch by installing the SQL Server software CD. Just buy MSSQL Server 2008. However, the express edition is free.

Alternatively, you can connect your Access forms to an SQL Server database engine by taking the following steps:

1. Open your Access database.
2. Click on the Database Tools Menu. In the 'Move data' subset, click on SQL Server. The wizard that follows should be able to help you connect your Access Forms to your SQL Server Database.

Gaskia!

.NET