Search results

Hi Pierrick, I am using "update using view rules" just to give users permissions on views instead of tables and I am not adding any contraint to view. Access doesnt allow me to enter / update any data and says directly "recordset is not updateable" as if it's a snapshot. If I remove "update...

I am using Access 2007 with SS 2005. Below code selects multiple fields from 3 different tables. If I choose the option "Update using view rules" then I cannot update the records in that view. However If I dont choose that option then the view is updatable. The problem is that I dont want to...

I am used to use Access as a mdb files but now I am giving a serious try to Access projects (adp). If it was not adp setting default lock rule for the database would be quite easy but I couldnt find an easy way to do that in Sql 2005. I read something about transactional isolation levels but...

yes it solves the problem, you should add following tags to ribbon xml file. <contextualTabs> <tabSet idMso="TabSetFormReportExtensibility"> ,,,, xml code ,,, </tabSet> </contextualTabs>

it think I found the solution, in the following web page http://msdn.microsoft.com/en-us/library/bb187398.aspx it says something about "contextual tabset" and "TabSetFormReportExtensibility" which tell Access that "this ribbon should be displayed when related form or report is opened". I'll...

thank you for your comment mate but it's not the case unfortunately. Builtin toolbar menu in Acc 2003 was quite handy and quick. On the other hand ribbons, as far as I can see, offer more flexibility and more chic look. thank you.

any comment?

I am using an Access 2007 as a frontend and SQL 2005 as a backend. (ADP file not an mdb ) I am using 2 ribbons for my application and I have no problem with loading ribbons. My "MainRibbon" is the one used for navigation thru application. There is one form which has a ribbon called...

thanks SQL Hell, I think I need to make database of changes made to dev database before appliying them. It looked to me quite manual and risky operation, at least for me. Thanks for the recommendations.

Thank you SQL Hell, you got me right. I dont want to change data in production database cause they r real. I only want to apply changes, like new procedures, new functions, new views, new field in a table or modifications in procs. Let's say, there are procA and tableA with fields field1...

Hope somebody will show me the right path to my problem. I am preparing and adp file by using Access 2007 and BE is SQL Server 2005. The problem is making necessary changes b/w production and development database. Production database is running on a server and users are entering data or...

Thanks Banana, Simple yet effective trick.

I have an adp Access file using Sql 2005 as a backend. I have some forms in that project which has stored procedures as a record source. However I dont want to return all of the data when forms opened. My stored procedures used as a record sources are mainly selecting some records from multiple...

I am about to buy a new server and new software. I am thinking to install 64 bit Windows 2008 server and 64 bit Sql Server 2005. However the clients will be using the Access runtime 2007 to reach that server. Also the development computers are running 32 bit Vista business. I am trying to...

Hi, Hope I am asking my question in the right section. I'll try to create a database which will use Access as a Fe and SQL as a BE. I was looking for a outlook like navigation module / control /vba and found out that one : http://www.crosoft-systems.com/AON_product.html I liked its look and...

thank you pbaldy, appreciate your help

Hi everyone, I have a question regarding Access 2007 runtime, I was not dealing with Access for a long time, I tried to figure out possible disadvantages but couldnt find some. I'll write a small application in Access 2007 holdind some order information, Access will be front end and I'll use...

Thanks a lot for all your help Shadow

Thanks Shadow, looking forward for it

I was trying to apply Shodows's suggestions to my database for the last 3 days. However I couldnt come up with a working solution :( I am now using the Ghudson's method, at least they cannot copy my databse without my permission) What I did can be summarized as follows: I prepared a splash...