Search results

The decision to move to an enterprise class BE is normally taken after a bit of "pain". You have experienced where Access, as a DB comes short and are hoping to squeeze a bit more performance out of the BE by migrating to a one of the top 4 enterprise class DB. You choices are MySQL, SQLLite...

Okay - my turn.:rolleyes: I have an Access app (duh) with linked tables to SQL Server 2005 at BE. I have a specific table that is the record source for a form. Whenever I try to edit data in this table it complains that someone else has edited or is busy editing the record. Gives me the...

Writeable Views The reason you will not find a reference to a "Writeable View" is because a view is exactly what it says. Another way of lookin at your table. You can write to it or read from it n exactly the same way that you would to a table. The thing that makes a query or a view...

No, you can't remove a clustered index. You can choose to have the clustered index on any column, the default is the primary key. The term clustered refers to the fact that the data in the table is physically stored in the pages on the hard drive in the order of the chosen clustered index...

Oops, I'm an idiot. Just looked at this properly now and realised that the format had included "/" in the name - a definite no-no in file naming conventions. The format chosen that used the hyphen is a better option. The issue I had in mind when replying earlier on was that the date value...

Also, if you are going to use LIKE and you need to do fuzzy searches (%something%) on a given column, create an index on that column. Particularly, configure your database for full text indexing and then create a full text index on that column. You can then use the CONTAINS predicate and your...

Try DoCmd.SendObject acReport, "Activity2Weeks" & trim(cstr(Format(Date, "ddmmyy") )) & ".xls"

Although Altova's XML spy is hugely expensive, it is a really worthwhile UML CASE tool. Take a look at it @ http://www.altova.com/ BTW - why not Visio?

Nope, the client is one of the top 3 users of SQL Server internationally. Their data is squeezed for every ounce of performance and they have 20 DBAs - all of whom have solid experience and formal training in everything from optimisig and tuning databases and queries to implementing, managing...

DLookUp takes 3 parameters. The first is the name of the field as a text value - in your case "FNAME". The second parameter is the table or query name - in your case "EMPLOYEE". The 3rd parameter is a criteria to search for within the table or query. This often trips one up because you may have...

Submitting data to table from form H57, the first thing I needed to solve in my head when i started working with Access is that one should not try to solve too many things just through code. Rather get into the mindset of forms, queries, tables and reports. If your want to change data...

I had a really nice tablet notebook. Didn't take a full backups for the last couple months. Had at least a 1 week old backup of the current project I am working on and I had set up my email system to deliver & receive from 2 seperate locations, so I won't have to be out of commission for too...

Normalising Mandatory? One of my clients have several database that grow by about 500gb per day. Yep, I mean .5 Terabytes. The size of these databases give one some interesting insights. The first is the need for normalisation during transaction processing and the second is the need for...

Errors in combo box & others Sorry for only getting back to you now. I was burgled this morning and my notebook was stolen, so I'm responding on a machine that i am still setting up - ie lots & lots of down time between everything. I reckon DKinley has already answered your questions in that...

Can you share the file elsewhere other than rapidshare please? I will look at it then and possibly give some answers. T

Record locking issues Can I add to that question please? I would like to implement some of the advanced record locking capabilities available in SQL Server 2005 as the BE environment within my apps. The isolation levels provided natively by Access level much to be desired. Anybody had any...

Parameterised Queries *&%^$# - I just spent quite some time typing up a decent response, only to have everything lost because the session timed out and I was no longer logged in.:mad: Okay, let me try again:( Method 1 Create a table (assume tbl_patient) & form (assume frm_patient). Enter...

MS Access writers... maybe Howzat from sunny Durban in South Africa. Yeah I'd be happy to write, depending on the topic. I particularly like talking about how to best get the right solution between SQL Server's Business Intelligence Tools, Access, and other alternatives. I guess it also...

1nf, 2nf, WTFnf - Look at performance What I really like about SQL Server is the tools given to answer specific questions like - is my database design optimal? All of the discussion so far is from the perspective of the human being interacting with the solution. It is either from the concerns...

To normalise or not to normalise is not the question I know that this discussion is a bit old, but I also know that many people will read up on the topic and may want to add to the body of knowledge, not just the discussion. In my case, I don't think that it is a question to be considered...