Search results

Using MS Access 2010 'ACCDB' file type. I've been asked to encrypt the db and if it is using 'AES256'? Is this the default stanfard for 2010 and is it any stronger for 2013? Can it be changed in the Windows registry/MS Office settings?

(Access 2010). I'm using the following vb code to import from a csv file: DoCmd.TransferText acImportDelim, strFileImportSpec, strTableNameImport, gb_strPathAndFileName Everything imports fine yet I always get the standard 'Duplicate records violation MS Access error message': 'MS Access was...

Recently, some users have been unable to open a shared db (un-secured) via a shortcut or direct from the file itself, yet they can if they open MS access (2003) first an THEN open the file from within. I've checked that all users have write permissions to the folder and that mdb files 'open...

When I use the built in 'Find and Replace' utility in a subform (datasheet view), it does the replace on multile rows but when I try and navigate to another record on the main form I keep getting an error mesage 'Operation Not Supported in Transactions' and have to close the form and all the...

These days more and more of my databases are wanting to be accessed via the web as well as from MS Acess. I guess this is the norm these days but in most of our (office) dbs it's just 'web for web's sake' and there is no real need to access it outside of Ms Access. Bu hey that's what they...

I'm using CDOSYS and SMTP in a vb function to send emails via Ms Access 2003. My code loops through a recordset an sends an email to the email address in the table. However, all works fine until an invalid email address is encountered, at which point I get an 'Invalid address' error message...

In MS Access 2003 my tables are linked via a SQL Server. I'd like to change the default long-winded 'ODBC etc etc 'error message when a duplicate PK is added to a table to a more user friendly 'plain english' message. Can this be done is Access, VBA or even on the SQL server? (which I have acces...

In all my years of developing 100s of databses I've never managed to pin down a way of creating a good interface for a 'timetable/schedule' type database. Problem has always been is the users like to use a spreadsheet style interface with multiple columns as date headings and be able to edit...

In my SQL Server table I have a field that stores a literal string math formula, i.e '2*3', '2(3+5)', '2*3' etc How can I execute this actual formula and produce a result via a view, UDF or stored procedure? I'm looking for the MS Access equivalent of the 'EVAL' function which for security...

N.B. This is not your usual 'Bad practice to Store calculated values in a table' post I have a table of items. Each item has a different formula attached which I need to store as a literal value in the table and execute it as a normal expression in a query or vb. e.g Columns:Item, QTY, Hrs...

using T-SQL 'alter table' script I need to alter the first column of MyTable so that it isn't and IDENTITY column. The name of the column will not be known at runtime, but it will always be the first column (colid=1) and the only IDENTITY column in the table. Many Thanks

I have (wiil have) several linked tables on SQL Server. A 'one' and about five 'many'. I need to keep a 'version number for each record and it's related records. Basically it's all in 'spec' info and each year these are revised and a version Date is given and recoreded for that set of spec...

I need to keep track of several linked tables in a db... What I need is a verison ID and Version Date and 'wrap' it around each record and it's related records. In the future some records will be amended. When this occurs a new version ID and Version Date will need to be created for it and...

On my web page (asp.net 2) a paramater is passed via a querystring from a previous link to output a list of staff emails from a stored procedure on SQL Server. This is displayed in the gridview control. My question is, does this offer sufficient protection from spammers, if any at all as...

I'm 'linking' to images for MS Access (2003) in the usual way, i.e. by storing ID numbers in a table and naming the images as the same ID numbers but NOT storing them in teh db, just linking via the file path and displaying them with an unbound image. This works well on a single form but you...

When Binding a Datagrid, Data List or Repeater control to a simple MS Access Query...."SELECT [MyID], [MyField] FROM MyQuery WHERE My ID=" & inMYID works fine if there is more than one record BUT if there is only ONE record retrieved it doesn't show anything!! (Also tried 'SELECT *...' ) I've...

I have a MS Access 2003 db in a 'db folder' in my web root which has the necessary read/write permissions set. If I open the db directly ('normal' mode and NOT 'Design' mode) from my server using MS Access (as an Adminstrator) then web users cannot open any asp.net pages connected to it. I get...

Using the MS Northwind db as an example and without changing the table/rel structure or using vba, how can I implement the follwing... 'Customers cannot use the same Product Category more than once'. i.e. on a customer order form a list (query) will show products from only categories that they...

I have two tables.... 1. Tutor Projects where Many Tutors will have many Projects. SupervisorID PK = ProjectID 2. Student Projects where a Student will pick many Projects from above. Comp PK=StudentID and ProjectID. Now they want it so each student can't pick the same tutor more than once...

In asp.net 1.1... I have a datagrid bound ti a database table. Column(0) is a boundColum bound to Field1 Column(1) is a templateColumn which has a dropdownBox which is bound to Field2. When I select a different value in the Dropdown I want it's 'OnSelectedIndexChanged' to trigger a function...