K
Klutzz
Thanx in advance for any info that anyone can provide.
I have a small access DB that we are using to query a couple of third party
databases. I am trying to upsize this to an SQL server.
The access db uses linked tables to the 3rd party databases and everything
works fine untill I upsize. It appears that once I do this the tables do not
update on the sql server like they do in access. Is this by design or am i
missing something. If its by design what can I do to program around it ,
otherwise what should i be looking for as far as why the upsizing is causing
me to lose this functionality ?
I was thinking that maybe it had to do with indexing or primary keys in the
linked tables but I also cannot figure out how to add a key to the linked
tables.
Any advice is greatly appreciated !!
I have a small access DB that we are using to query a couple of third party
databases. I am trying to upsize this to an SQL server.
The access db uses linked tables to the 3rd party databases and everything
works fine untill I upsize. It appears that once I do this the tables do not
update on the sql server like they do in access. Is this by design or am i
missing something. If its by design what can I do to program around it ,
otherwise what should i be looking for as far as why the upsizing is causing
me to lose this functionality ?
I was thinking that maybe it had to do with indexing or primary keys in the
linked tables but I also cannot figure out how to add a key to the linked
tables.
Any advice is greatly appreciated !!