Stumped

[pr2-eugin]

That is very strange.. Can you Upload a Stripped DB.

To create a Sample DB (to be uploaded for other users to examine); please follow the steps..

1. Create a backup of the file, before you proceed..
2. Delete all Forms/Queries/Reports that are not in Question (except the ones that are inter-related)
3. Delete auxiliary tables (that are hanging loose with no relationships).
4. If your table has 100,000 records, delete 99,990 records.
5. Replace the sensitive information like Telephone numbers/email with simple UPDATE queries.
6. Perform a 'Compact & Repair' it would have brought the Size down to measly KBs..
7. (If your Post count is less than 10 ZIP the file and) Upload it..

Finally, please include instructions of which Form/Query/Code we need to look at. The preferred Access version would be A2003-A2007 (.mdb files)

 

[TheSearcher]

Paul,
I keep getting an "Invalid File" message when trying to upload - probably because my WinZip only creates .zipx files. I tried to use the "classic" feature but it will not create a .zip file - only .zipx.
So - all that needs to be done is to:
Create a table called t_Submissions with one field called SubmissionDates (This filed should be a Date/Time datatype). Then simply create a module that contains the TestMe procedure that you submitted earlier.
Add the "then" to your "If" statement so the code could compile. Run TestMe in the immediate window. You will always get the "Record already exists" message. My stripped db is only 388 kb but the rules are (I believe) that only zip files can be uploaded.
Thanks again for your help,
TS

 

[Mihail]

This is free and as good as any others.

 

[pr2-eugin]

You do not have to ZIP the file, that is only for users with Post Count < 10..