+- MacResource (https://forums.macresource.com)
+-- Forum: My Category (https://forums.macresource.com/forumdisplay.php?fid=1)
+--- Forum: Tips and Deals (https://forums.macresource.com/forumdisplay.php?fid=3)
+--- Thread: Working around Access' 2GB limit (/showthread.php?tid=8183)
Pages:
1
2
Re: Working around Access' 2GB limit - Greg the dogsitter - 03-29-2006
mattkime Wrote:
-------------------------------------------------------
> >>Not feasible, in this particular
> situation.
>
> Then they want what they can't have.
>
> $400 for a Mac Mini with MySQL on it.
>
> How much is your time worth?
You don't need to convince me there may be better software for this task.
What's the MySQL equivalent of doing a scripted VBA import in Access? For instance, I have a script that loops through every quarter from 2005_01 to current, and imports one file for each quarter. How would that by done with MySQL?
Re: Working around Access' 2GB limit - mattkime - 03-29-2006
>>How would that by done with MySQL?
Command line with the mysql client.
OR
You can use MySQL as a data source in access
Re: Working around Access' 2GB limit - mattkime - 03-29-2006
>>You don't need to convince me there may be better software for this task.
ahh....one of those clients
Re: Working around Access' 2GB limit - maurycy - 03-29-2006
MS SQL Server 2005 Express edition has database limit of 4GB. This will double your available db space.
Maurycy