Search results

i c, well about 5 unopenable databases later, i finally have a tidy database with 3 accounts admin (cant remove it!?) administrator (owns everything) and Ronly part of the ReadOnly group. but much to my dismay, word2000 cant get its head around mail merging with a database that has user...

so what your saying is i cant setup user accounts for my access database just inside that particular database, i have to create an associated 'workgroup file' that i would need to distribute WITH my database? All i want is an admin account for my vb program to use and a read only account for...

thanx guys this is exactly what i want. i'm actually developing this application in visual basic, so it shouldnt be too much trouble to switch to these other tables. thanx again.

can't i do some kind of data dump?

umm whats a maketable query? like an sql create table thing? i dont mind about size at all. i just need to copy an image of the online table every day or so, so that if net connection is lost, they can 'read only' with the last saved image. my efforts at copying the table, only copies the link...

Firslty, hello, this is my first post. umm secondly, my problem! I have an access database that has a couple of tables, 2 of which are linked to mySQL ones ONLINE (thru myODBC). This works great, but before i continue my project, i have to be sure that if for some reason the user's internet...