Recent content by Stildawn

I dont have time, I only have 2 days now And optimizing will take me months.

Oh no that won't work. The front-end is very involved, months and months have gone into it.

How would I do that? Delete the Azure SQL database and start again with SSMA?

Thats a good idea, and will save on the loading times as I can only pull the new data each time rather than the whole lot. Any ideas on the key violations, I have looked over my local tables in Access and looked in SQL Management Studio for the SQL tables but I can't see where they are...

Further to my issue, feel a bit foolish but by turning on the warnings I actually got some useful information: This is the error message I get on each of the not working insert commands, I'm very new to using Azure SQL database so no idea why these three would have an issue and FRT_Table...

You are correct that it could be overwritten, but it will be a non-issue in the short term, many users will "view" the data via the main form etc, but only 1 or 2 will actually update any data and highly highly unlikely at the same time. The updates will likely only be once or twice a month, so...

Hi All I am working on a work around to get my access database ready to deploy as its needed urgently. The work around that I want to use, is to upon form open have the Access frontend pull all data from 4 linked Azure SQL tables into the local tables, then the users uses the forms etc from...

Sorry, I dont know how to do it well. I have this so far that I've worked out myself: Private Sub Combo61_AfterUpdate() Dim strRS As String 'Creates filters based on combobox If Me.Combo61.ListIndex >= 0 Then strRS = strRS & " WHERE ((([Imports FRT Rates].POL)=""" &...

Hi All I am building a form, on it will be a listbox that just contains all columns (minus ID) from the database table. When the form opens, I want the listbox to show all records. Above the listbox will be a bunch of comboboxs that hopefully will filter the listbox below. What I need the...