Re: Connecting to Access Database on remote server - Visual Basic Discussion Boards

Re: Connecting to Access Database on remote server

fatali814-Jan-07 15:32

14-Jan-07 15:32

The server name is a1531sbits
The folder the database is in is in a folder named Databases in C:\
The folder has a share name of Databases$ with Permissions set to give everyone full access (This will change later and only certain users will have that ability)
The database name is users

I've tried the following as the file path in the connection string:

\\a1531sbits\Databases$\users.mdb
I've also tried
\\a1531sbits\Databases\users.mdb

Neither work. What am I doing wrong?

Re: Connecting to Access Database on remote server

Dave Kreskowiak14-Jan-07 16:16

Dave Kreskowiak

14-Jan-07 16:16

There are two sets of permissions. The Share permissions and the NTFS folder permissions. If you need people to use an Access database, both of these sets of permissions must allow Read, Write, FileCreate, Erase. Basically, full rights. You cannot have just Read permissions for some user who use the app because an Access database won't work at all without full rights to the folder the database is in.

Are your Windows machines setup in a Workgroup or Domain config? Basically, you to understand Windows networking. That's not something that can be taught in a forum environment.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: Connecting to Access Database on remote server

fatali814-Jan-07 16:48

fatali8

14-Jan-07 16:48

Yeah, I understand networking, wouldn't have my Net+ if I didn't. The computers I'm testing on here at home are set up in a workgroup, but the systems the program and database are going to be running in when I'm done are going to be in a domain.

Re: Connecting to Access Database on remote server

fatali814-Jan-07 17:10

fatali8

14-Jan-07 17:10

I went and changed the security settings on the folder and tried again, but it didn't work. I got this error message (after removing my Try..Catch statements)

"An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.windows.forms.dll

Additional information: No error information available: DB_SEC_E_AUTH_FAILED(0x80040E4D)."

Re: Connecting to Access Database on remote server

Dave Kreskowiak14-Jan-07 18:26

Dave Kreskowiak

14-Jan-07 18:26

Did you password protect your Access database or enable workgroup security in it?

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: Connecting to Access Database on remote server

fatali815-Jan-07 3:53

fatali8

15-Jan-07 3:53

I did a while ago, but I wasn't able to get connection strings to work with it so I removed them.

Re: Connecting to Access Database on remote server

Dave Kreskowiak15-Jan-07 5:29

Dave Kreskowiak

15-Jan-07 5:29

fatali8 wrote:
so I removed them.

Something got missed because that's where the security failure is comming from.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: Connecting to Access Database on remote server

fatali815-Jan-07 5:40

fatali8

15-Jan-07 5:40

No, I got them all. I figured out what happened. For some reason my connection to the server got messed up somehow.. I could Remote Desktop to it, but I couldn't map any shared drives/folders and I couldn't access any of my previously mapped drives. I've had it happen before, and I'm pretty sure it has something to do with the fact that when I turn off my PC I Hibernate it, mainly because I have work open and don't want to wait for them to all open up again. As well as that, I missed a part in my connection string that had username and password information from when I was trying to connect to a DB with a DB password. That kind of mistake makes you want to say "idiot" doesn't it? lol.

Anyway, now after a restart I got it to work. Thanks for all the help. I got more help from you than I did in all of the other 4-5 forums I've asked in combined. From now on I'll just come here when I need to ask a question. Again, thanks.

Simple question on text?

rudemusik14-Jan-07 6:59

rudemusik

14-Jan-07 6:59

Hello All!

I have two forms in a project. vb.net. I just want to take the value from 1 textbox on a form, and put it in a string in another from.
My code.

 Public Sub frmGoodLuck_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load<br />
        Dim MainFrm As New Mainfrm<br />
<br />
        lblGoodLuck.Text = ("$" & MainFrm.txtTblID.Text.ToString & " has been added. & Good Luck!!")<br />
<br />
    End Sub<br />
End Class

What am I doing wrong?

Thanks! Rudy

Re: Simple question on text?

MatrixCoder14-Jan-07 8:01

MatrixCoder

14-Jan-07 8:01

2 quick questions. Did you get an error message? And does the label txtTblID exist on MainFrm?

Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.

Re: Simple question on text?

rudemusik14-Jan-07 9:23

rudemusik

14-Jan-07 9:23

Hi Matrix!

No error. and lblTblID does exsisit on Mainfrm.

Thanks!

Rudy Big Grin | :-D

Re: Simple question on text?

MatrixCoder14-Jan-07 11:17

MatrixCoder

14-Jan-07 11:17

Well, I'm not sure what the problem is. But here are a few steps that might fix it:

1. Make sure that there's pre or otherwise set text in txtTblID.
2. Try saving your text to a variable, then reading the variable from your label.

And, what exactly happens when you try to set text to your label? Is the label just blank?

Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.

Re: Simple question on text?

Christian Graus14-Jan-07 11:58

Christian Graus

14-Jan-07 11:58

It's blank, because he's getting his value from a newly created instance of the form.

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

Re: Simple question on text?

Guffa14-Jan-07 11:39

Guffa

14-Jan-07 11:39

You are creating a new instance of the Mainfrm class. That instance will work independently from the one that already exists.

You have to use a reference to the form that already exists in order to access it's controls.

---
Year happy = new Year(2007);

Re: Simple question on text?

rudemusik14-Jan-07 12:33

rudemusik

14-Jan-07 12:33

Hi Guffa!

Could you give me a quick example.

1) myMainfrm.Show()
myMainfrm.GetTblID(Me) NAME OF FORM <"loggonfrm">

2)Public Sub GetTblID(ByVal TblID As Loginfrm)
txtTblID.Text = TblID.txtTableid.Text
End Sub NAME OF FORM<"Mainfrm">

Something like this?

Thanks!
Rudy

Re: Simple question on text?

Christian Graus14-Jan-07 12:36

Christian Graus

14-Jan-07 12:36

No - do NOT do this. Do NOT make your form elements public.

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

Re: Simple question on text?

Christian Graus14-Jan-07 11:57

Christian Graus

14-Jan-07 11:57

Well, your whole approach is wrong, your controls should not be made public. Instead, expose a property called TblId, or whatever.

rudemusik wrote:
Dim MainFrm As New Mainfrm

This is your problem. You're creating a new MainFrm instance, which as no text on it. It's a different instance to the one that contains the text you want. You could get around this with a static property, or you can set up delegates to pass the info. It looks to me in this instance that you should either pass the value of the text to a constructor, or set a property that sets the GoodLuck label on this form, as MainFrm is obviously the class creating this one, and as you're handling the load event, it's obvious you want to set the text when the form opens.

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

Re: Simple question on text?

rudemusik14-Jan-07 18:08

rudemusik

14-Jan-07 18:08

Thanks Chris!

I see where my problem is. So what are some of the reasons I don't want to use Public? I never gave it much thought. What harm could it do?

Thanks!

Rudy Smile | :)

Re: Simple question on text?

Christian Graus14-Jan-07 18:18

Christian Graus

14-Jan-07 18:18

It's just bad practise. The whole point of OO is to write objects that hide their inner workings. Expose only what you need to, which in this case, is a string, not a textbox.

IT's not that your program won't work, just that it's better to form good habits.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

communication between forms

klakero14-Jan-07 3:51

klakero

14-Jan-07 3:51

i'm using VB 2003, i want to make form with a button that open another form and in do some processes, and close the form, but i want my first form to know when it's done so i can do another process.
anyone have any ideas on how to do it ?

Re: communication between forms

Colin Angus Mackay14-Jan-07 3:58

Colin Angus Mackay

14-Jan-07 3:58

You can read this article on passing data between forms[^]

Upcoming events:
* Glasgow Geek Dinner (5th March)
* Glasgow: Tell us what you want to see in 2007

My: Website | Blog | Photos

To attach to a Com+ Application

tamasu14-Jan-07 3:08

tamasu

14-Jan-07 3:08

How can I make my application attach to multiple com application? I would like to provide a list of com applications installed on the user's pc.

For this reason I can't create a reference to the com object during runtime. It should be dynamic as per user selection. It could be an Excel, Word or other com application.

Summary

1) To get a list of all com applications available on the user's pc

2) To create a reference dynamical to what the user chose.

Thanks

some Components it's location is changing by themselfs vb.net 2005

kindman_nb13-Jan-07 16:24

kindman_nb

13-Jan-07 16:24

Hi ..
It's funny problem that the components of the form is changing it's location by themselfs ,
I'm wondered D'Oh! | :doh: