Search results

I used to set 3 users on SQL database: adm: can create/alter tables, views, procedures, etc write: can insert and update tables inside the database, as well as execute procedures that will change data read: can only run queries or execute procedures that will return data - created most for...

You can run BULK INSERT on SQL Server to import .dat files to the database. Or you can create a SQL Server Integration Services Package to run extract/transform/load and import data to SQL Server. Since Express edition doesn't support this feature, you can use Enterprise or Developer edition.

You can take Larry's suggestion with some changes... Dim strFilePath as String If IsNull([Msample]) Then strFilePath = "\\Web\bass1\pdf\" & [Msample] & ".pdf" Else strFilePath = "\\Web\bass2\pdf\" & [Msample] & ".pdf" End If .Attachments.Add strFilePath And before the .Attachment.Add...

Try changing the constant olFormatHTML to number 2.

Have you tried opening with A2007 on a virtual machine? Another suggestion is try to decompile/compile/compact/repair the database. In most cases here, I fixed these kind of errors using there 4 actions, on this exact order. If is possible, do it on A2007 version (it can open older mdb files).

Hello, Bob. To ensure that both tables will be filled with the same information, we need a field that must contain the same information (like a company legal register or tax ID). Then we can make a trigger in tblSuppliers to update tblDistributors when the first is updated. Of course we cant...