Hi everyone,
I am trying to connect access to mySQL with a DSN file, but every time I go to create one, I get an error - if I create it manually I get an error when I try to connect, something along the lines of ODBC error cannot connect.
Anyone know how to fix this?
TIA
Matt.
matthardwick
Last Activity: Sep 3 '08, 05:00 PM
Joined: Apr 8 '08
Location: UK
-
Because we don't have MySQL available to us.
I have kind of settle for just loads of HTML pages now instead.... -
I kind of wanted it to be online....Leave a comment:
-
Thanks, but that is meant for documenting PHP software that have javadoc style comments in them, that's not what I was after.
I want to create a HTML software manual for the people that are goign to be using my software on their desktops (not a web app) - and wondered if there was anything out there that could assist in that.Leave a comment:
-
End user documentation framework
Hi There,
Does anyone know of any software that I can use to provide end user documentation for some inhouse software?
It'd need to be flat file.
Thanks in advance. -
That's basically the same code, and it's what I started with (which didn't work) before I turned it into that. Property 4 is the same as connect.
All I did was just replace the old username and password with the new one.
And it's not another database that I need to connect to, it's the same SQL server - just need to change the username and password.
Thanks anyway.
Looks like we will just have to...Leave a comment:
-
I tried this:
...Code:For Each X In CurrentDb.TableDefs If Not X.Properties(4) = "" Then strXProp = X.Properties(4) strXProp = Replace(strXProp, "normal", "readonly") strXProp = Replace(strXProp, "1234", "abcd") X.Connect = strXProp X.RefreshLink End If Next XLeave a comment:
-
Thanks but that didn't work. It's really old code, and just wouldn't work in Access 2007 - threw no errors, but I was still getting prompted if there was no username and password, or it just wouldn't open the tables.Leave a comment:
-
connect to MS SQL with different user/password in VBA
Hi There,
I currently have all my tables in MS SQL and they are connecting in the standard way (used the external data section to link to the tables through ODBC in Office 2007 and the MS SQL 2005 Native Client).
I was wondering if there was a way in VBA before my database does anything, to specify a different username/password to connect to the SQL server with? I have 2 SQL Authentication usernames (one is read-only)... -
stop going to next record when user presses the enter key
I have a form that has lots of sub forms on it. The user shouldn't be editing the information that isn't part of the sub forms, and the fields are locked... but when a user presses return/enter - access seemingly progresses onto the next record for the parent form (and at the end it just goes to create a new record).
How can I stop access from going to the next record when they press enter?
Thanks. -
That didn't work, well it worked - but I still got the exact same error. :(...Leave a comment:
-
error on access sub form - record doesn't exist?
Hi Everyone,
I have a problem with Access that I can't seem to solve:
I have a sub form recordset changing acording to the value of a drop down box.
I tried this code:
...Code:Private Sub comboPatronTypeSelect_Change() If Me.comboPatronTypeSelect.Value = "" Or Me.comboPatronTypeSelect.Value = Null Then ''''''''''''''''''''' do -
default the find box to match "Any part of field"
Is there a way to make the find box (Ctrl+F) default to match "Any part of field" instead of "Whole field".
Thanks in advance.
Matt. -
That is absolutly perfect.
Thankyou soooo much - it's perfect.Leave a comment:
-
That would be good, although this is my project and I don't have any budget, so wouldn't be able to give you anything but gratitude for your time.
Would users be able to create their own new queries and reports?
Ta.
MattLeave a comment:
-
Limit interface to only reports
Hello everyone,
Is it possible to force Access to only allow the Reports and Queries sections of the interface, I don't want to allow people to view/edit tables or create forms etc.
Boss woman wants to be able to create queries and reports but I don't want to give her access to the tables.
Is this possible?
Thanks. -
I had this problem. I just changed the path of the database that they were already connecting to (or just the name of the file). Of course they then have an error, and you can say - oh you need the updated version - here install that and you should be OK.
Of course this updated version has a mechanism for for seeing what release they are using.Leave a comment:
-
It's already set to none. I wanted to know how to stop the form from being restored, removing the restore button, not how to stop it from being min/maxed which is what your solution would solve.
If you maximise a window you will see that the restore button appears, and it can't be got rid of.
like so:
...Leave a comment:
-
stopping a form from being "restored"
Hey everyone, I am always using this site for tips and things, but can't find an answer to this one, and thought it was about time that I got my own account!
I have a form, that maximizes [sic] on form load but,
I want to prevent the use from restoring the form, if you see in the top right, the restore button is still there, allowing the user to restore the form... this makes the form very hard to use, is there a method...
No activity results to display
Leave a comment: