Search results

Is there a quick way of deleting relationships on linked tables. I did an "analyze" of a form and it recommended creating relationships for 2 or 3 tables. I took the automated option and it created relationships for all of my tables, some completely inappropriately, and when I try to delete...

I found a way to unreplicate the front and back ends and that seems to have worked. Thanks for your help

my application is split. I will unreplicate and compact the front end as you suggest.

Initially only my back end was replicated but I did a Create Replica and the whole thing became replicated. One of the options when it crashes is to save and then compact. I have done that and also separately compacted it. I have got to the stage where it only crashes when I save a single...

And access database would easily handle this. Set up a location table with the following fields: key(autonumber); area(number); Location(text); date; time; problems(text) The reports can easily be produced from this table

I have tried saving another form which uses similar tables and I don't get that message so I think I will have to open another thread. It must be unrelated to replication.

Thanks, checked the replicable box and that worked, but now my database is crashing everytime I try to save it. with a message "ms access has encountered a problem and needs to close." I wonder if this is related to my replication problem?

I have a mdb with a frontend and a backend. I replicated the be using briefcase and then had to add a few more tables. I now have a be which has replicated and un-replicated tables. When I try to replicate the be, only the previously replicated tables are replicated and not the new tables. What...

Sorry. I have been delayed. I use unbound forms with the occasional dip into ADO. This is the code I use for adding the new record: DoCmd.GoToRecord , , acNewRec

on the point of closing and setting recordsets to nothing, what is the default action if you forget to do this and the module is closed and re-opened with a "new" recordset each time?

This is the code for the exiting the input form. I note that I don't haven't closed the recordset or set it to nothing. Maybe this is part of the problem? Private Sub cmdExit_Click() On Error GoTo Err_cmdExit_Click Dim rst As ADODB.Recordset Dim strSQL As String strSQL =...

On top of that it works ok on my test machine and my test network, so I was thinking maybe it is something to do with whether it is "trusted" or not or permissions on the server. How would I check this.

It is my database, and I have the code, I am the developer. There is locking in place, but I close the entry form before trying the report, as only one window is visible at a time. I will look at the underlying query, but how will I know whether it has been opened or not in the mde?

I haven't tried that but what do you mean by a trusted location?

I have installed a split database mde as a runtime version on a users network, but I have had a major problem. When I key in new records and try to look at them with a report, nothing appears, although when I look at the input form the records are there. The report should open in preview mode...

That sounds like what I want. I will give it a try, Thanks

I have a split database with a mde front end and mdb backend with all the tables. I added a table to the backend and want to know the best way of distributing the new table. I use the package wizard to create a package to renew the frontend, but I don't want to override what users have done on...

Sorry for the delay! I tried Bob's suggestion on concatenating: KeyExpr: [KeyConcat]=[DateVisit] & [Company] & [MemberNumber] and the following code: Dim strSQL As String Dim rst As Recordset Set rst = Me.RecordsetClone strSQL = "KeyExpr = " & lstClinicVisit.Column(0) & _...

oops I mean I stand corrected!

Does this mean that there is no quick fix for the existing situation? I stand correct in my terminology.