Discussions - comp.databases.ms-access

I have come across [link] by Martin Green. He seems to be a gifted teacher (so I recommend the site for some things like using SQL in the recordSource property of a form or using SQL from within VBA). I am inclined to send the website $10 for the free materials I've used via PayPal. However, I don't trust websites without a recommendation from some... more »

By Strasser - 6:45am - 1 new of 1 message

	OT. Spellcheck this! Ded.
	Something to amuse you regarding Office 2010...Office 2010: The Movie [link] By Salad - Nov 11 - 1 new of 1 message

	einfach geld verdienen im , holdem poker online , kostenlos pokern lernen , backgammon online geld , geld leicht gemacht , nebenjob internet geld verdienen , leicht geld verdienen in , online spielen ohne geld , software geld verdienen , durak spi
	einfach geld verdienen im , holdem poker online , kostenlos pokern lernen , backgammon online geld , geld leicht gemacht , nebenjob internet geld verdienen , leicht geld verdienen in , online spielen ohne geld , software geld verdienen , durak spielen online , * * * +++ GELD ONLINE VERDIENEN +++ GELD IM INTERNET VERDIENEN +++... more » By gabi meier - Nov 11 - 1 new of 1 message

SQL Server connection security

Hi All, I am finally (finally!) changing the habits of a lifetime and no longer concentrating on building Access FEs that connect to a SQL Server database within their Windows domain. No, now I have started to connect to a hosted SQL Server backend via the Internet. Good old Fasthosts are storing my data, and the dsn-less connection hooks into... more »

By auntiejack56 - Nov 11 - 1 new of 1 message

	Auto number
	I have an autonumber field to generate a REF. I need to copy my table because of problem but when I do this I loose my auto-number ref, how can I get around this (some records have been deleted therefore can nt just recreate it. By Paul - Nov 11 - 2 new of 2 messages

the search key was not found in any record & Invalid Argument

Hi, I have a database which has been in use for 2 years. Now all of a sudden when one particular user enter a date into a field all information within that record the text changes to Chinese style characters. Also I am unable to navigate to the next record as i get 'Invalid Argument' error warning. The database is split into front end and back end but I am unable to... more »

By Paul - Nov 11 - 3 new of 3 messages

	Datasheet View
	Why do hidden controls on a form display themselves in datasheet view? By Mat - Nov 10 - 7 new of 7 messages

	AddNew
	Hi all I'm importing a txt-file to an SQL-server db via Access (linked files). I therefore use ado, with of course the addnew method of a recordset opened with CurrentProject.Connection, adOpenDynamic, adLockOptimistic I now see the addnew is extremely slow. Output is several millions of rows, so it's taking hours if not days to run.... more » By Daedalus - Nov 10 - 3 new of 3 messages

	Continuously monitors Outlook and stores email data in database.
	Is there a way for access to continuously monitor Outlook (sending/ receiving) and store email data in database? By shanq - Nov 10 - 2 new of 2 messages

Where to find the Icon path as specified in the Startup form

Dear reader, In the Startup form you have the possibility to Browse to an application Icon. In case you runs the program always on the same location this Icon location is working. But if you copy the application to an alien PC the path to the Icon is not longer valid. Is there someone who knows where this path is stored in the mdb? So you can... more »

By Simon - Nov 10 - 2 new of 2 messages