Recent content by susand

OLE Object not displaying - urgently looking for help Please help have been searching for weeks and getting no replies on forums. I have a inherited a db that has a table with symbol description and a graphic. Table is on SQL and data type shows as varbinary(2000) value = binary data, shows...

Hi, I inherited a db which is access front end and SQL back end and I am having trouble getting what I think is a blob to display in an OLE field. I am rather new at this so please forgive if I get it wrong. One table has a field which holds the shape name as text and then a...

I have a runtime db (2007) to create which will run on TS 2008. It will connect to SQL via odbc. I have searched the web and cannot really find much information on best practices for coding db's which will be running on TS. Can anyone point me in the direction of some documents or...

Fantastic people. Here is the db and sql db. I have left the original tables in the db along with my new ones. The offending forms we I am going to go through the ODBC doc. As I am just beginning this type of dev I would rather find out now what is happening so I don't run up against...

Hi and thanks for the interest. I have cracked it with a work around and while I would still love to know what the problem was I am feeling much better now. Below is the work around and also hopefully a good description of what was happening if anyone every does stumble on an answer. Work...

Okay we have progression of some sort. I created a new SQL backend with one table. Fields setup the same as the original db and table. I created a new form in the db based on the new db/table. When I create a new record after the form is open it saves the data to the underlying table and...

Yes I think it is something to do with the sql db setup - version is 2005. I am going to create a new db and see if I get the same results. The SQL db was sent to me already built but I have not had an others do this so finding the setting/difference is going to be fun.

Thanks for your help. I was trying to avoid re-coding the db. It was given to me three quarters done and was working fine on sharepoint. Then they moved the tables to SQL and it all turned pear shape and of course wanted it back quickly. I have noted that even if I enter data directly...

I have been doing a lot of work around on this just to get it going. In answer to your questions, yes the form is bound to the table and the fields are bound. What I have had to do is setup a button on the Main Form which opens up this form, instantly does a SQL insert into the table...

Thank you. The record stays in SQL but it shows with a note in the column that the row was successfully committed to the database, however a problem occured when attempting to retrieve the data back after the commit. If I close the form down and open it up the record appears okay. I have...

Question - Problem adding new records to SQL backend #deleted values I have an Access 2007 db which has been moved off a sharepoint server and the tables have been moved to SQL. I have created an odbc connection which works fine. When I add new records to the form and click on the tab...

Hi, I am trying to find a software that I can use to control my database versions on and store re-usable vba code. I am struggling with all the options on the web and not sure if any will store a .mdb file. Will be greateful for any help:cool:

We have an access db that has been working fine for ages and now when we click on a New Record button we are getting the following error:- Run time error 2105 - you can't go to the specified record. erroring out on the line DoCmd.GoToRecord , , acNewRec. We are not aware of anything...