By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,871 Members | 2,444 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,871 IT Pros & Developers. It's quick & easy.

script help

P: 3
I've been importing logs into Access 03 untill recently it crashed and gave me an invalid argument error. I believe the reason is because I hit the 2 gb limit that it allowed me to have. So to fix this I was trying to create this in a form.

It Gets the last date the table I have was updated.

Then it grabs each time log text file from the logs directory.

and then imports from that date + 1 day, to 1 day before the current day


I'm hoping to get this form to load before the database starts up.

Thanks
Jul 18 '07 #1
Share this Question
Share on Google+
5 Replies


P: 3
Anybody got any feedback on this ?
Jul 19 '07 #2

puppydogbuddy
Expert 100+
P: 1,923
Anybody got any feedback on this ?
If you are approaching the 2 GB limit, you have several alternatives, but you better do something quickly. Make sure you have several "good" backups of your existing mdb in a safe place. Here are a few options you have.
1. Convert to Access 2007, which has a 4 GB limit.
2. Split the MDB into Front End (FE) and Back End (BE) components, upsizing the back end to an Access ADP or SQL server. The ADP approach would be more of a short term solution and the SQL server would be a long term type of solution
3. Split the MDB into one or more MDBs based on a logical grouping of tables Then create a blank MDB (same name and structure (no data in tables) as the original MDB) and put links from all the tables in the split MDBs into this one MDB. Test the app to see if the pure Access FE and BE works. If it works, you have bought some time.


see this link on splitting the mdb into FE and BE components for network use.
http://www.members.shaw.ca/AlbertKal...plit/index.htm

see this link if you are considering converting to Access 2007:
http://allenbrowne.com/Access2007.html
Jul 19 '07 #3

puppydogbuddy
Expert 100+
P: 1,923
PS:
It is not clear what you are trying to accomplish with your form idea, please provide more details.
Jul 19 '07 #4

P: 3
I wanted this form to load when the database starts? I'm not really sure what information you were looking for but please keep me posted and I'll try to answer it.

Thanks
Jul 20 '07 #5

puppydogbuddy
Expert 100+
P: 1,923
I wanted this form to load when the database starts? I'm not really sure what information you were looking for but please keep me posted and I'll try to answer it.

Thanks
I provided you several alternatives options that are the usual choices that you would have if you are approaching the 2 GB limit. You are proposing this "form" at db startup as another option that you want a VBA script for. How is this form going to solve your 2GB limit problem? Please provide more details.
Jul 20 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.