Search results

I have been able to create an identical DSN from scratch and use that the same as the original. I have connected to the database using SIDU - opensource browser based client and it correctly displayed the only table I have in the back end. If you're interested I have no problem giving the...

Thanks for the response Banana, I've made the changes to reflect: MyConnectionString = "ODBC;Driver={MySql ODBC 3.51 Driver};" & _ "Server=XXX;" & _ "Port=3306;" & _ "Option=131072;" & _ "Stmt=;" & _ "Database=XXX;" & _ "Uid=XXX;"...

I've been reading many posts by Banana concerning remote back ends and connection strings and something that's been throwing me off is when I try to create a recordset based off my remote mysql server. I snatched my connection string from Carl Prothman's awesome site. The code is as follows...

I triple-taked the television when I overheard this. I think part of the problem of a majority of civilized nations criminal justice systems is the attention they pay to the criminal instead of the victims. Especially in cases where the direct victim isn't able to be present.

Thanks everyone for the input. The work consists of pieces of projects I have worked on for others, but is completely stripped of any recognizable traits - Logos/Themes/Etc. It's just the basic functionality. I think I get it, though. Keep the resume concise and simple, if they're interested...

Not sure if this belongs under small business or if the Watercooler will do. I'm beginning to put together a resume and I'm having a heck of a time figuring out if it's normal to attach a sample work with your resume. Anyone have any experience with this and know if that will hurt/help your resume?

Dfenton nailed it. These are design changes that are occurring on my forms through the run time. There is no problem with data anywhere.

That picture I included was only to demonstrate the dialog box that is popping up for clarification. It is not saving 2 new queries. I created those queries in a different database in order to get you a screen shot to show what dialog box is showing up. Within the accdr the dialog box asks to...

Thanks for the attention bob and dfenton, I'm certain that there are no querydefs being used. In another section of I make use of Tabledefs, but my problem is that the form design is changing, not data. If I was able to upload a front end I would but that's not something I'm allowed to do...

mcd I understand exactly what you are saying. I know exactly where you are going with this. I am attempting to cut you off at the pass and explain that is not what happened. Specifically, I am asking if their are any known bugs or anomalies present in ACC2007 where a file saved under that...

Yes, thank you for the reply. What I'm saying is the changes were made while the file was of the accdr file extension. Only the run time of ACC07 exists on their machines so it's not like they were able to get anything out of changing the extension, if they did.

I finished my post saying you can handle this automatically with the package you are planning to distribute. If you look at the 3rd part of the package wizard you'll see you have the option of adding additional files and below that any registry keys you need to add. You put your registry key...

I use a registry key. The reason why you are getting the warning message is because the database is not in a trusted location This is how I do it: Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\Location5]...

This problem is making my ::boggle:: In two separate locations with different users I have had an issue where they have somehow made changes to their front ends when the front end is saved as an ACCDR. Their computers only have the 07 run time installed. It was my understanding that no changes...

I dig it, thanks man

I've noticed in the past that if I have a button control on a form and have an code like such behind it: Private Sub BtnSaveClose_Click() currentdb.execute "INSERT INTO tblTable.* FROM tblTable.*;" DoCmd.Close frmForm end sub If I double click, or just click fast enough I can fire off...

dfenton thank you for your reply. I was actually hoping to get a response from you on this as I've had to reference posts of yours and your wiki on the subject through this process. Thanks for taking the time.

I've made progress bars in the past and I've sync'd replicas in the past. But something that's always been a problem for me is meshing the two together. With Access 2007 is it possible to create a progress bar for use during: Dim db As DAO.Database On Error GoTo CmdSynchronize_Click_Error...

You can move the window off screen completely, but then anytime your forms open up if they are set to center they will be lined up against the side of the screen the window has been moved off of. Or you can hide the screen, hiding the screen would require you to set all your forms properties to...

Agreed, but that's because your country sent all it's crazy wacked out religious nuts over here. (cough Puritans cough)