Search results

I cannot figure this out. UPDATE tbl_Vendor_Release_Info INNER JOIN CMSqry_Vendor_and_Contacts ON (tbl_Vendor_Release_Info.Vendor_No = CMSqry_Vendor_and_Contacts.VENDOR_NO) AND (tbl_Vendor_Release_Info.Div_No = CMSqry_Vendor_and_Contacts.DIV_NO) AND (tbl_Vendor_Release_Info.Co_No =...

I have and am using Access with Pass-Though to AS-400 (ODBC Client Access) and Linked Tables to MSSQL. Prior to that I used linked-tables to AS-400 (ODBC Client Access). Linking tables directly to AS-400 caused PK problems. The AS-400 had more PKs (in a given table) than Access could handle...

Sounds promising... How could I create a linked server from MSSQL? That would be great and solve additional security issues.

Actually this is an mdb. But... In the forum Bob sent me they talk about a TimeStamp helping Access determine when the records was last updated (for the latest). So... I added a time stamp and have not experienced the problem for the last hour or so. I am going to work with this a bit, it may...

Can an ADP database connect to both MSSQL and AS-400 (iSeries) at the same time? Currently I am using (trying to) connect to MSSQL via linked tables and the AS-400 via pass-through queries. Thank you, Ken

Bob, Even if I go to the linked table directly, no forms or code running, I can add a record. Move to another record. Return to the new record. I cannot edit this new record. Of course after a while (I havent figured when or why) I can edit it fine. Also if I write a sql statement (insert or...

I have an MSSQL back end. One one form I add a record to the database. I can enter anydata that I wish at that time. BUT... If I go to another record then back to it, I get the message the records is in use by another user. This also happens when I go to another form and try to enter any...

Hi all, First I should say I know very little about implimenting OLEDB. Thanks all. I have an MSAccess fe. The be is from both MSSQL and an AS-400 (actually an iSeries but the AS-400 name seems to stick). For MSSQL I create the table in Access first then use the wizard to move the table to...

I had a problem with this Line No 1 2 4 5 6 6.5 6.75 7 8 9 When it got to 6.5 it tried to set it to 7 which caused duplicates. Here is what I ended up with. what do you think? Dim dbC As DAO.Database Dim Rst As DAO.Recordset Dim i As Single i = 1 Set dbC = CurrentDb() Set Rst =...

I would like the records consecutively numbered starting with 1.

I have a table with a PK which is a number (not AutoNumber) for each record. The problem is that, for several reasons, they may not stay consecutively numbered. i.e. they may start 1 2 3 4 5 6 7 8 9 and end up 1 2 5 6 6.5 6.7 8 9 I know how to use DAO, record count to see how many records...

Works great, Thank you,

Hmm, yes I seem to have a lot of reading ahead... This doesn't look easy. Thanks, I think

For my needs I have found that the same users require different levels of security depending on the applications. i.e. in one app the can view everything, in another they could view everything but only write to jobs assigned to them.

In option 1. Each Access app will have it's own secured db (which it already does) and a seperate .mdw file? This will be true for all apps and all users?

I have a (sub)form. It a field is equal to a specific value I want to delete the row. I was thinking of using Form.BeforeUpdate. and if found set Cancel = True and delete the row (record). I can test for the value be how do you delete the record? Thanks,

That is where we started, then we heard horror stories from other users here. In addition to forms that may not open we have controls on forms that may or may not be visible depending on the User Group, diffent sets of data may export, etc... We always use FE/BE. We have starting migrating the...

What is the Shortcut Menu? I usually disable all menus and tool bars and use the SwitchBoard form. From there I do call and open procedure and there check the user group. Depending on the group the form may stay the same be the RecordSource may change. BTW, I use dLookup rather than to set...

We have a winner.... But Why!! It has been working, how did it get ambiguous? What does ambiguous, in relation to Access even mean?

Help. This has been working but now... I get "No Current Record" which I am not even what it is. Update tbl_Job_Access Set tbl_Job_Access.bDelete_Job = 1 Where ( tbl_Job_Access.Job_No= ( Select tbl_Job_Access.Job_No From tbl_Job_Access LEFT JOIN CMSqry_JCPDSC ON tbl_Job_Access.Job_No =...