Hi Guys,
I'm about ready to upsize my Access database to SQL Server because I'm pushing the Access size limit. My database is 1.83 GB and I still have a ton of data to enter. I'm wondering how difficult it will be to upsize and use my existing Access data entry form by linking the tables. My form uses DAO to edit the data and update and delete existing records. The database contains multiple BLOB images per record and each record is blank except for a temporary key that will be updated as I enter data. I did it this way because I needed to know how big the database was going to get after the BLOB data was added, that way I could have an idea how much wiggle room I would have. The database may decrease in size as duplicate images are deleted. But in the end Access isn't going to be able to handle it. What changes will be required in my code to accomplish this? This is the first time I've ever tried this so I'm not sure what I'm getting into. Any assistance you can provide is appreciated.