Search results

I'm trying to delete that record from SQL Server. I also tried doing it from ACCESS. I'm not able to append any records. Thanks

Hello, I have a problem. I have an ACCESS2007 front end linked to a SQL Server 2008 back end which resides on a server. Somehow the primary key of a record in table 'A' on the back-end got corrupted. For instance, the record key is supposed to look like this "4NYC004571" and it looks like this...

Well, the diagram is on the back-end. Somehow it's not pasting the screen shot, sorry. Thanks again.

Hello, Why is it that after I compact and repair an ACCESS2003 back-end file, and then look at the ER diagram, duplicate tables show up? This is preventing some reports from running. Is there any tool to fix this? Thanks everyone

But, why would it run OK with the ACCESS back-end then? I thought that migrating the tables to SQL Server was better than having them in ACCESS, or at least things would run at the same speed. Thanks

Yes, some fields use the IIF function, others are calculated based on other fields (e.g: field1/field2 like you mentioned). I am using ACCESS 2007

Yes. This is the query that runs the report: SELECT Format(Avg(([SumOfTuition]-[SumOfAid]-[SumOfAmount])),'$#,#00') AS AvgFamilyContribution, Format(Avg([CountOfStudent ID]),'Fixed') AS AvgChildren, Format(Avg([Income]),'$0,000') AS AvgIncome...

Hello, Why is it that when I run the report from a front end, when my back end was an ACCESS file it would take 2 seconds to open, and now that I have a SQL Server 2008 back end (with same tables) it takes 5 minutes to open. The strange part is that the query that drives the report runs in 2...

Hello, Can someone give me a hand with this issue? Thank you very much

I would like to change the way IDs are created for the system, but the only problem is that inside each ID there are certain keys that indicate for instance the type of fund that is used to "fund" that kid's scholarship. For instance the ID "1CSP000034" indicates first that this is a child's id...

This is the executing code when pressing that button: Private Sub cmdNewStudent_Click() On Error GoTo Finish_NewStudent Dim strSQL As String, rst As DAO.Recordset, studentID As String, NewGuardianID, dbs As DAO.Database Dim i As Long, CurrentYear As Integer, IDNum As String Dim Region As String...

When pressing a createRecord button, the Guardians info is entered first with an INSERT stmt, and right after it the Students info gets entered again with an INSERT stmt. This is all done from the VBA code. Isn't this a locking issue? Thanks

That's exactly what's happening. Also, GuardianID is a foreign key in the Students table. thanks

Why would I want a M:M relationship between Guardians and Students. The idea is that 1 Guardian can have 1 or more students? Thanks

Hello, something really weird is happening with the db. I have an ACCESS 2007 front-end linked to a SQL Server 2008 back-end. All the users have the same front-end on their PCs. I have 2 tables Guardians and Students which are linked with a 1 to many relationship starting from Guardians to...

No, it happens to all of them. I am positive that it is not a size issue. Thanks

Yes, I'm looking at the table in datasheet view, and using ACCESS 2007. Thanks

Hello everyone, All of a sudden all the fields for a specific record on a table showed up with the ####### symbol. Is there any way to get that information back? Thanks

We misunderstood each other. The records are inserted into the tables as they should, so the main goal is fulfilled, but there is a little pop-up form which does some calculations that's supposed to show and it doesn't do it when the tables are linked to SQL Server. Thanks

Yes, there was 1 table that did not have a primary key but that's just a lookup table, and when SQL asked me to choose the primary key I did, so now all the tables have primary keys. Yes, I just added a record to a main table using Management Studio. Thanks