Search results

I have a problem with an Accessclient for which I am migrating the backend to SQL-server. The database contains contact-data amongst other, in particular a table "contacts" (relaties) and a table "contact_adresses" (relatie_adressen) in which for a contact multiple adresses are stored...

It works, I can put the whole "create table"-section in an execute (have to remove the newlines though) and the table is created. After that I can execute the constraints seperatly Means a bit of work on the scripts though (and this is just a simple one). I could perhaps automatically...

Tnx. I need to break it up for every line? Like: - SET ANSI_NULLS ON - GO - SET QUOTED_IDENTIFIER ON - GO - CREATE TABLE [dbo].[TBLBRIDGEPART_META]( [BRIDGEPART_META_ID] [int] IDENTITY(1,1) NOT NULL, [BRIDGEPART_ID] [int] NULL, [META_TYPE] [nvarchar](255) NULL, [META_TAG]...

I'm building an Accessclient which works on a SQL-backend (2008r2). I'm working on a VBA-module that updates the backend in steps, so that it's easy to deploy from DEVELOP to TEST, to PRODUCTION: the client will update the backend with the necessary changes (when possible if changes not too...

"Reason is that I got caught once with overhead cranes in the workshop."

I'm familiar with decompile, will try this. This can only be done however after compacting and deleting failing records (because nothing works on the tables if I don't do this) I'm not sure I know what you mean by your last remark ;) The customers are small insurancecompanies covering burial...

With the corrupt database: - first compact (will not open without it) - then iterate all tables: - "read" all data form all tables from all records/fields (do...loop, put every fieldvalue in a variable, thus reading every table//record/field) - copy every table (transfer to different...

Haha, not by any means. It's around 35mb after compacting, and I don't believe it ever gets more than 75/80 during the year (the backups are never larger than this)... But, you never know...however I don't have a way to check this atm. Now that I mention the backup, the backups are made from...

Never said that I never seen corruption, I have seen enough in different occasions (also not saying that I'm an absolute expert btw... ) although databases I have built have never corrupted (knocks off on wood) and I have built them for 10+ concurrent users in networks and are still running fine...

I mean inserting a value other than the next value the autonumber would create (not always sequential indeed) Because some of the corrupt records (2) have a value in the autonumberfield of 12 digits while the table generates a 6 digit value at the moment, looks like an insert by the program...

No seperate FE locally, it's not setup like that. Could easily be done by the way, but I'm only troubleshooting Every hour I spend is too expensive for client and customers up to now ;) probably problems like these will convince them otherwise Going to SQL has crossed my mind too but atm I...

No, the exact same app is not used elsewhere. In the course of years most customers use different adaptations of the same program (probably one of the reasons why the programmer left: situation becoming difficult to manage), so there are no other customers using the exact same app as the...

They are used in a LAN, with separated frontend and backend both on a networkshare, cabled. I know that networkproblems can corrupt a database, especially during datamutation and it might be the cause here. It's just that I think this "pattern" is a bit suspicious

A bit of a story, bare with me ;) I do support for a small company that has a few Access-databases built over the last 15 years, but the developer suddenly left the company just over a year ago (and just dropped everything) :banghead: That's not the problem (nor MY problem ;) ). I just jump...

Thanks, I'll test this a bit Would this mean that do openrecordset("select * from tbl where id=" & lngID) do something loop is faster than openrecordset("select * from tbl") do .find "id=" & lngID do something loop

Yes you are right, but in this case it's all existing code so implementing your suggestion would mean more extra code-adjustments to get an existing application to work (and would require more functional testing) But I find your remark interesting about sending data over the network. As far as...

Problem solved, with use of EOF/BOF and as little adjustments as possible: dim rst as DAO.recordset set rs= currentdb("select * from cities", dbOpenDynaset, dbSeeChanges) if not rs.eof and not rs.bof then rs.FindFirst "City = ""New York""" end if if Not rs.NoMatch Then debug.print...

You are right and I also normally check this. But the question is not how to fix it, but why .findfirst works on a empty recordset with a DAO-recordset on a (linked) access-table, and not with a DAO-recordset with a linked SQL-table. In this particular case finding no records at all should...

I have an Access-db, currently split in frontend Access 2013, backend 2013. I need to upsize to SQL-server. In this database the DAO-recordset is used a lot, not ADODB. In cases where data needs to be found the .findfirst method is used, which works properly when using the Access-backend. For...

I did not provide all information, but the Quotation_ID is an autoID/primary key. The database is small, at most a few hundred/thousand records will exist in this table. The DELETED field is used to keep records in the database when users delete records. So, normally users cannot actually...