I recently split an Access 2002 database. The data is in a seperate database and is linked to the other with the code. The problem is I had a SQL statement that alters one of the tables (DoCmd.RunSQL "ALTER TABLE tblInvoice ALTER COLUMN InvoiceNumberCounter COUNTER (" & InvoiceNumber & ",1)"). The problem is that now that the database is split in two, I am getting the following error: "3611 Cannot execute data definition statements on linked data sources.".
Any suggestion on how to acheive the alter statement abouve on a lined table?
Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …