Update table in database from another database.

I have two databases, DB1(SQL Database) and DB1 (access database). I opened an empty access database and linked to DB1 and DB2, now I want to update table in DB2 using data from DB1. Can someone please help me with the query?

DB1                                                      DB2
TABLE1                                                TABLE1                        TABLE2
ID_field                                                id2_field                      id2_FIELD
property1                                           property1                    ID_field
property2                                           property2


Here the challenge is the receiving table (DB2 TABLE1) does not have the same Id_key (ID_filed)  so I have to use TABLE2.
Any help would be appreciated.
Thank you.

How do I Import data that has more than 65535 rows of data?  The follwoing code below is what I use to import data from excel to an access table , the problem I'm having is that I have 159000 rows of data and I'm being limited to import only 65535 rows in access.  Is there way I can import the entire data?

Sub ImportEA()
    Dim acc As New Access.Application
    acc.OpenCurrentDatabase "X:\Procurement\TTE\SAMS_v1.0.accdb"
    acc.CurrentDb.Execute "Delete * from tbl_EA"
    acc.DoCmd.TransferSpreadsheet _
            TransferType:=acImport, _
            SpreadSheetType:=acSpreadsheetTypeExcel12Xml, _
            TableName:="tbl_EA", _
            Filename:=Application.ActiveWorkbook.FullName, _
            HasFieldNames:=True, _
            Range:="EA$B:S"
    acc.CloseCurrentDatabase
    acc.Quit
    Set acc = Nothing
End Sub

I have a client with an Access application. The system has a front-end linked to a back-end running compatibility mdb files. There are approximately  10 users connected to the application using various versions of Microsoft Office.  The system is experiencing frequent issues which appears to be corruption in the database. When this happens they are receiving  “Disk I/O error trying to read” and sometimes “Unrecognized database format J:\Purchasing\Inventory Control\MICBE_NA_1.0.2.mdb”  error messages. Originally it appeared that these issues occurred when a single table was being read "Item_Master". However yesterday this happened when a user clicked a bound checkbox having now connection to the Item_Master table.  One time the primary key was destroyed in their PurchaseOrders table which we were able to fix after identifying and fixing duplicate key records.

We have continually executed compact&repair procedures and also decompliles.

I know we need to upgrade the back-end to SQL Server but my client is reluctant to do it because they like to connect directly to tables and queries for data entry and maintenance.

If they upgrade to the newer "accdb", is that likely to solve the corruption issue? Are there any procedures we should try to see if we can identify the cause and solution.

Thank you very much!!

I have a Microsoft Access 2003 database with security enabled with a security.mdw file. I would like to remove all security, delete the mdw file and covert to 2016 Access if possible.

There is a similar question that was posted here a while ago but the link to the answer is broken.

any help would be much appreciated.

Thanks
Bob

Hi,

I have an access application coded in MS Access 2010 and I wanted to know if there is an upward compatibility with MS Access 2019.

Also,

Is MS Access can be used as a stand alone application on a PC vs. a subscription License based application ONLY in that case I have to deal with unintended consequences due to updates pushed by Microsoft.

Guidance will be appreciated.

Hi Experts,

I faced a database query issue ... I tried to solve it myself (I'm using VB.Net  VS 2015)but my solution i think that is not perform the mission well ...OK

I have a product put in more than one partition "say 2 partitions" (it must be more than 2 partitions)these partitions filled with the products as follow ...

product1  ==>>(partition1 =  5 pieces) and (partition2 =  1 pieces)   and total pieces of  product1 = 6 pieces...... and
product2  ==>>(partition10 =  1 pieces) and (partition15 =  0 pieces) and (partition3 =  0 pieces) and total pieces of  product2 = 1 piece
product3  ==>>(partition10 =  0 pieces) and (partition2 =  1 pieces) and (partition1 =  0 pieces) and total pieces of  product3 = 1 piece
product4  ==>>(partition2 =  2 pieces) and (partition3 =  1 pieces)   and total pieces of  product4 = 3 pieces
 The question is how to query in my database to find if the (total pieces of  specific product) became =1 piece
in order to make a report of the products that decreased and need to purchase  



I think this photo is enough to indicate my needs ... The blue line indicates that ProductCode '6' has 3 partitions and total pieces = 4
The Red line indicates that ProductCode '8' has 2 partitions and total pieces = 1               ........................
when i made a query on 'StockNo' in the database  i get all 'StockNo' that have 1 piece not the total pieces of   'StockNo'  for specific product code.

Any Suggestions…

Hi Experts,

I have an Access application linked to MS SQL 2008.

Trying to run an append query as follows

INSERT INTO Skilled_Nursing_Visit_Note ( SNV_ID, Client_Last_Name, Visit_Date, Date_Of_Birth, Medical_Record_Number, Shift_From_Hour, Shift_To_Hour, Purpose_Of_Visit_Goal, Temp, Pulse, RR, BP, O2_Saturation, O2_In_Use, Respiratory_Lung_Sounds, Respiratory_Breathing_Pattern, Bipap, Cpap, Vent, Vent_BIPAP_Settings, Cardiovascular_Skin_Color, Skin_Temp, Cardiovascular_Edema, Neuro_Alert, Neuro_Oriented, Neuro_Self_Directing, Neuro_Dev_Delay, Neuro_Deficits, Neuro_Notes, GI_Oral_Tube_Feeding, Current_Feeds, Gastric_Residuals_Present, Residual_Volume, MD_Called, Abdominal_Assessment, Feeding_Tolerance, GU_Incontinent, Number_Of_Diaper_Changes, Urine_Stool_Volume_Description, Bedbound, WheelChair, Ambulatory, Mobility_Aids, Contractures, Musculoskeletal_Notes, Pain_Score, Pain_Notes, Medication_Changes, Medication_Changes_2, Integument_Skin_Assessment, Skin_Care_Measures_Taken, Home_Environment_Safety, Treatments_Administered, Patient_Response, Instructions, Understanding, Plan_Goal, Nurse_Signature_Last_Name, Signature, Date_Signed, Nurse_Name_Stamp_SNV, Nurse_User_ID_num_SNV, Medication_Changes_Yes, Acknowledge_Accuracy, Trach, CCM_Informed, Tube_Type, Reviewed_Status, Reviewed_By, Reviewed_stamp, Client_First_Name, Nurse_Signature_First_Name, Shift_From_Minute, Shift_To_Minute, Patient_Unable_To_Sign, Reason, Status )
SELECT V_Visit_Note_Export.SNV_ID, 

Select all Open in new window

…

I have 5 combo boxes on Form 2 and a list box on Form. The row sources are queries. The 5 combo boxes all have the options to from text1,
 text2, text3, text4, and text5. I want to be able to select 1 of the 5 or select a combination. To display information containing text1, text2, and text3. How would you write this in vba coding?

hi,
I'm prototyping a system in MS Access, it will act as a server and process requests in a queue.
The queue will be a series of files on the pc.
Requests will be submitted by a webform.

What reasonably quick and easy ways can I get the web requests sent to the queue?

I'd like to get a response time of say 1 second.

The request queue would be written to the web server, what would be a quick way to sync this? I could get MS access db to check every second but maybe there's a better way.

I'm new to web development so please forgive any obvious ignorance here.

Thanks

I have an MS Access 2016 Database linked to a SharePoint list , users will many times work on the access database offline thus catch changes locally, when online again, user has to manually click reconnect to tables as showing in picture 1 :

then manually click the synchronize ribbon in picture 2:

I am thinking use VBA to automate this two manual steps, for instance, auto-connect tables and sync database on open, or similar solutions, i thought this would be straightforward because many users need this as Access is a good offline front-end solution for server database, however I have not got any useful information on internet yet.

Hello All,
is there a way to add a sequence number into a query?
thanks a lot

I have this VBA
            strTempFile = "C:\OrderAck\OrderAck" & strCurrentOrder & Format(Date, "DD-MM-YYYY") & ".pdf"
            DoCmd.OutputTo acOutputReport, "rpt_Automail", "*.pdf", strTempFile, False

Was working fine, now just ends on the Docmd without any error (I do have an err trap)

Anybody got any Ideas?