Search results

I am executing existing Access queries as stored procs from a .Net application. I create a connection and command object with the command text of "Execute QueryName". I then use the ExecuteNonQuery method and the query runs. That part is fine. The problem I'm having is that Access will...

I have not yet resolved the problem. In this particular case I was able to use a different PC as the server to avoid the problem. However, it will come back to bite me in the ass again in the future no doubt. In my opinion Access 07 has added many more headaches than advantages.

That is how I have it setup though. Each user has their own front end linked to one back end. However, as soon as one users interacts with the data in anyway user two's application is completely frozen until user one is no longer editting data. I can put two unique copies of the front end on...

Thanks for the reply. Here is the setup: Computer 1 and Computer 2 each have a completely unique copy of the same front end linked to the same back end database. Computer 1 Contains: C:\Folder\FrontEnd.mdb Linked To C:\Folder\BackEnd.mdb The folder C:\Folder is shared. Everyone is a...

Any ideas would be helpful as I'm stumped. Thanks -AC

I have an Access 07 application with a sepparate front end (FE) that links to a back end (BE) via linked tables. When I connect a second FE to the BE across a windows network the application freezes until the local front end no longer has any connections to the data open. This situation seems...

Yeah, I'm all up to date. However, when reading the hotfix page it specifically mentioned a problem setting specific printers in 07. I have another application that does that. In the event we start running that with A07 that bit of information will be usefull. thanks.

:) Yeah that or a hotfix from Micro$oft.

Thanks for the reply...but no I'm not closing the form like that. I also searched the entire project for the accidental inclusion of code like docmd.RunCommand acCmdSave Like filters the property just seems to save itself on occaision.

I have recently started running some 2000 and 2003 format databases with Access 2007 and have noticed a few annoying issues. The one I'll discuss in this post is the fact that properties seem to "stick" or save in 07. I've read quite a bit about filters saving on forms but I've had other...

Use the PlainText() function.

Use the PlainText() function.

I have form where I allow users to create mail merge letter templates. The form is basically a memo field that contains regular text and some merge codes which I later replace with data. Example: Dear <<FirstName>> <<LastName>> I also have a popup form with a list of all the available merge...

Thanks for the suggestion. Using the VS 08 deployment package builder I can do everything I need except build the appropriate Access shortcuts. There is a way to build the shortcuts I just can't figure it out. We have now written our own shortcut builder that is called by the installer...

The solution I'm installing just happens to contain multiple applications. The problem I have is creating shortcuts, be it for 1 app or for multiple apps. The Access Deployment Package builder doesn't allow me to install the application where I need it to go and it only allows me to...

For now I am building a small VB App to create the shortcuts I need during the install. It should work, though there must be a better way. If anyone has created a working Access shortcut using Visual Studio built deployment package please let me know. Thanks...

I have an application built in Access 07 that I need to install. The installer included with the Access 07 developer extensions is not flexible enough to allow me to install the application properly. To be more specific my application has multiple pieces that each require shortcuts and I need...