Hi, I have an access database with a lot of attachments, and the size of the access database file has reached 1.5GB, so I am trying to find a solution for the limitation of 2GB. I have followed your video step by step, but unfortunately, I have errors with the tables that have attachment as shown "not supported," can you please advise what I can do in this case.
Hi Adly, you need to export the attachements to files and then remove the columns from the tables, than you can upload the data to SQL Server. Once you have the tables created you can add a column of type BLOB and use that to store files in SQL Server. For more help you can visit UtterAccess.com or you can seek professional help, let us know if you need the latter for a referral.
Hello. Thank you for your sharing. I would like to ask something to you. Please give me some ideas. I am now using local SQL server and microsoft access database. Let's say I would like to upgrade Northwind database into SQL server. I put new data from Forms and would like to update that value into SQL server. Does it make sense? If yes, what do I need to do?
Hello, I am not sure if I am following you exactly. The key to having your SQL table be updated from a Form in Access, is to have a Linked table in your Access database that links to your SQL Server table. Then your form should have that linked table as a data source. You will also want to make sure that you have a primary key set on the linked table so that it is updateable. Does this answer your question? If not please try to explain further.
Instruction begins at 4:49
Hi, I have an access database with a lot of attachments, and the size of the access database file has reached 1.5GB, so I am trying to find a solution for the limitation of 2GB. I have followed your video step by step, but unfortunately, I have errors with the tables that have attachment as shown "not supported," can you please advise what I can do in this case.
Hi Adly, you need to export the attachements to files and then remove the columns from the tables, than you can upload the data to SQL Server. Once you have the tables created you can add a column of type BLOB and use that to store files in SQL Server. For more help you can visit UtterAccess.com or you can seek professional help, let us know if you need the latter for a referral.
Hi I’m using the same bit versions but still getting the bit error!
Make sure you set all BIT fields in your SQL server tables to default to zero
Hello. Thank you for your sharing. I would like to ask something to you. Please give me some ideas. I am now using local SQL server and microsoft access database. Let's say I would like to upgrade Northwind database into SQL server. I put new data from Forms and would like to update that value into SQL server. Does it make sense? If yes, what do I need to do?
Hello, I am not sure if I am following you exactly. The key to having your SQL table be updated from a Form in Access, is to have a Linked table in your Access database that links to your SQL Server table. Then your form should have that linked table as a data source. You will also want to make sure that you have a primary key set on the linked table so that it is updateable. Does this answer your question? If not please try to explain further.
Hello🤗, I just wanna ask if how to link SQL data to another computer, i.e working station
Can you clarify what you mean Vincent? What version of SQL Server are you using and where is it at/installed?
@@mariabarnes6376 SQL 2014. It installed in my server
And you can create a link to it from one workstation but not the other?