Search results

Hi, I recently migrated a split access db to Azure SQL Server. Really happy with the performance of SQL Views in SQL Server. I need to build a search form for searching text of supporttickets. In TSQL in SSMS i can perform queries like this one: select * from Supporttickets where...

Hi, I'm reconstructing an access database having linked tables to Azure SQL Server. One of the techniques I use is setting a recordsource only when needed. THis makes loading a page with tab-control much faster. The following code shows part of the sub where the recordsource is set. The form...

Hi, In short: - I started with a database with relations between tables - I managed using SSMA to transfer this to Azure SQL. (yes, I needed to install the RT version of Access to prevent crashing of SSMA) - Relations between tables in Azure SQL are available. If I create a diagram...

Hi, We have a split database. I used the migration tooling to migrate tables to an Azure database. All tables have been renamed from TABLENAME to DBO.TABLENAME because of the way to use SQL in a proper way. My frontend however is using the plain tablenames. What's the best way to go: rename...